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


Please Help Members By Posting Answers For Below Questions

What is the different lookup cache(s)?

603


Plz can any one say me how to get the informatica certification materials and dumps

1589


update strategy transformation in informatica

629


How you prepared reports for OLAP?

1142


What is an expression transformation in informatica?

512






How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1328


What is a repository? And how to add it in an informatica client?

640


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1548


How can repository reports be accessed without sql or other transformations?

714


Could you explain what is enterprise data warehouse?

546


What are the various types of transformation?

637


What is a dimensional model?

573


What are the types of data warehouses?

936


What is the benefit of partitioning a session?

618


Why is sorter an active transformation?

656