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
- 8800 Views
- ITC Infotech, TCS, I also Faced
- E-Mail Answers
Answer Posted / susanta
Take a sequence generator with Start Value=1,Current
Value=1,End Value=3, Increment By=1 to assign a seqno to
each row. Do not forget to enable the cycle option.
after that take a Router with three groups of
seqno=1,seqno=2 and seqno=3.
Hope this will help u
| Is This Answer Correct ? | 28 Yes | 1 No |
Post New Answer View All Answers
Define Pmrep command?
Explain the difference between mapping parameter and mapping variable?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How do we call shell scripts from informatica?
What are junk dimensions?
How are indexes created after completing the load process?
Do you find any difficulty while working with flat files as source and target?
What does update strategy mean, and what are the different option of it?
What are the new features of informatica 9.x developer?
How to use procedural logic inside infromatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain the tuning lookup transformation - informatica
How to Create a folder using pmrep command?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Explain sessions. Explain how batches are used to combine executions?
