What is the expected value if the column in an aggregator transform is neither a

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

Question Posted / amit vikram

1 Answers
1456 Views
I also Faced
E-Mail Answers

What is the expected value if the column in an aggregator transform is neither a group by nor an agg..

If we do not use an input port in group-by neither in aggregate expression, the Integration Service
will return only the last row value of the column for the input rows.
For example, if we have 100 rows coming from source then aggregator will output only the last record (100th
record)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Informatica Interview Questions

how can we use sorter transformation in joins?

5 Answers IBM,

how will you remove the duplicate records from flat file without using sorter?

7 Answers

What aer the out put files that the informatica server creates during the session running?

4 Answers

Scheduling properties,whats the default (sequential)

0 Answers

What is informatica?

0 Answers

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers Cap Gemini,

why we use informatica in our project?

2 Answers TCS,

Repository user profiles

0 Answers

I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers DELL,

Does Facttable Normalized or Denormalized?

2 Answers IBM,

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers

How to recover sessions in concurrent batches?

1 Answers

For more Informatica Interview Questions Click Here