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

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

What is the purpose of Dataware Control?

What are modeling tools available in the market?

Explain what are the steps to build the data warehouse?

Explain what is a three tier data warehouse?

How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?

How to join 3 database like flat file, oracle, db2 in informatrica?

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

How to design file watch jobs?

How can we acheive correlated sub-query in designer?can anyone help me in this regard?

How we are using this function?

I need to set predefined condition. How I do this?

For more Data Warehouse General Interview Questions Click Here