Data Warehousing Community Forum
June 17, 2019, 03:12:26 am

Pages: [1]   Go Down
Author Topic: Adding additional columns to a a dimension table  (Read 472 times)
DW Fresher

Reputation: +0/-0
Offline Offline

Posts: 1

View Profile
« on: December 26, 2018, 11:14:26 am »

I have a star schema data warehouse. In dimension table T1, I have a BK (BK1) and several data columns (Col1, Col2 and Col3). Business wants to add two more columns (ColX and ColY) to the table for their use which are not part of the dimension. All the data columns are part of Type 2 SCD except these two columns. I am of the opinion that these two columns should not be part of Type 2 SCD for this dimension table as they are not part of the dimension. Any thoughts?
Pages: [1]   Go Up
Jump to: