ETL Assignment

1
Data Warehousing
ETL Assignment
ETL is the link between the operational systems in an organization and its data warehouse.
It would be a shame to complete a course in data warehousing without having any idea
what ETL is, not only because of how many jobs involve it, but because it provides the
context for how data warehouses are created and used.
The questions for this assignment are based on those from in the exercise. You may need
to refer to both the schemas and the data itself to develop your answers to these questions:
1) Identify any columns in the transaction processing system (TPS) that do not have a
direct one-to-one correspondence with a column in the star schema. For the columns
you identify, list the table and column names as the appear in the TPS:
Transaction Processing System
Table Column
(Name of table) (Name of column)
(Name of table) (Name of column)
… …
2) Next, identify any columns that appear in the star schema that do not have a direct
one-to-one correspondence with a column in the TPS. List the table and column
names in the TPS and the table and column names in the star schema and why they
appear, such as if they are transformations from columns in the TPS. One simple form
of transformation could be a renaming of a single columns, other transformations
could include splitting a TPS column or combining it with other columns, such as
with an aggregations or calculation.
Since dimDate is an entirely new table that has many columns, for this part you only
need to consider the first three columns in your answer.
The table below shows the format to use along with two lines as examples. The first
shows a column that was pulled from the TPS and appears in the star schema after
being renamed. In indicating table and column names you can either list each
separately (as shown below) or together separated by period
(tablename.columnname) as you’d see in SQL.
The second example shows a column in the star schema that is a calculation based on
two columns from the TPS. Those two columns from different tables in the TPS and
are divided to calculate a value for a column in the star schema.
Star Schema TPS
Table Column Table Column Transformation
(Table name) (Column name) (TPS Table name) (Name of TPS column) (Renamed)
(Table name A)
(Table name B)
(Column name A)
(Column name B)
(TPS Table name)
(Name of TPS column) Calculated from TPS as
Table name A.Column nameA /
Table name B.Column name B
Probably to no surprise, the deliverable for this assignment is a single pdf file uploaded to
Blackboard. After you have the answers completed and written in your document, save it
as a pdf file, upload that file to Blackboard, and you are set.


Buy plagiarism free, original and professional custom paper online now at a cheaper price. Submit your order proudly with us



Essay Hope