Course details

Data Load Options

Data Load Options


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
SSIS is an extensible platform for creating data integration and workflow solutions. In this course, you will explore various options to load data.

Target Audience
Data warehouse developers and database administrators who create and manage business intelligence solutions as part of their daily tasks, which include implementing data warehouse databases, extracting and transforming data as part of an ETL solution, and data cleansing

Prerequisites
None

Expected Duration (hours)
1.0

Lesson Objectives

Data Load Options

  • start the course
  • describe data loading
  • perform an incremental data load strategy
  • perform a full data load strategy
  • describe data mart
  • plan for an incremental update of the relational data mart
  • plan for loads into indexed tables
  • configure bulk load options
  • select an appropriate load technique (SSIS Destination)
  • select an appropriate load technique (T-SQL)
  • select appropriate load partitioned tables
  • Course Number:
    md_idwm_a11_it_enus

    Expertise Level
    Intermediate