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

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  


What are the active and passive transforamtions?

2 Answers  


A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  


TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,


How do you implement unconn. Stored proc. In a mapping?

1 Answers  


how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,


Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  


Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  


What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  


explain about lookup t/r?

1 Answers   IBM,


What is the difference between informatics 7x and 8x and what is latest version?

0 Answers  


Why sorter is an active transformation?

0 Answers   Informatica,


Categories