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
- 12496 Views
- I also Faced
- E-Mail Answers
Answer Posted / varsha
Source->SQ_>Expression->Router-> Tgt 1,Tgt 2,Tgt 3
in router add three groups
group1:mod(SEQ_NUM,30) >=1 and mod(SEQ_NUM,30) <=10
group2:mod(SEQ_NUM,30) >=11 and mod(SEQ_NUM,30) <=20
group3:mod(SEQ_NUM,30) >=21 and mod(SEQ_NUM,30) <=29 or mod(SEQ_NUM,30)=0
and connect to the respective target
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is lookup transformation?
Explain the etl program with few examples.
What is aggregate cache in aggregator transformation?
What happens when a session fails and you click on recover?
explain about unit testing? in real time?
How do you update the records with or without using update strategy?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Explain how many types of dimensions are available in informatica?
What is dimensional table?
what is unit testing?tell me proceedure
How do you migrate data from one environment to another?
How does a rank transform differ from aggregator transform functions max and min?
What is workflow? What are the components of the workflow manager?
can u give example for factless fact table
What is the command used to run a batch?
