Informatica: Sourcing different files with similar structure into single target

Lets say we have a situation where we need to load multiple different files of similar structure into single target using 1 mapping and workflow.

Lets say we have country wise customer information in files.

  1. Customer_US.txt
  2. Customer_CAN.txt
  3. Customer_PK.txt
We will build a single mapping and a single workflow same way as we have to do for single file.
All we need is to set partition property and set source names.

Open session task in edit mode. Then go to mapping tab and select "Partition" as shown below

Now double click on source qualifier and add as many partition as required.

By adding partitions in source qualifier it will automatically add partitions in target. as shown below

No go back and set source properties as shown below.
Source: 

If we set only Partition #1 and left others empty then empty partitions will take Partition#1 information.
By doing Partitioning, we can also improve performance.

Comments