I have a scenario like - how can i load 1st record to
Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to
repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
- 3 Answers
- 8798 Views
- ITC Infotech, TCS, I also Faced
- E-Mail Answers
Answer Posted / avatar dss42b88
for this we use sequence generator t/r,
ex take source emp
targets -emp1,emp2,emp3.
mapping structure
sq->(seq)->exp->rtr->emp1(condition rowid=1)
->emp2(condition rowid=2)
->emp3(condition rowid=3)
in exp t/r add new port and rename it as rowid and connect
to rtr.
note connect next val to rowid(in exp t/r).
in seq t/r change properties like
start value=1
increment by=1
last value=3
currval=1
cycle check it save it.
execute mapping.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Explain the different lookup methods used in informatica?
Clarify the aggregator change?
What is a repository manager?
How to join three sources using joiner?
How is union transformation utilized?
How identifying bottlenecks in various components of informatica and resolving them?
What is a transaction control transformation?
What is an expression transformation in informatica?
What is a predefined event?
Sequence generator, when you move from develoment to production how will you reset
What is the use of transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
what are 3 tech challenges/ common issues you face?
Explain what are the different types of transformation available in informatica.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
