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 |
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
What are the active and passive transforamtions?
A session S_MAP1 is in Repository A. While running the session error message has displayed
TELL ME ABOUT WORK FLOW SCHEDULING?
How do you implement unconn. Stored proc. In a mapping?
how to run 2 workflows sequentially. plz respond what is the process?
Filter transformation in the condition one of the data is NULL would the record be dropped.
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
What is the main difference between a Joiner Transformation and Union Transformation?
explain about lookup t/r?
What is the difference between informatics 7x and 8x and what is latest version?
Why sorter is an active transformation?