1

Unit 15. Mapping Design

Unit 15

2

Unit 15 Workshop Load Promotions Daily Aggregate Table

Design your own mapping

StagingArea

DataWarehouse

STG_TRANSACTIONS(Oracle table)

FACT_PROMOTIONS_AGG_DAILY(Oracle table)

Unit 15

3

Unit 15 Workshop Review

• What was your approach/solution?

• What did you accomplish with this workshop?

• Questions?

Unit 15