Question: ETL TaskStage of ETL Process 1 . Use SQL to extract data from the source database . 2 . Remove headings or subtotals . 3

ETL TaskStage of ETL Process1. Use SQL to extract data from the source database.2. Remove headings or subtotals.3. Choose which database and specific data will be needed to address the accounting question.4. Compare the number of records extracted to the number of records in the source database.5. Make sure all data formats start with two capital letters. Fix inconsistencies.6. Input the data into the analysis too

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!