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
- 14197 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 do you mean by blocking transformation?
What is data caches/ index caches?
what is informatica metadata?
Under what condition selecting sorted input in aggregator may fail the session?
How to start a workflow using pmcmd command?
What is the difference between informatica 7.0 and 8.0?
Differences between version 7.x and 8.x.
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How to convert multiple rows to single row (multiple columns) in informatica
What is the function of union transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the types of lookup transformation?
What do think which one is the better joiner or look up?
How to use procedural logic inside infromatica?
