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
- 12463 Views
- I also Faced
- E-Mail Answers
Answer Posted / nitin
Source->SQ_>Expression->Router-> Tgt 1,Tgt 2,Tgt 3
In the mapping define a variable Run_count of Aggregation type as count
in router add three groups.
Run_count = 1--> then connect the data to tgt 1
Run_Count = 2-->Tgt2
Run_Count = 3-->Tgt3
In the expression transformation add a condition IIF(Run_Count > 3,1,Run_count)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain dynamic target flat file name generation in informatica
How to do the error handling of if ur source is flatfiles?
What is the surrogate key?
can u any challenge your project?
what is unit testing?tell me proceedure
What's the layout of parameter file (what does a parameter file contain?)?
Briefly define a session task?
what is index?how it can work in informatica
Did u used latest transformations of 8.6.0? for what?
What is event and what are the tasks related to it?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How to extract sap data using informatica?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How do you load alternate records into different tables through mapping flow?
What are the conditions needed to improve the performance of informatica aggregator transformation?
