Question

Data Warehouse 1.3 Why would you drop indexes during the Load Operation of the ETL Phase of a Data Warehouse Project?

Why would you disable foreign key constraint (referential integrity) before loading data during the Load Operation of an ETL Project Phase?

What is the Staging Area that is used during the ETL phases of Data Warehouse Project?

Name one type of Source Data System that is used to extract data during the ETL phases of a Data Warehouse Project.

During a Data Warehouse Project, which tables should be loaded first? Dimension Tables or Fact Tables?

If you extract data to a file on a UNIX system, what is the bash command to sort the data?

The _____    ______ loads the data into the data warehouse. Depending on the requirements of the organization, this process ranges widely. Some data warehouses merely overwrite old information with new data.

The _____    ________ applies a series of rules or functions to the extracted data to derive the data to be loaded. Some data sources will require very little manipulation of data.

The first part of an ETL process is to __________ the data from the source systems. Most data warehousing projects consolidate data from different source systems.

When participating in the ETL efforts associated with Data Warehouse System development, a typical step is to develop the Source System Tracking Report. What is a Source System Tracking Report, and list the steps involved in the creation of a Source System Tracking Report.

When participating in the ETL efforts associated with Data Warehouse System development, a typical step is to develop the Logical Data Map. What is a Logical Data Map, and list the steps involved in the creation of a Logical Data Map.

Answer 1

Solution:

Note: The first four subparts have been answered as per Chegg guidelines, please repost others

Why would you drop indexes during the Load Operation of the ETL Phase of a Data Warehouse Project?

This is done so that the data which is being loaded should not overwrite the existing data whose index is already in the loaded memory, so before the load, all the indexes are dropped.

Why would you disable foreign key constraint (referential integrity) before loading data during the Load Operation of an ETL Project Phase?

This is to maintain the referential integrity constraint so that any foreign value should not be affected by the changes in the current table, or to avoid any kind of anomaly which an error due to a violation.

What is the Staging Area that is used during the ETL phases of Data Warehouse Project?

The transformation of the collected data from the extraction phase is done in the staging area.

Name one type of Source Data System that is used to extract data during the ETL phases of a Data Warehouse Project.

SQL server Or Oracle or Teradata are the source data system which is used to extract the data in the initial phase of the ETL.

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)