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
- 6712 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
What does refresh system mean, and what are its distinctive choice?
What are junk dimensions?
What are the issues you have faced in your project? How did you overcome those issues?
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
What are the prerequisite tasks to achieve the session partition?
Explain the scenario which compels informatica server to reject files?
Is it possible to revert a global repository to local one and why?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
Design a mapping to load a target table with the following values from the above source?
Write the different tools in the workflow manager?
What is the difference between source qualifier transformations source filter to filter transformation?
Under which circumstances, informatica server creates reject files?
What is the use of an aggregator cache file?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
