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
1465 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

Different sorts of metadata that stores in the storage facility?

0 Answers

How to do unit testing in informatica?

0 Answers

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers TCS, Wipro,

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers Mphasis,

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers Patni, Wipro,

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers

What do you understand by term role-playing dimension?

0 Answers

Why sorter is an active transformation?

0 Answers Informatica,

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers TCS,

Is there any model difference between ODS and DWH

2 Answers Zensar,

Can we run session without using workflows?

5 Answers TCS,

Explain grouped cross tab?

1 Answers Accenture,

For more Informatica Interview Questions Click Here