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
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 |
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 |
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 |
What is galaxy shema
how to use incremental load?
Explain the code page compatibility?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
What is a dimensional model?
how to sort date field in infomatica?
How to go to the older version for a mapping?
how DTM buffer size and buffer block size are related
I want skip first 5 rows to load in to target? what will be the logic at session level ??
How can u stop a batch?
why we are using level option in normalizer transformation
What is power play plug in?