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
- 14001 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 the scenario which compels informatica server to reject files?
What do you mean by enterprise data warehousing?
r u done any partitions in ur project?
What is the use of an aggregator cache file?
How to elaborate tracing level?
Explain what are the different types of transformation available in informatica.
Make a note of the quantity vaults made in informatica?
Different circumstance which drives informatica server to expel records?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is joiner transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
Design a mapping to load a target table with the following values from the above source?
What do you understand by SOA of Informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to update or delete the rows in a target, which do not have key fields?
