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

Explain how to generate iqd file from framework manager?

What is the difference between star and snowflake schemas?

How can we do ETL process in SQL Server?

Explain what is fact less fact table? Where you have used it in your project?

Explain the difference between filter and conditin?

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

Explain what are the different types of join operations?

Explain conformed fact?

Explain what is batch and describe about types of batches?

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

Can we take backup when the database is opened?

What is Operational Data Store?

For more Data Warehouse General Interview Questions Click Here