HomeArticlesSlideshowsAsk BobLogin or Register
NewsCustom SearchContactLinks
ETL limit
ASK BOB READY
27-Jan-2011
Is there a limit in the number of statistics ETL can aggregate in 30 minutes? We try to run a report every hour, but some times it fall behind with +- 2 hours.


Hello,

There are technical limits of ETL, but all depends how much scalable our solution is.
At scalable solution all depends how well the ETL is implemented.
Particular ETL tools have its limits.
In standard approach you have got soem time window open for ETL operation and then you have to make HW sizing to be able to reach that.
In cases of volatility what was described Oracle SPM (SQL Plan Management) can be successfully used to stabilize execution plans.

Best Regards,
Bob

Andre Enslin
All Right Reserved © 2007, Designed by Bob Jankovsky