ITSS 4351

itss4300
ICE2-DB.docx

ITSS 4351 – Foundations of Business Intelligence

In Class Exercise – ETL (10 points)

Problem Statement: UPS Inc is a leader in Transportation Solutions. They very recently hired a new CIO who would lead their Technology Strategic Initiatives. One of the challenges was to merge multiple databases to create a single warehouse. List of some of the tasks that the team will have to perform in order to unify the databases.

Link: https://web.microsoftstream.com/video/66fe9990-6f95-443c-a497-54ac324ee043

Login ID: axk162731@utdallas.edu Pass: Tazimfarooq88

Passcode for authentication: 7789698