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

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

What a static and local variable?

Explain difference between snow flake and star schema.

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

wat is code review and wat actually srs or how can we create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST.

Explain what are the steps to build the data warehouse?

How to create different types of templates?

How Materialized Views are linked with Oracle DataWare house?

What is the difference between ods and oltp?

What are the different types of data warehouses?

How to limit the max no of rows retrieved in the report?

Explain clustering algorithm?

For more Data Warehouse General Interview Questions Click Here