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
What is sq transformation?
Why is sorter an active transformation?
How do you load only null records into target?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are the new features of informatica 9.x at the developer level?
How to update or delete the rows in a target, which do not have key fields?
What is the use of code page?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How to update a particular record in target with out running whole workflow?
What is a difference between complete, stop and abort?
What are the tuning techniques you applied during your last project
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
server hot-ws270 is connect to Repository B. What does it mean?
what is $$$$?