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
- 13848 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
The above answer is work perfectly fine however if interviewer asks to do it with sequence then you can opt this approach.
1)Create a mapping variable of integer type and assign a default value of 30.
2)Mapping Design
SRC->SQ->EXP->ROUTER->TGT
3)EXPRESSION
in_rec i|o in_rec
count v IIF(count<=mapping_variable,count+1,0)
out_count o count
And then using the router route the records to different targets.
http://deepinopensource.blogspot.com/
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Define update strategy?
Explain dynamic target flat file name generation in informatica
What are the different options available for update strategy?
Write the prerequisite tasks to achieve the session partition?
generate date / time dimension in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the function of look up transformation?
What is intricate mapping?
can anyone explain me about retail domain project in informatica?
Explain the aggregator transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
what is mean by complex business rule ?
what is size of u r database?
How you prepared reports for OLAP?
What are the data movement modes in informatica?
