we have 6 records in source , i need 2nd record in one
target and 5th record in one target or 2nd & 5th record in
same target.
Answer Posted / pavan
using Router transformation we can solve this.
create as many conditions u want.
Suppose,if rownum=2 then flow the data to target 1
if rownum=5 then flow to another target
go on....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to delete duplicate row using informatica?
How can we update a record in the target table without using update strategy?
Explain constraint based loading in informatica
Describe expression transformation?
What does reusable transformation mean?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How can we remove the duplicates from flat file source?
Whats the difference between informatica powercenter server, repositoryserver and repository?
If informatica has its scheduler why using third party scheduler?
Clarify the utilization of aggregator cache record?
What is the difference between informatics 7x and 8x and what is latest version?
What are the limitations of joiner transformation?
How to use pmcmd utility command?
How many ways are there to create ports?
What is the command used to run a batch?