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

Where the data cube technology is used?

What are the key columns in Fact and dimension tables?

Can you pass sql queries in filter transformation?

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

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

Explain what is the difference between olap and datawarehosue?

What is conformed fact?

What is the difference between Oracle Express and Oracle Discoverer?

Tell me one example for junk dimension?

Difference between e-r modeling and dimentional modeling?

Can you brief about the Data warehouse project you worked on?

What is hybrid slowly changing dimension?

For more Data Warehouse General Interview Questions Click Here