Data Warehousing Question:

What is galaxy schema?

Data Warehousing Interview Question
Data Warehousing Interview Question

Answer:

Galaxy schema is also known as fact constellation scheme. It requires no of fact tables to share dimension tables. In data, wares housing mainly the people are using the conceptual hierarchy.


Previous QuestionNext Question
Briefly state different between data ware house & data mart?Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition.