Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10200 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
Differentiate between joiner and lookup transformation?
Explain sessions. Explain how batches are used to combine executions?
What are the features of complex mapping?
What does refresh system mean, and what are its distinctive choice?
What is rank transformation?
What is the benefit of session partitioning?
What are different types of transformations available in informatica?
What are the differences between joiner transformation and source qualifier transformation?
differences between service based and product based?
What are the various types of transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What does reusable transformation mean?
What is data transformation manager process?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What are the different lookup cache(s)?
