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
- 9815 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
write a query to retrieve the latest records from the table sorted by version(scd)
According to his methodology what all you need before you build a datawarehouse
what are 3 tech challenges/ common issues you face?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is decode in static cache?
Explain what is informatica metadata and where is it stored?
Quickly characterize reusable change?
How to start a workflow using pmcmd command?
How does a sorter cache works?
Describe the impact of several join conditions and join order in a joiner transformation?
What do you understand by term role-playing dimension?
How you prepared reports for OLAP?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
