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
- 9803 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
What is the function of look up transformation?
What is substr in informatica?
whats the logic to load the lower level of granularity of data to fact table.
What is a difference between complete, stop and abort?
What is the function of union transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Explain sessions?
How can we use batches?
What is an Integration service in Informatica?
How does a rank transform differ from aggregator transform functions max and min?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How do you load only null records into target?
Differences between version 7.x and 8.x.
Explain the different dimensions.
