what are slowly changing dimensions, confirm dimensions?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is thumbnail?

572


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1529


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3837


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?

1467


What is package in BO

2674






what is the difference b/w the refresh and buffered data?

1755


What is the difference between slice and dice and cross tab report?

595


What is object stores?

571


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

682


Explain is there any default username & pwd for bo designer & supervisor?

587


What are the data types present in bo? What happens if we implement view in the designer and report?

609


Explain how to execute the plsql procedure from the report by clicking with mouse?

592


How would you format some text using css to be verdana and bold?

656


Explain how many universes can be created in a project?

605


What Is Snow Flake Schema?

660