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

What is galaxy shema

2 Answers   CGI,


how to use incremental load?

2 Answers   TCS,


Explain the code page compatibility?

1 Answers  


What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  


What is a dimensional model?

1 Answers  


how to sort date field in infomatica?

2 Answers  


How to go to the older version for a mapping?

1 Answers  


how DTM buffer size and buffer block size are related

3 Answers   Wipro,


I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,


How can u stop a batch?

2 Answers  


why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,


What is power play plug in?

2 Answers  


Categories