Slowly changing dimensions(SCD) is the type of dimensions which changes

5.what is slowly changing dimension ?

Question Posted / naga bhushanam.banglore

2 Answers
10831 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / naga bhushanam.banglore

Slowly changing dimensions(SCD) is the type of dimensions
which changes with respect to time or peeriod.

Fo s ex: there is an table which has objects like
Country City Employeeid ddress .

Here for example the say the employee of employee id say
e23321 is presently in Hyderabad after a month he is re-
located in Banglore than we can say the address dimension
is SCD w.r.t. time

We have 3 types of SCDs:
SCD-1
SCD-2
SCD-3
SCD-1:where no historical data is not maintained only
present data is maintained
SCD-2:Where complete historic + presentl data is maintained
SCD-3:Where one time historic(say previous) data+ current
data is maintained

Is This Answer Correct ?

26 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

When we use aggregate awareness function in designer?

977

What are the steps to do to use alerts in bo?

1394

hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

2057

U r project in which stage in implementation?

2516

What is the difference between business requirement document and use case document.

1008

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

2122

Difference between b.o 5.1 and 6.1b?

1256

Can anybody tell me what are the tuning problems?

2046

What would you consider as your biggest achievement and why?

1012

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

2061

Explain which versions are used in the bo dashboard work?

1093

Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

2042

Explain what are the steps to be taken to schedule the report?

1108

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1131

Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2395