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 cursors?

Explain what are fact, dimension, and measure?

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

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

can anybody mail me the FAQS for hyperion essbase amd planning

Explain what is partitioning? What are the types of partitioning?

What is Discover and Execute in XMLA?

Explain why are oltp database designs not generally a good idea for a data warehouse?

What do you mean by static and local variable?

explain about dirty dimension?

Explain the difference between view and materialized view?

What is data type of the surrogate key?

For more Data Warehouse General Interview Questions Click Here