What is slowely changing dimensions?why we are used SCD?

Question Posted / guest

2 Answers
6145 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is slowely changing dimensions?why we are used SCD?..

Answer / navneet singh sahni

Slowely Changing Dimensions are those whose data are not
fixed.

SCD types:

SCD type 1: Whose data is not fixed. Historical data are
not saved. Data keeps on changing.-> Current Data

SCD type 2: Whose data is fixed and also save historical
data.

SCD type 3: like SCD type 2 only but save hostorical data
in another table. In one table data will updated and in
another table historical data will be there.

Depends what we are going to use a DWH or Database.

Is This Answer Correct ?

1 Yes

0 No

What is slowely changing dimensions?why we are used SCD?..

Answer / nasa

these are three types
type-1
type-2
type-3

type-1: it will not maintain historical data... that means
if you update the record it store but it will remove
previous data

type-2: type -2 maintain historical data. it store new data
by row wise..

type-3: type-3 also maintain historical data but it stores
data column wise and it allow limited nearly 250

but type allow more that 250 so type-2 is the best...

Is This Answer Correct ?

0 Yes

0 No

Post New Answer