john27 Posted July 20, 2019 Report Posted July 20, 2019 Best Online Training Providers by Real Time Experts on ETL Testing : ETL Testing Course Content : Data Warehouse Concepts What is Data Warehouse? Introduction to Data warehouse Characteristic features of Data warehouse Time Variant Non-Volatile Subject Oriented Integrated Differences between OLTP and OLAP What is Data Warehousing? Design Schema ETL – Extraction Transformation & Loading Reporting Data Acquisition Data Extraction Data Transformation Data Cleansing Data Scrubbing Data Merging Data Aggregating Data Loading Initial Load / Full Load Incremental Load / Delta Load Data Marts Top down Approach / Dependent Data Mart Bottom up Approach / Independent Data Mart Dimension Table & Fact Table Database Design Star Schema Snow Flake Schema Slowly Changing Dimensions [SCD] SCD Type 1 SCD Type 2 SCD Type 3 Phases in Dimensional Modeling Conceptual Modeling Logical Modeling Physical Modeling Basic concepts in SQL Data Warehousing Architecture Types of Transformations Active Transformation Sorter Transformation Filter Transformation Router Transformation Rank Transformation Joiner Transformation Union Transformation Aggregator Transformation SQL Transformation Passive Transformation Expression Transformation Sequence Generator Transformation Stored Procedure Transformation Connected Transformations Unconnected Transformations Real-time Scenarios Finding difference between source tables and target tables Finding Duplicate Records Finding Junk Values Incompatible and duplicate data Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.