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....

Answers were Sorted based on User's Feedback



i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row t..

Answer / mithilesh kumar rai

step 1. Pass the value from Source Qualifier to Expression.
step 2. Take a Sequence Generator and Enable the Option
Reset and set endvalue=3 , (take Sequence generator
before expression and pass value nextval of SG to Exp.

step3. after Exp, take router in router make 3 group
1st Group: Nextval=1
2nd Group: Nextval=2
3rd Group: Nextval=3
Step 4: Pass the value to Target.

Is This Answer Correct ?    13 Yes 2 No

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row t..

Answer / 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

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row t..

Answer / vidyadhar tilve

use transaction control

Is This Answer Correct ?    0 Yes 0 No

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row t..

Answer / ramakrishna

simple before targets put the sequence generator t/f enable cycle option put start value 1 and end vale 3 connect to all three target

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,


explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,


why normalizer transformation can not used in mapplet? plzzzz answer

2 Answers   Syntel,


i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,


Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,


what is the difference between lookupoveride and joiner?

3 Answers  


in which situations do u go for starflake schema ?

6 Answers   TCS,


If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  


Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  


what is scd?

6 Answers  


In target table how to display the system time

1 Answers  


What is aggregate cache in aggregator transforamtion?

5 Answers  


Categories