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
Explain pushdown optimization and types in informatica
How to extract sap data using informatica?
What is resilience time?
What is incremental aggregation?
What is the status code in stored procedure transformation?
How can you increase the performance in joiner transformation?
What is xml source qualifier transformation in informatica?
What does role playing dimension mean?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How do you take back up of repository?
Which version configuration tool used in ur project?
Explain Dataware house architecture .how data flow from intial to end?
Under what condition selecting sorted input in aggregator may fail the session?
Name the different lookup cache(s)?