Explain are data mart and dwh normalized or denormalized? Do both of them exist in
- 1 Answers
- 1111 Views
- I also Faced
- E-Mail Answers
Answer / Jitesh Singh
Data Marts and Data Warehouses can be either normalized or denormalized depending on the specific design requirements. Normalization is used to reduce redundancy and improve data integrity, while denormalization is used for faster query performance. Both Data Marts and Data Warehouses can exist in both normalized and denormalized forms.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the purpose of cluster analysis in data warehousing?
What are the advantages and disadvantages of reporting directly against the database?
what are the all possible features supported modify stage?
What is hash partition?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
in general which algorithms for used?
What is difference between model & package?
What is IQD file?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
How can you set the client management?
Where the applications and where ware house management system is used?
What is the difference between ods and oltp?
Teradata 
