If we are using an aggregator but forget to mention the
group by port .what will be the output??
Answer Posted / g. manthiramoorthy
If we miss to enable any of the port as GROUP BY,
the aggregator will write the last row of the table to the
next transformation
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How can we store previous session logs?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are the performance considerations when working with aggregator transformation?
update strategy transformation in informatica
Which transformation is needed while using the Cobol sources as source definitions?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Can anyone tell me the new features in Informatica 9 Version?
Explain how many types of dimensions are available in informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
What is a standalone command task?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
have u done any performance tuning? how u ll do?
How to go to the older version for a mapping?
What is workflow monitor?