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 are the uses of etl tools?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is update strategy transform?
How many ways are there to create ports?
What does refresh system mean, and what are its distinctive choice?
Enlist the differences between database and data warehouse.
What are the differences between joiner transformation and source qualifier transformation?
What are the databases that informatica can connect to windows?
In how many ways we can create ports?
What is informatica etl tool?
Different qualification between a related rotate toward the sky and isolates look upward?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
waht type of interface is used for testing the data in informatica
In informatics server which files are created during the session rums?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?