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

What is normalization, first normal form, second normal form, third normal form?

what is the difference between aggregate table and fact table ? how do you load these two tables ?

What is the difference between data warehouse and operational systems?

What are components of reportnet?

Explain can a dimension table contains numeric values?

What is a full backup?

What is metadata in context of a datawarehouse?

Is union transormation is active transformation?

What are Data Marts?

What is the use of dimensional modeling in data warehousing?

Explain ddl (data definition language)?

What is DTS ?

For more Data Warehouse General Interview Questions Click Here