narayana

• Nov 15th, 2006

 

If your database is oracle then we can apply CDC(change data capture) and load data which is only changed recently after previous data load.

pushpam vaidya

• Nov 28th, 2006

 

if staging area is storing only incremental data ( means changed or new data with respect to previous load) then you can truncate the staging area.

 But if you maintain historical information in staging area then you can not truncate your staging area.

Aparna

• Mar 15th, 2007

 

If we use Type 2 of slowly changing dimensions we can delete staging area. because SCD Type 2 stores previous data with version number and time stamp.