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


Please Help Members By Posting Answers For Below Questions

What is the need for an etl tool?

628


What is domain and gateway node?

686


How many types of sessions are there in informatica.please explain them?

668


Whats the difference between informatica powercenter server, repositoryserver and repository?

666


What are mapplets?

811






Differentiate between reusable transformation and mapplet.

561


whats the logic to load the lower level of granularity of data to fact table.

1789


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

1688


What is the scenario which compels informatica server to reject files?

598


How to improve the performance of a session using sorter transformation?

681


Explain transaction control transformation in informatica

755


Explain what is informatica metadata and where is it stored?

600


What do you mean incremental aggregation?

620


What is the benefit of partitioning a session?

620


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?

8521