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 are the different ways to implement parallel processing in informatica?

0 Answers  


How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,


What is a unit Testing?

1 Answers  


what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  


Write the prerequisite tasks to achieve the session partition?

0 Answers  






waht type of interface is used for testing the data in informatica

0 Answers   CTS, TCS,


During the running session, output files are created by informatica server. Enlist few of them.

0 Answers  


how to we create datamart?

2 Answers   HSBC,


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,


As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,


What is difference between a gateway node and worker node?

0 Answers  


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers  


Categories