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
- 14064 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 happens to map if we alter the datatypes between source and its corresponding source qualifier?
COM components can be used in Informatica
r u done any partitions in ur project?
What is transformation?
What is the benefit of session partitioning?
How to handle decimal places while importing a flatfile into informatica?
What are the limitations of joiner transformation?
Can we override a native sql query within informatica?
What is source qualifier transformation in informatica?
How to start a workflow using pmcmd command?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How to join three sources using joiner? Explain though mapping flow.
What are the conditions needed to improve the performance of informatica aggregator transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
how to load dimension table and fact table. plz tell me the steps.
