I have 1200 records how can u send it in aggregator with
good performance issues?

Answer Posted / venkat

Provide sorted input before aggregation.
->Override default Sql from source Qualifier if the source
is relational-Use order by clause
(OR)
->Use Sorter transfermation to do the same

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many ways a relational source definition can be updated and what are they?

584


Enlist the various types of transformations.

560


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1976


What is the fact table?

593


How union transformation is used?

595






What are the differences between oltp and olap?

553


What is the meaning of up gradation of repository?

1391


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

679


without table how to come first record only in oracle?

1860


Can we create multiple integration service on single repository?

705


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1921


How to create the source and target database connections in server manager?

634


Differentiate between router and filter transformation?

617


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

643


How would you join a node to the already existing domain?

683