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
Answer / manojkumar challagundla
Hi Sateesh,
I am asking about order of insertion .
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sateesh a
passthrough-->true and default groups are different.
| Is This Answer Correct ? | 0 Yes | 0 No |
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 |
I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
Partition, what happens if the specified key range is shorter and longer
What is workflow? What are the components of workflow manager?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
What are the conditions needed to improve the performance of informatica aggregator transformation?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
What is source qualifier transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is a grid in Informatica?
what is the architecture of any Data warehousing project?
Clarify the aggregator change?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.