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 |
What is target designer and target load order?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are batches?
HOW DO YOU CONNECT TO REMOTE SERVER ?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
without using emailtask how will send a mail from informatica?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
How u use pdf file in informatica source?
I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?