Interested to Buy Any Domain ? << Click Here >> for more details...
Aggregator transformation is having fields say a,b,c,d,e group
by is enabled on a,b,c with sorted input,How the aggregator
transformation process the i/p data?or in which way i/p comes
to agg transformation
- 1 Answers
- 4965 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / priyank
Aggregator transformation will pass the output as the last
row coming in for the group a,b,c.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Can we create two repositories on same database instance in oracle?
write a query to retrieve the latest records from the table sorted by version(scd)
What is decode in informatica?
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,
Design a mapping to load a target table with the following values from the above source?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
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??
Can we change Dynamic to Static or Persistent cache? If so what happens?
What do you mean by blocking transformation?
What is fact table? Explain the different kinds of facts.
What is meant by incremental aggregation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Mention few advantages of router transformation over filter transformation.
To import the flat file definition into the designer where should the flat file be placed?
What is the fact table?
