Data Flow Implementation & ETL

Extract transform load (ETL) is the main process in data warehousing solutions and helps transfer data from one source to another. During this course you will examine the ETL process and how it can be implemented. You will start by examining data flows and how to debug them. Next you will learn how to use SQL Server Integration Services (SSIS) and perform a broad range of data migration tasks. These include how to create SSIS packages transform data and perform lookup tasks. Next you will employ ETL the SSIS data warehousing tool to facilitate the transfer of data from a source to a destination. Discover how to implement the ETL process to extract transform and load data. Specify a data source and a destination. Finally you will performance tune SSIS data flow and optimize data Integration Services.