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.
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).
Replicating the Record in Target in Informatica.
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
Related Answered Questions
Related Open Questions