Data Transformation & Flow
SQL Server 2014
| Intermediate
- 10 Videos | 1h 4m 9s
- Includes Assessment
- Earns a Badge
When working with data in a data warehouse, some level of transformation is usually required between the source and destination. Learn how to work with transformations and design data flow.
WHAT YOU WILL LEARN
-
determine the need for supporting Slowly Changing Dimensions transformations
determine whether to use SQL Joins or SSIS lookup or merge join transformations
describe batch processing and row-by-row processing
describe identity mapping methods
recognize methods for deduplication -
describe fuzzy lookup
implement a fuzzy lookup in SSIS
determine what to do with erroneous and changed rows
determine auditing needs for SSIS packages
use data flow to load data in SQL Server 2014
IN THIS COURSE
-
1.Slowly Changing Dimensions Transformation5m 19sUP NEXT
-
2.Implementing Transformations6m
-
3.Processing Options3m 45s
-
4.Identity Mapping6m 15s
-
5.Deduplication4m 7s
-
6.Fuzzy Lookup6m 6s
-
7.Implementing a Fuzzy Lookup9m 36s
-
8.Erroneous Rows5m 8s
-
9.Auditing6m 44s
-
10.Exercise: Use Data Flow in SQL Server 20146m 39s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.
