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

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,


why do u use shortcuts in informatica.?

4 Answers   iFlex,


in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,


What are Target Options on the Servers?

1 Answers  


What is the scenario which compels informatica server to reject files?

0 Answers  






What is the sequence generator transformation in informatica?

0 Answers  


Explain the different dimensions.

0 Answers  


generate date / time dimension in informatica

0 Answers   Informatica,


How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  


After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  


What is status code?

2 Answers  


Is stop and abort are same in informatica?

0 Answers  


Categories