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
- 6178 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
What if the source is a flat-file?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How do you take back up of repository?
How can we update a record in the target table without using update strategy?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How can repository reports be accessed without sql or other transformations?
Explain sql transformation in script mode examples in informatica
What is the difference between source qualifier transformations source filter to filter transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain the different kinds of facts.
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Make a note of the quantity vaults made in informatica?
Write the advantages of partitioning a session?
