December 2012
Beginner to intermediate
845 pages
23h 33m
English
book
Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012
by Dejan Sarka, Grega Jerkic, Matija Lah
Content preview from Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 3. Creating SSIS Packages
Exam objectives in this chapter:
Extract and Transform Data
Define connection managers.
Load Data
Design control flow.
Data movement represents an important part of data management. Data is transported from client applications to the data server to be stored, and transported back from the database to the client to be managed and used. In data warehousing, data movement represents a particularly important element, considering the typical requirements of a data warehouse: the need to import data from one or more operational data stores, the need to cleanse and consolidate the data, and the need to transform data, which allows it to be stored and maintained appropriately in the data warehouse.
Microsoft SQL Server 2012 ...