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
what is the difference b/w the refresh and buffered data?
Explain is data mart?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What Is Snow Flake Schema?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Can we configure two instances of CMS pointing to two different CMS system databases?
What is a fantrap in business objects?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Explain about a tricky situation for which you found a very simple solution?
What is the difference between the public object&schema object?
Explain what task is 98% of the required work of a business analyst?
What is report template in b.o?
What are the steps to be taken to schedule the report?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
What is the difference between user and versatile user?