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
- 14192 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 are the different types of repositories created using informatica?
How can we delete duplicate rows from flat files?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Define pmcmd command?
Mention few power centre client applications with their basic purpose?
What is rank transformation?
What are the different versions of informatica?
What is event and what are the tasks related to it?
What is the scenario which compels informatica server to reject files?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Enlist the tasks for which source qualifier transformation is used.
How to use procedural logic inside infromatica?
what are the Methods For Creating Reusable Transformations?
Briefly explain the aggregator transformation?
What is session task and command task?
