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 standalone command task?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How we can create indexes after completing the load process?
Explain direct and indirect flat file loading (source file type) - informatica
What is a repository? And how to add it in an informatica client?
What is data caches/ index caches?
How many ways are there to do 'remove duplicate records in informatica'?
Differentiate between a repository server and a powerhouse?
Explain what is informatica metadata and where is it stored?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is status code in informatica?
Explain lookup transformation is active in informatica
What is a snowflake schema?
What are the different transaction levels available in transaction control transformation?
How to open an older version of an object in the workspace?