How to improve the performance of Aggregate
Answers were Sorted based on User's Feedback
Answer / ritu
By giving sorted inputs and do not forget to tick the
sorted input box
|Is This Answer Correct ?||5 Yes||0 No|
Answer / 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||11 No|
what is filelist concept in informatica
What is mapplet and a reusable transformation?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
Why should we use star schema in datawarehouse design?
What is the difference between Bulk Load and Normal Load
What is the difference between Active and Passive transformation?
What are the new features of informatica 9.x developer?
how do u move the code from development to production?
what is the difference between static and dynamic
How many ways a relational source definition can be updated and what are they?
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this