QMC data reload Performance Issue

[#1]

Hi,

I am facing an scenario where database is oracle , tables count is 150 and data size is around 500 GB, Now, I am executing it 4 times is or data refresh cycle is 4 times in day but each time it takes like 15 to 20 min to reload or refresh, Can anyone help me how to Increase the performance , less data refresh time ,

Point here is I am looking for an approach , how to start analyzing , ETL part, Modeling, App creation, So I will have a way to follow to increase performance ...

This is a very common requirement comes by client

[vlad_komarov]

Hi Rohit.

No, not yet. Planning to upgrade my system during the next weekend...

VK

[#3]

Thanks Vlad, pleas update me when you done with testing. Second, you are the best person on this community Vlad,always comes with best solution

[vlad_komarov]

Sure, will do!

VK