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.
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 the difference between informatica 7.0 and 8.0?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is a snowflake schema?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are junk dimensions?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Briefly define a session task?
can we override a native sql query within informatica? Where do we do it?
Informatica settings are available in which file?
Design a mapping to load a target table with the following values from the above source?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Sequence generator, when you move from develoment to production how will you reset
Global and Local shortcuts. Advantages.
How many ways are there to create ports?