Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / ashok

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

Write the advantages of partitioning a session?

0 Answers  

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,

How many types of sessions are there in informatica.please explain them?

0 Answers   Informatica,

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 Answers   Zensar,

What is DTM process?

4 Answers  

performance wise which one is better in joiner and lookup transformation

2 Answers  

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

can we use bulk loading when we use look in mapping

1 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories