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 what are data marts?

Write a short note on data warehousing & three-Tier Warehouse architecture in detail.

what is the difference between DSS and ODS ?

Explain what are the modules in power mart?

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

What is the difference between filter and lookup transformation?

Why is chameleon method used in data warehouse?

How can you set the client management?

What is latest version of power center / power mart?

Is union transormation is active transformation?

Explain the structure of cold fusion?

what are different types of partitioning in oracle ?

For more Data Warehouse General Interview Questions Click Here