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

webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4144


When to use local filter and when to use global filter?

769


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

782


Explain when to use local filter and when to use global filter?

1147


What are the steps to be taken to schedule the report?

729


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4508


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2170


How we drill up week to month?

805


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

823


Explain about a tricky situation for which you found a very simple solution?

748


What is a fantrap in business objects?

813


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

1998


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

780


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

772


Is there any other repository domains rather than universe, security, document?

795