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
What are the steps of implementing data warehousing?
Explain what are data marts?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
Explain degenerate dimension table?
Explain the main difference between inmon and kimball philosophies of data warehousing?
I need to set predefined condition. How I do this?
What are aggregate tables and aggregate fact tables?
What is the function of etl when used in data warehousing?
How many types of facts and what are they?
What are the data marts?
Explain what is the difference between stop and abort?
List down some of the real time data-warehousing tools?
What is data analysis?
Explain grouped cross tab?
What are the steps involved in designing a fact table?