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
- 5931 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
How many transformations can be used in mapplets.
What is Cognos script editor?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is the function of look up transformation?
How to call shell scripts from informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Enlist the advantages of informatica.
What is an expression transformation in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is olap (on-line analytical processing?
What are the tasks that can be performed using sq?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Where are the source flat files kept before running the session?
What all are steps in up gradation of Informatica server?
what is index?how it can work in informatica
