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
- 13853 Views
- I also Faced
- E-Mail Answers
Answer Posted / balachandar
step1).create a sequence generator set the properties
values as increment by=1,end value=30,check cycle and reset
properties.
step2).take the next val of seq generator into expression
transformation and rename it to some meaningfull name say
temp_id
step3).take a router transformation create 3 groups in say
first10,second10 and third10.
and conditions for the groups is as follows...
Tmp_Id >=1 and Tmp_Id<=10,
Tmp_Id >=11 and Tmp_Id<=20
Tmp_Id >=21 and Tmp_Id<=30
step4).connect the router transformation groups to the
respective targets.
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
How to go to the older version for a mapping?
What is workflow? What are the components of the workflow manager?
Explain why we use partitioning the session in informatica?
what is the difference between informatica6.1 and infomatica7.1
Design a mapping to load a target table with the following values from the above source?
Explain in detail scd type 2 through mapping.
What is the meaning of up gradation of repository?
How many number of sessions can one group in batches?
How we can use union transformation?
Explain the etl program with few examples.
where to store informatica rejected data?
Under what condition selecting sorted input in aggregator may fail the session?
which one is better performance wise joiner or look up
What is a pre-defined event and user-defined event?
What is depict expression change?
