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....
- 4 Answers
- 8911 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to create the source and target database connections in server manager?
How can you differentiate between powercenter and power map?
can u any challenge your project?
How to configure mapping in informatica?
Explain sessions and how many types of sessions are there?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are mapplets?
What does command task mean?
What is persistent lookup cache?
How to delete duplicate row using informatica?
Differentiate between Load Manager and DTM?
Explain dynamic target flat file name generation in informatica
Clarify the aggregator change?
How can we use mapping variables in informatica? Where do we use them?
