SSIS Real World Scenarios Projects Tricks of the Trade

SSIS Real World Scenarios Projects Tricks of the Trade

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English | Duration: 32 lectures (6h 15m) | Size: 1.79 GBLearn Microsoft Business Intelligence SQL SSIS Tools & Package with ETL in Data Warehouse Step by Step via SSDT in MSBIWhat you'll learn:Three Real World Scenario Based ProjectsExpressionsParametersDebugging and TroubleshootingProject DeploymentRequirementsBeginners level knowledge of developing SSIS Packges is mustControl flow, Data flow and Connection Manager concept should be knownDescriptionThis Microsoft SQL Server SSIS is an intermediate level training course and it is the part of MSBI. You have to have the knowledge of basic tools and package creation. This SQL Server Integration Services course using SSDT contains three projects along with other tricks based on real world scenarios. All the projects are developed step by step. In one project you can learn how to perform ETL operation for the data warehouse using SSIS as well . The contents of this online SSIS business intelligence video tutorial on Udemy as follows.How to use Temporary Table in SSIS PackageTransferring Data from OLTP to Staging TableTransferring data from Staging to DatawarehouseTesting Metadata of the files and Loading the dataHow to execute Foreach Loop Fixed Number of TimesSSIS Expression to get the File Name from the complete File PathSSIS Expression to separate Name and Date Component of a fileYYYYMMDD date format using SSIS expressionCompress and Uncompress Folder using Winrar in SSISParameter Settings of the ProjectTesting the existence of Compressed FileExtracting ZIp File From Shared Folder to Local Processed FolderTesting Date Component of each file with the Current DateDynamically Deciding which file to load in which tableETL OperationsETL with Lookup OptionShared Folder Transfer and Naming ConventionsDebugging and Troubleshooting SSIS PackagesBreakpoints , Watch Windows and Data ViewerTroubleshooting Problematic Records Using Data Flow PathsTroubleshooting with Precedence ConstraintsDeploying the Packages to Integration Services CatalogSetting up Test and Production EnvironmentAutomating the Package Execution and Checking the Reports of ExecutionWho this course is forIntermediate Microsoft Business Intelligence developers interested in deepen the knowledge in SSIS TechnologyWho wants to work on some projects in SSIS TechnologyAlso wants to crack interviewsHOMEPAGE