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 / nitin
Source->SQ_>Expression->Router-> Tgt 1,Tgt 2,Tgt 3
In the mapping define a variable Run_count of Aggregation type as count
in router add three groups.
Run_count = 1--> then connect the data to tgt 1
Run_Count = 2-->Tgt2
Run_Count = 3-->Tgt3
In the expression transformation add a condition IIF(Run_Count > 3,1,Run_count)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Slowly changing dimensions, types and where will you use them
Can we create a node as a gateway node and the same node can be assigned to a grid?
What does role playing dimension mean?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How can a transformation be made reusable?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is a predefined event?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Explain the different kinds of facts.
What is fact table? Explain the different kinds of facts.
What are the main issues while working with flat files as source and as targets ?
What is the meaning of up gradation of repository?
What if the source is a flat-file?
Explain the scenario which compels informatica server to reject files?
What are the measure objects?