Interview Questions and Answers

Checkpoints in SSIS allow restarting a package from a specific point in case of failure. It saves the execution information at predefined checkpoints during package execution.

The SSIS Expression Task is used to evaluate expressions at runtime. It can be used to set variable values, update properties dynamically, or perform calculations during package execution.

Change Data Capture (CDC) in SSIS is a feature that identifies and captures changes made to source data. It is used to track and process only the changed data in the data flow.

SSIS Package Deployment Models refer to the two deployment options: Project Deployment Model (introduced in SSIS 2012) and Package Deployment Model. Project Deployment Model is the recommended approach for deploying and managing SSIS projects.

The SSIS Term Extraction Transformation is used to identify and extract specific terms or phrases from text data. It is commonly used in text mining or content categorization scenarios.

The SSIS Term Lookup Transformation is used to enrich data by looking up and replacing terms with their corresponding values from a reference table. It is often used in data cleansing or standardization.