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.
- 3 Answers
- 5684 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
can anyone suggest best free Talend data integration training online
What are the popular informatica products?
What are the conditions needed to improve the performance of informatica aggregator transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Design a mapping to load a target table with the following values from the above source?
How does a rank transform differ from aggregator transform functions max and min?
How union transformation is used?
State the limitations where we cannot use joiner in the mapping pipeline?
Target increases every day even though no new record was inserted
How do you load unique records into one target table and duplicate records into a different target table?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Can we override a native sql query within informatica?
What are the main features of Oracle 8i with context to datawarehouse?
Explain about cumulative Sum or moving sum?
