How to improve the performance of Aggregate
transformation?

Answer Posted / ritu

By giving sorted inputs and do not forget to tick the
sorted input box

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the restrictions of union transformation?

672


How do you load only null records into target? Explain through mapping flow.

1628


What are the mapping parameters and mapping variables?

715


How can we create index after completion of load process?

687


Define joiner transformation?

672






how to load dimension table and fact table. plz tell me the steps.

1757


What is a repository manager?

739


Write the advantages of partitioning a session?

853


Write the unconnected lookup syntax and how to return more than one column.

699


How is union transformation utilized?

675


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1438


Explain the aggregator transformation?

725


Can we get 1st record through Informatica(without sequence number).

1084


What is a standalone command task?

775


What are Dimensional table?

691