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
- 14063 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
tell me 5 session failure in real time how can you solve that in your project?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Explain sql transformation in script mode examples in informatica
Can we override a native sql query within informatica?
What are the different ways to implement parallel processing in informatica?
How can we use mapping variables in informatica? Where do we use them?
What is option by which we can run all the sessions in a batch simultaneously?
How can you define user defied event?
How to create Target definition for flat files?
What are the static cache and dynamic cache in informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How can one identify whether mapping is correct or not without connecting session?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
what is INFORMATICA TESTING process
