Hi All,
I build a job to generate XML file and when i ran for just two employees it completed with in mins. But now i have to run this for around 60,000 employees and it’s running from last three hours. Attached is my Data flow.
is there any suggestion to reduce running time .
kannar (BOB member since 2011-08-01)
Do you see any CacheMemoryReader in Monitor Log during execution?
It could be, that optimizer first caches all data and building a cartesian product of all combinations and then building the result.
In that case please check table caching settings, join ranks.
Maybe use multiple quieries to logicially join the data (incl. caching and join ranks)-.
barthodo 
(BOB member since 2012-04-18)