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

Which files are created during the session rums by informatics server?

718


What's the layout of parameter file (what does a parameter file contain?)?

1931


What is olap (on-line analytical processing?

651


What is repository manager?

546


Parameter and variable differences

1629






Define sessions in informatica etl?

626


what is the difference between informatica6.1 and infomatica7.1

1729


What are the types of caches in lookup?

586


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

786


What is transformation?

670


What do think which one is the better joiner or look up?

744


What is parallel processing in informatica?

1040


What are the main issues while working with flat files as source and as targets ?

668


Make a note of the quantity vaults made in informatica?

568


Explain the features of connected and unconnected lookup.

556