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
- 5929 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
How do you convert single row from source into three rows into target?
What is a shortcut and copy in Informatica and how two are different with each other?
How many input parameters can exist in an unconnected lookup?
What is difference between Mapplet and reusable transformation?
What are the new features of Power Center 5.0?
How to generate sequence numbers?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
What is the difference Between Mapping parameter and variable
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
I have source like this 1:2;3. so i want to load the target as 123
Teradata 
