In a star schema, are foreign key constraints between facts and dimensions necce

In a star schema, are foreign key constraints between facts and dimensions neccessary?

Question Posted / vishwadeep tyagi

No Answer is Posted For this Question
Be the First to Post Answer

More Data Warehouse General Interview Questions

what are the types of dimension tables

Explain what are the advantages and disadvantages of reporting directly against the database?

What is mapplet?

What is the difference between view filter and report filter?

How does data mining and data warehousing work together?

How to limit the max no of rows retrieved in the report?

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

What are the reasons to use a chameleon method in data warehousing?

What are the different types of join operations?

How can we run the graph? How can we schedule the graph in unix?

What are aggregate fact tables ? why they are needed? give an example

What are Aggregate tables?

For more Data Warehouse General Interview Questions Click Here