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.
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
Write the unconnected lookup syntax and how to return more than one column.
What is flashback table ? Advance thanks
How can repository reports be accessed without sql or other transformations?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is workflow manager?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is Active lock explain
Explain sessions?
In development project what is the process to follow for an etl developer from day1
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
pmscmd startworkflow -sv
How to open an older version of an object in the workspace?
How can we update a record in the target table without using update strategy?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?