to join or not to join, applymap, temptables. Optimisation

[#1]

I have been reading a lot of different ways to help with performance of a reload.

I have come to conclusion that I will need to either applymap or join with the fact load rather than a left join outside of the resident load of the fact table.

My memory reached 40GB from n app that's less than 1GB when I reload from reading forums I have gathered that it's from all the left joins.

I have attached my script, could anyoen recommend what they would do with the script?

There's temp tables, joins, left joins and apply maps....

Thanks,

Lauren

[#2]

Hi,

Please could you come back to me on this. My load is still over 2 hours long.

[Gysbert_Wassenaar]

Put statements like this around each load:

LET vStart = Now(1);

LOAD ...etc

LET vLoadTime = Interval(Now(1) - $(vStart),'hh:mm:ss');

TRACE $(vLoadTime);

Then check the log file for lines with these load times to check where the most time is spend.