what are slowly changing dimensions, confirm dimensions?



what are slowly changing dimensions, confirm dimensions?..

Answer / kshatri

Slowly Changing Dimensions are basically those dimensions
whose key value will remain static but description might
change over the period of time. For example, the product
id in a companies, product line might remain the same, but
the description might change from time to time, hence,
product dimension is called slowly changing dimension.

Where as Confirmed dimensions is some thing, which can be
shared by multiple Fact Tables or multiple Data Marts.

Is This Answer Correct ?    7 Yes 0 No

Post New Answer

More Business Objects Interview Questions

When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?

4 Answers   Wipro,


What sort of existing documents should business analysts refer to when starting on a new project?

0 Answers  


when will use compatible and incompatible objects?

1 Answers   Business Intelligence Analytics, iGate, TCS,


plz tell me about BOmain key in detail?

2 Answers  


filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?

2 Answers   IBM,






WHAT ARE THE VARIOUS PRODUCTS IN BO?

2 Answers   Polaris,


wat is difference b/w break and section?

4 Answers  


can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2 Answers   iFlex,


u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources

4 Answers   IBM,


Hi friends, How many types of dimentions are they ?What are they? Thanks in advance

5 Answers   Mind Tree,


If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?

3 Answers   Infotech,


. In production reports, some dimensions are missing. how do you load these dimensions in production

2 Answers   TCS,


Categories