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
- 13992 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
As union transformation gives UNION ALL output, how you will get the UNION output?
How do we call shell scripts from informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What does cheating measurement mean?
What is meant by target load plan?
Mention a few design and development best practices for informatica?
What is the surrogate key?
Do you find any difficulty while working with flat files as source and target?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is DR strategy for Informatica project?
Explain about cumulative Sum or moving sum?
Differences between version 7.x and 8.x.
Briefly define a session task?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
