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 approaches used by optimizer during execution plan?
Explain reference cursor?
Whether dimension table can have numeric value?
Explain functional dependency?
How to add a number to a macro variable?
What is the difference between filter and lookup transformation?
Explain what is the extension of file to save template?
What is dimension modeling?
Explain bus schema?
What is the working process for application.cfm?
What is loop in data warehousing?
Code the tables statement to produce a multi-level frequency?
Can you state some of the innovations throughout history?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What is a view as it relates to system modeling?