Data Transformation & Flow
SQL Server 2014
| Intermediate
- 10 Videos | 59m 39s
- 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 transformationsdetermine whether to use SQL Joins or SSIS lookup or merge join transformationsdescribe batch processing and row-by-row processingdescribe identity mapping methodsrecognize methods for deduplication
-
describe fuzzy lookupimplement a fuzzy lookup in SSISdetermine what to do with erroneous and changed rowsdetermine auditing needs for SSIS packagesuse 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.