Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a brief instruction set (1-2 pages) to schedule ETL jobs for the project. In addition to the instructions, include at least three items which

Create a brief instruction set (1-2 pages) to schedule ETL jobs for the project. In addition to the instructions, include at least three items which should be coordinated with the IT department before scheduling the ETL job on a large dataset. This week for your course project assignment, you will address ETL scheduling and publishing. This assignment is designed to provide you with life experience that you will need to perform on the job. One of the challenges in dealing with large datasets is that it can create problems for operational systems (i.e., network performance issues). To ensure a comprehensive understanding of the content in this module, you are asked to write an instruction set that will be used to schedule an ETL job for this project. In a minimum of 3 full pages provide a report that includes the following:

1. Address three potential issues which will need to be coordinated with the IT department prior to scheduling ETL jobs.

2. Discuss the process you will follow to create the ETL. What content will you be extracting? How will the data be transform? How will you load the data?

3.Review the dataset provided in Module 01. Create an actual instruction set to be used to schedule an ETL job for processing. Dataset: https://community.tableau.com/docs/DOC-1236

4. The content for Module 06 should be a minimum of 2 full pages in length. However, you are expected to provide a comprehensive report including the content from all six modules in one final paper. You will need to add an introduction at the beginning and a conclusion at the end to introduce and summarize your content.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Multimedia Database Systems

Authors: V.S. Subrahmanian

1st Edition

1558604669, 978-1558604667

More Books

Students also viewed these Databases questions