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
- 14048 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
Explain the pipeline partition with real time example?
What is meant by LDAP users?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Separate from a database, an information bazaar, and an information stockroom?
What is workflow manager?
What is the fact table?
What differs when we choose the sorted input for aggregator transformation?
What is rank transformation in informatica
What do mean by local and global repository?
what is INFORMATICA TESTING process
How to create a non-reusable instance of reusable transformations?
difference between informatica 8.1.1 and 8.6
According to his methodology what all you need before you build a datawarehouse
What is dimensional table? Explain the different dimensions.
define galaxy repository in informatica
