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

List down some of the real time data-warehousing tools?

Is union transormation is active transformation?

if source contain 10records how you identify header and footer

What are the different types of datawarehosuing?

What is loop in data warehousing?

For faster process, what we will do with the universe?

Explain what are the various reporting tools in the market?

Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

Explain what is a three tier data warehouse?

I know of using applysimple, but there are other ways too?

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

Explain what is a view as it relates to system modeling?

For more Data Warehouse General Interview Questions Click Here