The data in the dimension tables may change over a period of time. Depending upon how you want to treat the historical data in dimension tables, there are three different ways of loading the (slowly) varying dimensions: 1. Type One Dimension: do not keep the history. Hence update the record if found, else insert the data. 2. Type Two Dimension: Do not update the existing record. Create a new record (with version number or change date as part of key) of the dimension, while retaining the old one. 2. Type three Dimension keeps more than one column for each changnig attribute. The new value of the attribute is recorded in the existing record, but in an empty column. Type 2 dimensions are the most commonly used dimension.
Above answer was rated as good by the following members: nflow2
RE: What are the Different methods of loading Dimension tables
Conventional Load: Before loading the data, all the Table constraints will be checked against the data.
Direct load:(Faster Loading) All the Constraints will be disabled. Data will be loaded directly.Later the data will be checked against the table constraints and the bad data won't be indexed.
RE: What are the Different methods of loading Dimensio...
Conventional and Direct load method are applicable for only oracle. The naming convension is not general one applicable to other RDBMS like DB2 or SQL server..
RE: What are the Different methods of loading Dimension tables
The data in the dimension tables may change over a period of time. Depending upon how you want to treat the historical data in dimension tables, there are three different ways of loading the (slowly) varying dimensions: 1. Type One Dimension: do not keep the history. Hence update the record if found, else insert the data. 2. Type Two Dimension: Do not update the existing record. Create a new record (with version number or change date as part of key) of the dimension, while retaining the old one. 2. Type three Dimension keeps more than one column for each changnig attribute. The new value of the attribute is recorded in the existing record, but in an empty column. Type 2 dimensions are the most commonly used dimension.
1 
0