Static Dimension in DWH

 A static dimension is a dimension which is not loaded by ETL tool. we can say that it is not loaded from the any source system. It is loaded by SQL script and it is loaded by manually.

 For Example Dim_Status_code. It is loaded manually.

Below is the table script.

CREATE TABLE dim_status_code   (      status_cd SMALLINT PRIMARY KEY,      status    VARCHAR(20)   )

Below is the script to insert the records into the table.

INSERT INTO dim_status_code             (status_cd,              status) VALUES      (1,              'Place Order'); INSERT INTO dim_status_code             (status_cd,              status) VALUES      (2,              'Confirmed Order'); INSERT INTO dim_status_code             (status_cd,              status) VALUES      (3,              'Dispatch   Order'); INSERT INTO dim_status_code             (status_cd,              status) VALUES      (4,              'In Transit'); INSERT INTO dim_status_code             (status_cd,              status) VALUES      (5,              'Delivered Order'); INSERT INTO dim_status_code             (status_cd,              status) VALUES      (6,              'Return Order'); INSERT INTO dim_status_code             (status_cd,              status) VALUES      (7,              'Inactive'); INSERT INTO dim_status_code             (status_cd,              status) VALUES      (8,              'Refend');

Inserting these records.

Records in the table

  

Suck king of Dimensions are known as Static Dimension.