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
- 14046 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
How do you change a non-reusable transformation to reusable transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is meant by lookup transformation? Explain the types of lookup transformation?
Describe data concatenation?
What is data caches/ index caches?
What are Dimensional table?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How do you take back up of repository?
can we override a native sql query within informatica? How do we do it?
How to update or delete the rows in a target, which do not have key fields?
Explain sessions?
can u any challenge your project?
Implementation methodology
How to generate sequence numbers?
what is $$$$?
