If we are using an aggregator but forget to mention the
group by port .what will be the output??
Answer Posted / srinu
No group by Port-
The AggTrans wil check for group by Column port up to last
column. No group by port was find,The AggTrans wil return
the last row only.
Every Column row wil check for Group by port done or not,
up to last row.
Finally (By default) last row will return.
Last Row still waiting for Group by port.,,,,
Thats why Group by prot is must.
Any Corrections,,,,,srinu.srinuvas@gmail.com
Is This Answer Correct ? | 57 Yes | 4 No |
Post New Answer View All Answers
What is the different lookup cache(s)?
Plz can any one say me how to get the informatica certification materials and dumps
update strategy transformation in informatica
How you prepared reports for OLAP?
What is an expression transformation in informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is a repository? And how to add it in an informatica client?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How can repository reports be accessed without sql or other transformations?
Could you explain what is enterprise data warehouse?
What are the various types of transformation?
What is a dimensional model?
What are the types of data warehouses?
What is the benefit of partitioning a session?
Why is sorter an active transformation?