As an example consider the source flat file data as
Informatica Enterprise Solution Informatica Power center Informatica Power exchange Informatica Data quality
The target flat file data should look as
Informatica Data quality Informatica Power exchange Informatica Power center Informatica Enterprise Solution
Follow the below steps for creating the mapping logic
Variable port: v_count = v_count+1 Output port o_count = v_count
Q2) Load the header record of the flat file into first target, footer record into second target and the remaining records into the third target.
The solution to this problem I have already posted by using aggregator and joiner. Now we will see how to implement this by reversing the contents of the file.