How many clustered indexes can u create for a table in dwh? In case of truncate

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

Question Posted / hima bindu

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

More Data Warehouse General Interview Questions

Explain difference between snow flake and star schema.

Explain vldb?

What is an OLTP (Online Transaction Processing) System?

What is the difference between olap and datawarehosue?

4.Explain Snowflkeschema ?

What is the difference between an ODS and a W/H?

What is the difference between er modeling and dimensional modeling?

What is the difference between power center and power mart?

What are the vaious etl tools in the market?

What is the purpose of cluster analysis in data warehousing?

Explain what are non-additive facts in detail?

What is a fact, dimension, measure?

For more Data Warehouse General Interview Questions Click Here