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

Can you copy the session to a different folder or repository?

2 Answers  


Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,


What is Index Caches size?

0 Answers   Informatica,


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  


What is a passive transformation?

0 Answers   Informatica,


I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,


What are mapping parametres and variables in informatica?

6 Answers   TCS,


What are the basic needs to join two sources in a source qualifier?

3 Answers  


Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,


What is a candidate key?

7 Answers   CTS,


who to split dimentions into sub dimention

3 Answers   Wipro,


How to load a Dimension ? and how to load a fact table?

0 Answers  


Categories