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.
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
list out all the transformations which use cache?
How do you handle two sessions in Informatica
What are the components of workflow manager?
Briefly define reusable transformation?
Repository user profiles
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Tell me about MD5 functions in informatica
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How can informatica be used for an organization?
How to delete duplicate row using informatica?
What is dimensional table?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Target increases every day even though no new record was inserted
explain one complex mapping with logic? sales project?
Quickly characterize reusable change?