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.
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
Plz can any one say me how to get the informatica certification materials and dumps
How to create a non-reusable instance of reusable transformations?
What is deployment group?
what is informatica metadata?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is Session and Batches?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Explain scd type 3 through mapping.
What are the conditions needed to improve the performance of informatica aggregator transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Write the program through which the records can be updated?
What are different types of transformations available in informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Define Pmrep command?
How are indexes created after completing the load process?