Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6896 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 can you differentiate between powercenter and power map?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Which files are created during the session rums by informatics server?
What is a sorter transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is the difference between stop and abort in informatica
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Why do we need informatica?
How to create Target definition for flat files?
What are the types of lookup transformation?
What does reusable transformation mean?
What is a snowflake schema?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
