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
- 12906 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
Informatica Checkpoints
Write the unconnected lookup syntax and how to return more than one column.
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. ?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is a joiner transformation?
How to load the data from people soft hrm to people soft erm using informatica?
how to create user defined function (udf) in informatica
Is it possible to create multiple domains on a single Informatica server?
How to update or delete the rows in a target, which do not have key fields?
What is union transformation?
What is the need of etl tools?
r u done any partitions in ur project?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How does the aggregator transformation handle null values?
design of staging area?
