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

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

Question Posted / ashok

3 Answers
7959 Views
I also Faced
E-Mail Answers

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

Implementation methodology

0 Answers

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers Informatica,

Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers Emphasis,

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers CTS,

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers IBM,

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers IBM,

how much memory (size) occupied by a session at runtime

4 Answers Wipro,

From where you extract the data, how you did it into informatica? explain....

1 Answers Accenture, Unisoft Infotech,

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers

For more Informatica Interview Questions Click Here