My source contains 10 records with 5 columns.What happens if I
select group by all columns in Aggregator T/R?

Answers were Sorted based on User's Feedback



My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggr..

Answer / rayudu

If you select groupby on all the ports you will get distinct records only.

Is This Answer Correct ?    22 Yes 0 No

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggr..

Answer / abhinaw prakash

If u group by all the columns it will group the Data
sequentially according to the Port order and send it to the
Next transformation.

Is This Answer Correct ?    1 Yes 0 No

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggr..

Answer / kunkala.ramakrishna

ALL RECORDS SEND TO NEXT T/R

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

What is substr in informatica?

0 Answers  


What are the uses of etl tools?

0 Answers  


How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,


What is exclusive and normal mode for repository services?

0 Answers  


What is the Difference between sorter and aggregator?

2 Answers  






Define the various join types of joiner transformation?

0 Answers  


Is informatica power center designer has 64 bit support?

1 Answers  


If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,


What is aggregator transformation in informatica?

0 Answers  


Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  


Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  


Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 Answers  


Categories