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 is the data type of the surrogate key?

Hi,Please can u tell me.. What is the difference between a Hyperion Essbase CUBE and a Star Schema? Thanks in advance, Vijay.

What is factless fact tables?

What is incremintal loading?

What are the different methods of loading dimension tables?

Explain the main differences between star and snowflake schema?

5.Explain ODS ?

What is the difference between narmal load and bulk load?

Why is chameleon method used in data warehouse?

What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh

What is the difference between metadata and data dictionary?

Can any one explain the hierarchies level data warehousing.

For more Data Warehouse General Interview Questions Click Here