Interested to Buy Any Domain ? << Click Here >> for more details...
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.........?
- 4 Answers
- 6774 Views
- I also Faced
- E-Mail Answers
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
which one is better performance wise joiner or look up
What is the use of an aggregator cache file?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is different between the data warehouse and data mart?
Explain 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?
How to load data in informatica ?
What's the layout of parameter file (what does a parameter file contain?)?
What are the tasks that source qualifier perform?
What are the advantages of using informatica as an etl tool over teradata?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the modules in Power Center
How we can use union transformation?
What is transformation?
server hot-ws270 is connect to Repository B. What does it mean?
What is a node in Informatica?
