Hi,

I have a dimension table which will contain 24 million records after backloading. It is a monthly run and every month 400,000 records will come from source.

I am currently using a dynamic lkp to do the SCD. But i really doubt if it will run as the lkp has to build a cache for 24 million records + 400000 every month going forward.

Can someone suggest a better way to do the SCD in this case??

Many Thanks in advance!!
Henry.M