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 / omkar
use router transformation
in that give condition 1st row id to 1st target
and so..
Is This Answer Correct ? | 0 Yes | 9 No |
Post New Answer View All Answers
What is the need for an etl tool?
What is domain and gateway node?
How many types of sessions are there in informatica.please explain them?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are mapplets?
Differentiate between reusable transformation and mapplet.
whats the logic to load the lower level of granularity of data to fact table.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is the scenario which compels informatica server to reject files?
How to improve the performance of a session using sorter transformation?
Explain transaction control transformation in informatica
Explain what is informatica metadata and where is it stored?
What do you mean incremental aggregation?
What is the benefit of partitioning a session?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?