Interested to Buy Any Domain ? << Click Here >> for more details...
Let’s say I have more than have record in source table and I
have 3 destination table A,B,C. I have to insert first 1 to
10 records in A then 11 to 20 in B and 21 to 30 in C.
Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in
C……So on up to last record.
- 5 Answers
- 14196 Views
- I also Faced
- E-Mail Answers
Answer Posted / kumar
U can do it using Expression and RTR check the below link for more info.. and its has some other very good scenarios
https://etltechsolutions.wordpress.com/2014/10/15/informatica-scenario-split-source-records-and-loading-into-3-targets-based-on-some-logic/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is DR strategy for Informatica project?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
what is Active lock explain
What can we do to improve the performance of informatica aggregator transformation?
What is fact table? Explain the different kinds of facts.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain the tuning lookup transformation - informatica
Explain transaction control transformation in informatica
can we override a native sql query within informatica? Where do we do it?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How does the aggregator transformation handle null values?
What is blocking transformation?
how tokens will generate?
explan ur project architecture?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
