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

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

Question Posted / jey.dgl

4 Answers
8908 Views
TCS, I also Faced
E-Mail Answers

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