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
- 13993 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
How do you manage the Parameter files while migrating your data from one environment to another environment?
How will the document be delivered to me?
permutations of mapplet
How are the sources and targets definitions imported in informatica designer?
Explain the informatica workflow?
Global and Local shortcuts. Advantages.
What is a dimensional model?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Define enterprise data warehousing?
How can you define user defied event?
What is the difference between writing a joiner query in ANSI style and THETA style?
Explain transaction control transformation in informatica
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is the Process to creating lookup transformation in informatica
Explain the mapping variable usage example in informatica
