חומר למבחן SSIS

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