Performance Tuning.
Posted: Mon Jul 26, 2004 6:05 pm
Hello
I have a huge job that has performance issues. It takes 1 hr 25 min to move data across for 2100 rows! The size of the data is not too huge however there are 2 transformers directly connected with over 20 look ups each to universe stages. The resaon for universe stages is beacuse the has files do not allow me to look up for values between a range.
Is there a way I can increase performance of this job ? the previous consultant used the universe stage? Is therea benefit using Universe stages as opposed to say a DRS stage?
I have a huge job that has performance issues. It takes 1 hr 25 min to move data across for 2100 rows! The size of the data is not too huge however there are 2 transformers directly connected with over 20 look ups each to universe stages. The resaon for universe stages is beacuse the has files do not allow me to look up for values between a range.
Is there a way I can increase performance of this job ? the previous consultant used the universe stage? Is therea benefit using Universe stages as opposed to say a DRS stage?