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 an error log table in informatica occurs and how to maintain it in mapping?
What needs to be done when the database is shutdown?
What is recovering sessions?
What is Discrete and Continuous data in Data mining world?
How do we design a universe?
What is Active Datawarehousing?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
Explain what are conformed dimensions?
What is a data warehousing?
what are the other factors of the database on which the loading performance depend?
Explain the data type of the surrogate key?
What is the difference between constraind base load ordering and target load plan?
Where the applications and where
What is a full backup?
What is core dimension?