i have 1000 record flat file source i want 1st row to 1st
target, 2nd row to 2nd target, 3rd row to 3rd target how will
u do? Without using Mod Function? Explain....

Answer Posted / davankumar

1st take squence t/t conn expresion t/r to one out put port.
In sequence t/r enable cycle option and start value is 1
end value is 3 and increment by 1.
then take rouder t/r in 1st group nextval/3=0 then 1st
target,nextval/3=1 then take 2nd target then connect to
default group ok.. r u clear...

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In development project what is the process to follow for an etl developer from day1

1372


In warehouses how many schemas are there?

676


difference between informatica 8.1.1 and 8.6

3349


can anyone suggest best free Talend data integration training online

1348


How might you approve all mappings in the archive all the while?

707






How can you increase the performance in joiner transformation?

807


Explain incremental aggregation in informatica

746


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

753


Which development components of informatica have the highest usage?

694


What is data movement mode in Informatica and difference between them?

722


waht type of interface is used for testing the data in informatica

1926


What is a code page?

800


What is an expression transformation in informatica?

634


What is meant by lookup transformation? Explain the types of lookup transformation?

652


Briefly define a session task?

678