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
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??
When to use local filter and when to use global filter?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain when to use local filter and when to use global filter?
What are the steps to be taken to schedule the report?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
How we drill up week to month?
What is the difference between slice and dice and cross tab report?
Explain about a tricky situation for which you found a very simple solution?
What is a fantrap in business objects?
what is the difference b/w the refresh and buffered data?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What is the difference between business requirement document and use case document.
Is there any other repository domains rather than universe, security, document?