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
- 13921 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
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the new features of informatica 9.x at the developer level?
what is the size of your data warehousing?
What is aggregator transformation in informatica?
What do you mean incremental aggregation?
Enlist the tasks for which source qualifier transformation is used.
Global and Local shortcuts. Advantages.
Explain constraint based loading in informatica
waht type of interface is used for testing the data in informatica
Mention a few design and development best practices for informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Why update strategy and union transformations are active? Explain with examples.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Define pmcmd command?
Can we create a Integration service without a Repository service and vice versa?
