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.
- 1 Answers
- 1150 Views
- I also Faced
- E-Mail Answers
Answer Posted / Farha Adil
In a data warehouse, you can create multiple non-clustered indexes on a single table but only one clustered index. The primary key constraint is used to create the clustered index by default if not specified otherwise. When a table with a unique ID (such as a primary key) is truncated or deleted, all data is removed and the structure remains intact.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Explain how to generate iqd file from framework manager?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
What is the purpose of Dataware Control?
