what are slowly changing dimensions, confirm dimensions?
- 1 Answers
- 8107 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / 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 |
how to coneect to a server in a business objects
What is a fantrap in business objects?
How to Analyise 'Join' problem and which method is the best to resolve that ?
What is the local filter and global filter in bo's?
How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.
1 Answers Cognizant, WinAlliance,
i Have created the universe in which i have one table and different derived tables from the same table i am supposed to create report from the same universe which should dispalay the duplicates rows, but all the time i run the report i am not getting the duplicate rows i have checkd the duplicate report option too in report.. is there problem with universe or report,.. can any body help?
what is custom sorting?how we can do this expalain with procedure???
What is maximum number of promts we can give in a BO report?
how to overcome overflow of data in a report
How maually can i define ? If thousends of records exists in a table?
What are the traps ? What are the disadvantages of traps?
explain merge dimensions with real time in DWH?
Teradata 
