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
in general which algorithms for used?
Why denormalization is promoted in universe designing?
What are the key columns in Fact and dimension tables?
Explain what is fact less fact table? Where you have used it in your project?
How we are using this function?
Explain a mapping, session, worklet, workflow, mapplet?
What is data analysis?
what are the major three types of modeling used?
Explain what are the vaious etl tools in the market?
Explain what are fact, dimension, and measure?
What are the fundamental elements of the data warehouse?
What is real-time datawarehousing?
What is Operational Data Store?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
How to add a number to a macro variable?