Skip to Content
Former Member
Feb 09, 2016 at 11:44 AM

Dimension and Fact tables Full load and Delta Load


Hi Experts,

I want to load the data from source to stage table and from stage table to target.I want to know the process of dealing with the stage table and target table for Full load and Delta load for both Dimension table loading and Fact table loading.Please specify whether the stage table will be truncated or deleted for Full/Delta loads for both Dimension and Fact tables.