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

Tell me one example for junk dimension?

what is data validation strategies for data mart validation after loading process

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

Explain what are slowly changing dimensions?

What are the methodologies of data warehousing?

Explain the difference between keylokup and joiner?

What are vaious etl tools in the market?

Explain the data types present in bo n wht happens if we implement view in the designer n report?

Explain what are the tasks that loadmanger process will do?

Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K

What is an error log table in informatica occurs and how to maintain it in mapping?

What is the difference between er modeling and dimensional modeling?

For more Data Warehouse General Interview Questions Click Here