In a simple mapping when i use aggregate t/r with out any
condition or group by, i am getting output as only last
record in the table . can any one explain it please.........?
Answer Posted / naresh_infa96
If you're using Aggregator Trasnformation without using group by on any port then the aggreagtor TXNs consider whole table as one group and gives the last row as output.
Why last row as Output : by default aggregator uses MAX() function
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to configure mapping in informatica?
tell me about your project functionality
What is the procedure for creating independent data marts from informatica 7.1?
How to use procedural logic inside infromatica?
What is difference between a gateway node and worker node?
How can informatica be used for an organization?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
In how many ways we can create ports?
Why sorter is an active transformation?
What is exclusive and normal mode for repository services?
How can we use mapping variables in informatica?
how to create user defined function (udf) in informatica
What is incremental aggregation?
Explain the tuning lookup transformation - informatica
What is the meaning of decode in informatica?