Hi,
In a mapping I have 3 targets and one fixed width file as
source. Total 193 records are there .
I connected one port in aggregator to all 3 targets.
The same value need to be load into these 3 targets . It is
loaded like that only but in different order.
Why?
The order of insertion should be same know for all 3 targets
? Then why the order is changed ?
Any one please help me.
Advance thanks.

Answers were Sorted based on User's Feedback



Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are ther..

Answer / manojkumar challagundla

Hi Sateesh,
I am asking about order of insertion .

Is This Answer Correct ?    0 Yes 0 No

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are ther..

Answer / sateesh a

passthrough-->true and default groups are different.

Is This Answer Correct ?    0 Yes 0 No

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are ther..

Answer / zipzapdhoom

informatica don't consider the sequence of records at the
time of insertion to Target , for that u should use a
sequence generator TF. or u can use sorter.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,


What is A complex mapping?

3 Answers   TCS,


what is metadata?

6 Answers  


What is the default source option for update stratgey transformation?

1 Answers  


What is the difference between Active and Passive transformation?

0 Answers   Informatica,






How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,


Two different admin users created for repository are ______ and_______

1 Answers  


how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,


What are the uses of a Parameter file?

3 Answers   CSC,


what are surrogate keys?

5 Answers  


If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,


Which kind of index is preferred in DWH?

2 Answers  


Categories