following scenario i have 1000 record flatfile source i
want ist row to ist target 2nd eow to 2nd target 3rd row to
3rd target how will u do?
Answer Posted / venkat
->Connect desired columns to Expression and create custom
colum.
->Use Sequence Gen inorder to generate cyclic values 1,2,3
logic :start with 1 ,increment by 1 and end with 3
Cycle -Yes.
->Connect it to Custom column
->Use Router to rout coresponding group
Group1 -Value1- Target1
Group2 -Value2- Target2
Default-Value3- Target3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is degenerated dimension?
What you know about transaction control transformation?
can anyone explain me about retail domain project in informatica?
What do mean by local and global repository?
How to do the error handling of if ur source is flatfiles?
What is a transaction control transformation?
What is the advantage of informatica?
Write the different tools in the workflow manager?
Which transformation is needed while using the Cobol sources as source definitions?
lookup transformation with screenshots
Explain in detail about scd type 1 through mapping.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is primary and backup node?
What are the different ways to implement parallel processing in informatica?
How to create Target definition for flat files?