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
Explain when to use local filter and when to use global filter?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What would you consider as your biggest achievement and why?
What is the difference in creating filters in designer and business objects?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Did you face any problems while creating reports? Name? Solutions?
in sap bi we have wad, then why we go for sap bo
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
How would you format some text using css to be verdana and bold?
Explain about alerts in bos, under what situation we need to use alerts?
Explain difference between zabo and webi?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
What three things do you consider to be the most important factors for a manager?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?