Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain what is the difference between slice and dice and cross tab report?
What is a bo repository?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Can we configure two instances of CMS pointing to two different CMS system databases?
what is xcelsius architecture?
Can Bo generates the Report from the cubical data Explain?
What task is 98% of the required work of a business analyst?
What Is Snow Flake Schema?
What is difference between webi and infoview?
Explain about a time when you discovered a more efficient way to do a work task?
What is the profile and package?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
What is the difference between slice and dice and cross tab report?
What three things do you consider to be the most important factors for a manager?
