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.

imbadenough
Profile Answers by imbadenough Questions by imbadenough
Oct 4th, 2012
2
6625

Questions by imbadenough

Data Warehousing

Answer

Showing Answers 1 - 2 of 2 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).