Answer Posted / sunil pandey
The dimension which is shared by all star schema or more than one star schema and it's structural definition should be same.
eg:- like product this is one dimension and it's pid is same in two star schema(orders & productions).so it will bshared across them.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to provide security in frame work manager for a query subject?
what are the different views that are considered when building an object-oriented software system?
What are the different types of datawarehosuing?
Explain what are necessary tasks to install reportnet software?
What function should we use to display the value entered or selected by a user in response to a prompt?
For faster process, what we will do with the universe?
Explain what are non-additive facts?
Where the data cube technology is used?
What is a cube in data warehousing concept?
What is surrogate key? Where we use it? Explain with examples.
What are the different types of join operations?
What is a staging area? Do we need it? What is the purpose of a staging area?
What are various warehousing tools?
Which are the olap tools available that are supported by oracle?
What is difference macros and prompts?