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
- 14003 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
What is joiner transformation in informatica?
permutations of mapplet
What all are steps in up gradation of Informatica server?
scenario where i can use only concurrent execution of workflow.
What does cheating measurement mean?
What is meant by target load plan?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Define update strategy?
How an expression transformation differs from aggregator transformation?
Differences between connected and unconnected lookup?
can u give example for factless fact table
Explain lookup transformation is active in informatica
What is event and what are the tasks related to it?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
what are the deliverables?in your project?
