CT 120 – PSA Component
A resilient data mart should include a consolidated view of all source system records collected. This is the role of the persistent stage area (PSA) component. PSA provides a dependable source for all downstream components designed to support agile development processes.
Recordtime and load status tracking will be introduced in this course.
- Define PSA component
- Demonstrate creating a PSA component
- Introduce Recordtime
- Setup Load Status flags
- BD 100 – Development Workflow
- BD 110 – Dimensional Modeling Introduction
- BD 120 – Data Flow Diagram
- CT 100 – Connection Component
- CT 110 – Stage Component
Configuration & Tools
- Visio 2010
- SQL Server 2012 Database Engine
To review the project created during this course log into LeapFrogBI using the following credentials and select the corresponding project from the Training Account project list. Send a request to firstname.lastname@example.org to add a fully editable copy of this course’s project to your LeapFrogBI account.
User Name: Student
Project Name: CT 120 & CT 150 (PSA Update is in CT 150)
Supporting Materials & References
SalesDataModel_v01.vsd – Visio data model diagram created during course BD 110 (attached)
SalesDFD_v02.vsd – Visio ETL data flow diagram created during BD 120 (attached)
SalesDFD_v06.vsd – Visio ETL data flow diagram created during BD 120 with load status created (attached)