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
- 13854 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
Which transformation should we use to normalise the COBOL and relational sources?
Differences between version 7.x and 8.x.
what is mean by complex business rule ?
Explain incremental aggregation in informatica
In informatics server which files are created during the session rums?
How do you change a non-reusable transformation to reusable transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is the benefit of partitioning a session?
Enterprise data warehouse your projects phase by phase explain?
how we can load rejected record's at run time?(not through bad files)
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Briefly define reusable transformation?
Explain sql transformation in script mode examples in informatica
What are the prerequisite tasks to achieve the session partition?
What is the benefit of session partitioning?
