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
- 14052 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
How to create a non-reusable instance of reusable transformations?
How can we improve session performance in aggregator transformation?
What do you mean by enterprise data warehousing?
What is meant by target load plan?
Which version configuration tool used in ur project?
What is rank transform?
What is mapping debugger?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
if we have a delimiters at unwanted places in a flat file how can we over come those.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
what is unit testing?tell me proceedure
Explain pmcmd command usage in informatica
What is the commit type if you have a transaction control transformation in the mapping?
What is the command used to run a batch?
