In aggregator if u enable sorted input what will be the
output and disable sorted wt is output
Answer Posted / amedela chandra sekhar
if u enable sorted input option in aggregator with out group
by result is one row for all input records.
If u enable sorted input and group by session will fail.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a router transformation?
What is a grid in Informatica?
How to load the data from people soft hrm to people soft erm using informatica?
Is there any target staging area in informatica not staging area
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to improve the performance of a session using sorter transformation?
What is a filter transformation and why it is an active one?
Explain the scenario which compels informatica server to reject files?
Explain incremental aggregation in informatica
How to load last n records of file into target table - informatica
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How do you change a non-reusable transformation to reusable transformation?
What if the source is a flat-file?
How union transformation is used?
Enlist the differences between database and data warehouse.