Research the concepts and technology of data etl

Assignment Help Software Engineering
Reference no: EM131258458


Research the concepts and technology of data ETL (Extraction, Transformation & Loading) and document the process from start to finish using Microsoft SSIS (SQL Server Integration Services) as the basis of your study.

Learning Outcome(s) Being Assessed:

1. Describe the operation of a data warehouse in support of business intelligence.

2. <not assessed in this coursework>

3. <not assessed in this coursework>

4. <not assessed in this coursework>

5. <not assessed in this coursework>

Details of Task:

ETL is an important process in the construction of Data WareHouse solutions. It consists of the following three primary phases, you must research each as well as the more specific steps contained within:

- Extracting Data
o From one or more external data sources.

- Transforming Data
o Ensure consistency and satisfy business requirements.

- Loading Data
o To the resultant Data WareHouse.

Microsoft SSIS provides a collection of tools to support ETL including:

- Data Flow Engine.
- Scripting Environment.
- Data Profiler.

"SSIS also acts to glue together the various servers and engines that make up SQL Server".

You must discuss the various tools that SSIS provides and relate them to the phases within ETL. You should also provide suitable examples from case studies (such as AdventureWorks & AdventureWorksDW) to reinforce your discussions.


- Correctly reference resources that you use.
- You may also wish to compare & contrast other ETL solutions.

Resources Required:

You may use the computing laboratories on the 6th & 7th floors and the university's database servers (ask the lecturer for details).

You should make use of these specific tools & resources:

- Microsoft SQL Server 2012.
- SQL Server Books Online.
- The Internet.

Extenuating Circumstances:

If something serious happens that means that you will not be able to complete this assignment, you need to contact the module leader as soon as possible. There are a number of things that can be done to help, such as extensions, waivers and alternative assessments, but we can only arrange this if you tell us. To ensure that the system is not abused, you will need to provide some evidence of the problem.

More guidance is available at:

Reference no: EM131258458

Create the diagram 0 dfd for new century

Create the diagram 0 DFD for New Century. Make sure to illustrate numbered processes for handling appointment processing, payment and insurance processing.

Consist of a series of phases

The software life cycle can be said to consist of a series of phases. The classical model is referred to as the waterfall model. Which phase may be defined as "The concept is

Identify resource requirements

The purpose of the BIA is to identify and prioritize system components by correlating them to the business process(es) the system supports, and by using this information to

Create either pseudocode or flowchart for program

Create either pseudocode or a flowchart for a program that does the following: Prompt the user to enter a sales tax rate. Prompt the user to enter a price.

Compare different productivity software in the cloud

Compare Different Productivity Software in the Cloud. Based on your Week One Learning Team Collaborative discussion, submit, individually, a comparison of the different kinds

Why it is important to use white box and black box testing

why it is important to use WHITE BOX AND BLACK BOX testing technique to evaluate a software module. This assignments needs to be at least 5 pages and no more than 10 pages.

Design a software application

During this course, we will design a software application. The requirements for the application are below. Design artifacts that we will deliver during this course are:Sequenc

Compare different software development methods

Define and explain, in your own words, the primary challenge(s) of software development projects. Compare and contrast at least three (3) different software development method


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd