What is the purpose of ETL in data warehousing?
Correct Answer: ETL ka purpose data ko source systems se data warehouse mein transfer karna hai.
- Step 1: Understand that ETL is a process used in data warehousing.
- Step 2: Learn that ETL stands for Extract, Transform, Load.
- Step 3: Know that 'Extract' means taking data from different source systems.
- Step 4: Understand that 'Transform' means changing the data into a suitable format for analysis.
- Step 5: Realize that 'Load' means putting the transformed data into the data warehouse.
- Step 6: Remember that the purpose of ETL is to prepare and organize data for better analysis and reporting.
No concepts available.
