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
- 14000 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
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Briefly explain the aggregator transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Difference between Target-based loading and constraint-based loading?
Explain load alternative records / rows into multiple targets - informatica
What are the features of complex mapping?
What is resilience time?
Explain the different kinds of facts.
How can we store previous session logs?
what is the hint? how to use it to reduce the query processing in program?
How can we create index after completion of load process?
Tell me about MD5 functions in informatica
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How many ways are there to create ports?
How are the sources and targets definitions imported in informatica designer?
