What is the purpose of data normalization in a data warehouse?
Correct Answer: Data normalization ka purpose data redundancy ko kam karna aur data integrity ko improve karna hai.
- Step 1: Understand what data normalization means. It is a process used to organize data in a database.
- Step 2: Know that the main goal of normalization is to reduce data redundancy. This means avoiding duplicate data.
- Step 3: Learn that normalization helps improve data integrity. This means ensuring that the data is accurate and consistent.
- Step 4: Recognize that in data warehouses, normalization is often not used as much. Instead, they may use denormalization.
- Step 5: Understand that denormalization is used in data warehouses to improve performance, making data retrieval faster.
No concepts available.
