חומר למבחן SSIS
- class928417
- Oct 29, 2014
- 2 min read
SSIS SUBJECTS
Control Flow - Precedence Constraints
Control Flow - Group Components
Control Flow - Execute SQL Task
Control Flow - File System Task
Control Flow - Sequence Container
Control Flow - For Each Loop Container - File Enumerator
- ADO Enumerator
Control Flow - For Loop Container
Control Flow - Map Query Parameters to Variables in an Execute SQL Task
Data Flow - Flat File Source
Data Flow - Multicast
Data Flow - Conditional Split
Data Flow - Result Set Destination
Data Flow - Row Count
Date Flow - Derived Column Transformation
Date Flow - Lookup Transformation
Data Flow - Union All Transformation
Data Flow - Merge Transformation
Data Flow - Merge Join Transformation
Data Flow - Error Handling in Data
Data Flow - Data Conversion Transformation
Data Flow - Aggregate Transformation
Data Flow - OLE DB Source (Including SQL command from variable and Parameterized SQL)
ADO .NET Source
Debug a Package by Setting Breakpoints on a Task or a Container
Debug using Watch Window
Event Handler
Enable Package Logging in SQL Server Data Tools
SSIS CF and DF Error Handling (including MaximumErrorCount property)
Create and populate Log tables at Control Flow and Data Flow (User defined tables)
SSIS Variables
SSIS Expressions
SSIS Data Types (Casting at SSIS)
SSIS Progress Tab
SSIS Output Window (View-->Output)
SSIS Naming conventions
SSIS Parameters (Project level and Package level)
Loading Dimension Tables (Full data)
Truncate and Insert
SCD - Slowly Changing Dimension
Type 0: Fixed attribute (No Change)
Type 1: Simple Upsert
Type 2: Save historical data
Type 3: Save current and previous values on each row
Loading Fact Tables (Incremental data)
Performance and Best Practice
Buffer Usage
Sort Data for the Merge and Merge Join Transformations
LookUp Transformation - Cache Using
Best Practices
Extending SSIS - Script Component
Deployment of Projects and Packages
Schedule a package (in Job) by using SQL Server Agent
Comentários