What is the main purpose of data normalization in a data warehouse?
Correct Answer: Data normalization ka main 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 to reduce duplication.
- Step 2: Recognize that data redundancy is when the same piece of data is stored in multiple places, which can lead to inconsistencies.
- Step 3: Learn that data integrity refers to the accuracy and consistency of data over its lifecycle.
- Step 4: Know that in a data warehouse, the main goal is to analyze data rather than to manage day-to-day operations, so normalization is less common.
- Step 5: Conclude that while normalization helps reduce redundancy and improve integrity, data warehouses often use different methods to handle data.
No concepts available.
