If we miss to enable any of the port as GROUP BY, the aggregator will writ

If we are using an aggregator but forget to mention the
group by port .what will be the output??

Question Posted / g. manthiramoorthy

11 Answers
33819 Views
Nomura, TCS, I also Faced
E-Mail Answers

Answer Posted / g. manthiramoorthy

If we miss to enable any of the port as GROUP BY, the
aggregator will write the lat
row of the table to the next transformation

Is This Answer Correct ?

11 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7136

What is an aggregator transformation?

1040

Explain lookup transformation in informatica

1021

What are the components of workflow manager?

1036

r u done any partitions in ur project?

1770

How many transformations can be used in mapplets.

1890

What is a pre-defined event and user-defined event?

990

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2037

What is the reusable transformation?

1018

Explain transaction control transformation in informatica

1224

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1082

Can we override a native sql query within informatica?

997

What is status code in informatica?

972

What is the sql query overwrite in source qualifier in informatica

1043

Explain about cumulative Sum or moving sum?

989