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
- 13859 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
Differentiate between Load Manager and DTM?
Why do you use Mapping Parameter and mapping variable?
Differentiate between a database and data warehouse?
Partition, what happens if the specified key range is shorter and longer
What is InformaticaPowerCenter?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Define filter transformation?
Make a note of the quantity vaults made in informatica?
What is informatica? Why do we need it?
Differentiate between joiner and lookup transformation?
how many types of dimensions are available in informatica?
what is song in infrmatica...?
How can we improve session performance in aggregator transformation?
what is the Default Source Option For Update Strategy Transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
