Replicating the Record in Target in Informatica.

My Source is like:
Sno Name
1 XXXX
2 YYYY
I want the Target like:
Sno Name Frequency
1 XXXX 1
2 YYYY 2
2 YYYY 2
How can I replicate the "2 YYYY".
I am supposed to make it dynamic for all possible frequencies.

Questions by imbadenough

Showing Answers 1 - 1 of 1 Answers

Visal

  • Aug 13th, 2016
 

From what I understood from the scenario given above, you want to duplicate some particular type of record. use Router and write the same condition (say column1=2) for both output group. Remember default group output will contain all other records and later join all outputs into one target table (as needed).

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions