Regarding loading DIM data and FACT data in QVD file, I got some doubt:

[#1]

Hi All,

Regarding loading DIM data and FACT data in QVD file, I got some doubt:

Loading DIM data in QVD file:

I have 5-10 DIM tables and all are SCD Type 1 so We are not keeping history. So to load the DIM data in QVD, I want to load complete data (Whole data) every day (After my ETL completion which loads data into Dimension table into Target Database).

Whereas, Fact Table is Incremental load based on TXN_TIMESTAMP and same needs to do (Incremental Load) while loading Fact data into QVD file.

Anyone could you please provide best strategy to load SCD-1 Dimensions and Incremental FACT data in QVD Files and also How can I make Incremental Load dynamic so that Everyday It should load only Previous day data.

[#2]

Please go through this presentation. That should give you a very good idea. It also has code that can be readily used.

[Gysbert_Wassenaar]

See here, here, here, here and here.

[maxgro]

I think you probably will load fact table first (incremental load, see below) and then all dimensions with a full load (no incremental). In this way you can limit your dimension values to the values present in fact table (search exists function). If this is not important for you use the order you want.

Regarding fact load, to have an idea about different incremental load, in online help search for  qvd and then choose "Using QVD files for incremental load" (case 2 or case 3 should help you) or see attachment (more detailed)