SQL Server Integration Services (SSIS) is an Extract-Transform-Load (ETL) tool that is in the SQL Server Family. As shown in the following image, ETL is an important part of the data warehouse tool.
Conditional Split and Fuzzy Lookup are important controls in the SSIS. Further, using the SSIS script component, data sources can be created. Slowly changing Dimensions or SCD are configured in SSIS as it enables historical aspects of data warehouses.
Change Data Capture (CDC) enables the extraction of incremental data for the data warehouse. SSIS supports CDC with multiple controls.
You can execute Data Mining queries from SSIS to query the Data Mining Model. There are options to retry the SSIS package during the failure.
No comments:
Post a Comment