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
- 9998 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
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is meant by pre and post session shell command?
what is the size of u r source(like file or table)?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is Session and Batches?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Define mapping and session?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Sequence generator, when you move from develoment to production how will you reset
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is informatica worklet?
what is Active lock explain
what is the hint? how to use it to reduce the query processing in program?
Explain joiner transformation in informatica
Why do you use Mapping Parameter and mapping variable?
