Wednesday, March 13, 2013

Pass Through Mappings

Pass through mappings are used in Informatica to insert all source rows into target in situations where we don’t have to keep the history of data. For example if you take the case Invoice table, at the end of the year we will have new invoices, hence we need to drop the existing dimension and reload the entire table. We use TYPE 1 Dimension Mapping preferably for records which change incrementally.

A single pass through mapping will have source definition. Source qualifier, and an Expression Transformation, and target table. While customizing the mapping we can add other transformations also.

Now let’s see how to create a Pass through Mapping
  •     Click Mapping Wizards and in that select for Simple Pass Through.
  •     Give mapping name m_Mapping.
  •     Select source definition name
  •     Enter the mapping target table T_TargetName
Overall we can say that pass through mapping performs following tasks
  •     Select all source rows
  •     Insert all rows into Target

No comments:

Post a Comment