How to improve the performance of Aggregate
transformation?
Answer Posted / uzval_vee
Place the agg transformation after souce qualifier,becoz
if yur using filter,sorting before agg ,it will reduce the
agg performance .according to my view
| Is This Answer Correct ? | 1 Yes | 12 No |
Post New Answer View All Answers
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is Session and Batches?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Explain what are the different versions of informatica?
How are the sources and targets definitions imported in informatica designer?
What is fact table? Explain the different kinds of facts.
What is meant by a domain?
Can anyone tell me the new features in Informatica 9 Version?
What are the features of complex mapping?
tell me 5 session failure in real time how can you solve that in your project?
How do you take back up of repository?
What is expression transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Enlist the various types of transformations.
what is INFORMATICA TESTING process