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|
How to delete first 3 rows & last 3 rows in target table in informatica
What is an active transformation?
What are the reusable transforamtions?
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
my source is junk data how will u remove that junk data by using unix please any one replay me
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? email@example.com
what is difference between dimention table and fact table?
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
why union transformation is active transformation?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
Can anyone tell me the new features in Informatica 9 Version?