What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
Answer Posted / ysindhureddy77@gmail.com
If we do not use an input port in group-by neither in aggregate expression, the Integration Service
will return only the last row value of the column for the input rows.
For example, if we have 100 rows coming from source then aggregator will output only the last record (100th
record)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Partition, what happens if the specified key range is shorter and longer
What is a mapplet/worklet in informatica?
What is a sequence generator transformation?
Why do we need informatica?
What are the new features of informatica 9.x in developer level?
What do you mean incremental aggregation?
How to elaborate powercenter integration service?
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??
How to go to the older version for a mapping?
What is union transformation in informatica?
What is union transformation?
What is aggregator transformation in informatica?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Design a mapping to load a target table with the following values from the above source?