How many clustered indexes can you create for a table in dwh? In case of truncat

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

Question Posted / anand singh

No Answer is Posted For this Question
Be the First to Post Answer

More Data Warehouse General Interview Questions

Explain why denormalization is promoted in universe designing?

what is the difference between MOLAP and ROLAP?

Explain what are the advantages data mining over traditional approaches?

Who needs data warehousing?

what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-

Explain what is cost benefit analysis (cba)?

Hierarchy of DWH?

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 dimension modeling?

What Oracle tools can be used to design and build a W/H?

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

how can one connect two fact tables ? is it possible ? how?

For more Data Warehouse General Interview Questions Click Here