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 is data warehouse architecture?
what are the others of "bad files" and "discard files" when using sql*loader?
Can a dimension table contain numeric values?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
I know of using applysimple, but there are other ways too?
What are Aggregate tables?
Explain what is the difference between view filter and report filter?
How to limit the max no of rows retrieved in the report?
Compare aggregates and data marts
What is the difference between olap and datawarehosue?
What is the goal of optimizer?
What needs to be done while starting the database?
What are the possible data marts in retail sales?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause