Perform etl on the data using given information

Assignment Help Computer Engineering

Reference no: EM132609185

Assignment: Build data with the combined data sources we will be able to view each state's laws regarding recreational use and each state's legal classification.

Perform ETL on the data. Make sure to plan and document the following:

• The sources of data that you will extract from.

• The type of transformation needed for this data (cleaning, joining, filtering, aggregating, etc).

• The type of final production database to load the data into (relational or non-relational).

• The final tables or collections that will be used in the production database.

You will be required to submit a final technical report with the above information and steps required to reproduce your ETL process.

You should include an ERD showing your final database table structures and relationships (having relationships between tables is optional but may make sense for your data analysis).

Reference no: EM132609185

Questions Cloud

What is the lessons learned program : What is the Lessons Learned Program and how might it relate to better project management at NASA? NASA and SpaceX recently completed

What circumstance might a company be tempted to pay : What circumstance might a company be tempted to pay dividends which are in excess of earnings and what are the dangers associated

Determine optimal capital structure : Moses Company has a total asset of 400,000 of which 30% is debt with 12% interest and 70% is equity. Determine optimal capital structure

What adjusting entries the rent income account has a balance : The Unearned Rent Income account is to be decreased by $200. After processing these adjusting entries the Rent Income account has a balance

Perform etl on the data using given information : Build data with the combined data sources we will be able to view each state's laws regarding recreational use and each state's legal classification.

Determine the cash payments made during the year : Determine the cash payments made during the year for insurance premiums. Assume all insurance premiums are paid in cash. Insurance Expense 475

Discussing different types of video streaming : When discussing different types of video streaming, the question of throughput must be considered

Explain how balancing the interests of global and local : Explain how balancing the interests of global and local, occupational and functional perspectives may play out in a compensation decision scenario?

What accounting method should hariette choose : Hariette would like to review the income and expenses. What accounting method should Hariette choose when she runs the Profit & Loss report

User Account

All Pages