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

What are the new features of informatica 9.x at the developer level?

0 Answers

What are the ETL tools available in DWH?

6 Answers Mphasis,

Which is costliest transformation? costly means occupying more memory?

3 Answers

Why should we use star schema in datawarehouse design?

2 Answers Wipro,

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers Bank Of America,

Can you start a session inside a batch individually?

2 Answers

explain abt joiner t/r?

1 Answers IBM,

What are the different components of powercenter?

0 Answers

What are the reusable transforamtions?

1 Answers

why we are using surogate key in real time give me explanation

2 Answers TCS,

After we make a folder shared can it be reversed?Why?

2 Answers Accenture,

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers

For more Informatica Interview Questions Click Here