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

Define Data Warehousing?

what are the types of dimension tables

What is metadata in context of a datawarehouse and how it is important?

Who needs data warehousing?

Explain what are non-additive facts?

Explain what are the vaious etl tools in the market?

What is the use of dimensional modeling in data warehousing?

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends

Explain what is batch and describe about types of batches?

What is DTM session?

What is the limit to the number of sources and targets you can have in a mapping?

For more Data Warehouse General Interview Questions Click Here