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
- 14195 Views
- I also Faced
- E-Mail Answers
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
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
my source is junk data how will u remove that junk data by using unix please any one replay me
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How you can differentiate between connected lookup and unconnected lookup?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Differentiate between joiner and lookup transformation?
COM components can be used in Informatica
What is aggregate cache in aggregator transformation?
Plz can any one say me how to get the informatica certification materials and dumps
Explain load alternative records / rows into multiple targets - informatica
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
list out all the transformations which use cache?
What is xml source qualifier transformation in informatica?
What is mapplet in informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
