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
What is difference between webi and infoview?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain what would you consider as your biggest achievement and why?
Explain what are the steps to be taken to schedule the report?
Explain what is the difference between business requirement document and use case document.
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
what is the difference b/w the refresh and buffered data?
What Is The Difference Between Oltp And Olap?
What is the dense rank?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
what is universe null
Explain in detail about type 2(scd),
how to create metric universe ?
What we need to discuss with designer before starting the universe designing.
