If we are using an aggregator but forget to mention the
group by port .what will be the output??
Answer Posted / kt
If we miss to enable any of the port as GROUP BY, the
aggregator will write the lat row of the table to the next
trnasformation.
| Is This Answer Correct ? | 50 Yes | 1 No |
Post New Answer View All Answers
What is the difference between a connected look up and unconnected lookup?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is a passive transformation?
What is the need for an etl tool?
How to load last n records of file into target table - informatica
What is the difference between informatica 7.0 and 8.0?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the restrictions of union transformation?
What is a mapplet/worklet in informatica?
How identifying bottlenecks in various components of informatica and resolving them?
What are data-driven sessions?
What are the conditions needed to improve the performance of informatica aggregator transformation?
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. ?
How we can create indexes after completing the load process?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how