When Does Information Cleansing Occur in the Data Warehouse

question 37

Multiple Choice

When does information cleansing occur in the data warehouse?

• A) During the ETL process.
• B) On the information, once it is in the data warehouse.
• C) During the ETL process and once it is in the data warehouse.
• D) During the ETL process and before it is in the data warehouse.

---

Definitions:

Capacity Planning

Capacity Planning involves the process of determining the production capacity needed by an organization to meet changing demands for its products or services.

Aggregate Planning

A process by which a company determines optimal levels of capacity, production, subcontracting, inventory, stockouts, and pricing strategies over a specified time frame.

Short-Term Schedules

Plans that outline specific activities, resources, and timelines within a short timeframe, typically up to one year.

Forward Scheduling

Forward scheduling is a planning method where tasks are scheduled from the start date onwards to determine the earliest possible completion time.