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
- 12905 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
Enlist few areas or real-time situations where informatica is required.
update strategy transformation in informatica
How to generate sequence numbers using expression transformation?
What is a snowflake schema?
What is the benefit of session partitioning?
What is resilience time?
What are pre and post-session shell commands?
What is the need of an ETL tool?
What is informatica etl tool?
What is intricate mapping?
What are roles and groups and benefits of using them?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is an unconnected transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
What is update strategy transform?
