CT 110 – Stage Component
What’s Covered
Are you ready to start collecting data? Stage components move data from a source system to controlled destination. In this course you will learn how to create a source system profile and incrementally extract source records using stage components.
Course Notes
There are two methods available for creating stage components; manual and automatic profile generation. This course covers the manual profile generation process.
Goals
- Define stage component
- Demonstrate creating a profile
- Demonstrate creating a stage component
- Introduce project statistics
Prerequisites
- BD 100 – Development Workflow
- BD 110 – Dimensional Modeling Introduction
- BD 120 – Data Flow Diagram
- CT 100 – Connection Component
Configuration & Tools
- SQL Server Management Studio 2012
- SQL Server Data Tools 2012
- Database – AdventureWorks 2012
- Visio 2010
- SQL Server 2012 Database Engine
Training Project
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 support@leapfrogbi.com to add a fully editable copy of this course’s project to your LeapFrogBI account.
User Name: Student
Password: leapfrogbi
Project Name: CT 110
Supporting Materials & References
SalesDataModel_v01.vsd – Visio data model diagram created during course BD 110 (attached)
SalesDFD_v01.vsd – Visio ETL data flow diagram created during BD 120 (attached)
CT110.zip – SSIS 2012 project containing profile packages covered in this course (attached)
AdventureWorks 2012 – SQL Server 2012 Sample OLTP Database