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 in detail abt measure objects? And what is the use of it? How to create it?

What is Active Datawarehousing?

What is a functional dependency f said to be minimal?

State any 5 of Cods guidelines of an OLAP system, brief description each?

What are the reasons to use a chameleon method in data warehousing?

What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

How to define a cube??

Explain what are the steps to build the data warehouse?

What is data merging, data cleansing and sampling?

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

What is the difference between view materialized view and view?

For more Data Warehouse General Interview Questions Click Here