Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9704 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
Do you find any difficulty while working with flat files as source and target?
What are the different ways to implement parallel processing in informatica?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the different transaction levels available in transaction control transformation?
What is the cumulative sum and moving sum?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is the difference between a repository server and a powerhouse?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
State the differences between sql override and lookup override?
State the limitations where we cannot use joiner in the mapping pipeline?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are the various types of transformation?
How to extract sap data using informatica?
Tell me about Propagate functions in informatica
Explain the difference between a data warehouse and a data mart?
