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 |
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
Explain the difference between a data warehouse and a data mart?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
Which transformation should u need while using the cobol sources as source defintions?
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
my source is junk data how will u remove that junk data by using unix please any one replay me
What do you understand by term role-playing dimension?
What are the tasks that can be performed using sq?
what is the location of parameter file in informatica?