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.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Warehouse General Interview Questions

How can we run the graph?

0 Answers  


Explain what is partitioning? What are the types of partitioning?

0 Answers  


what type of raid setup would you put your tx logs?

0 Answers  


What are snapshots? What are materialized views & where do we use them?

0 Answers  


Database in use is oracle?

0 Answers  






Could any one explain me how to create cascading prompts?

0 Answers  


suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?

3 Answers   Oracle,


ware house management system is used?

0 Answers  


What are cursors?

4 Answers  


What is staging area?

9 Answers  


What are the approaches used by optimizer during execution plan?

0 Answers  


How would you write a left join statement to return a result set of movie.title�s and director.name�s?

0 Answers  


Categories