Data Marts
* Dependent DM* Independent DM Database Design
* Star Schema
* Fact Constellation Schema SCD (Slowly Changing Dimensions)
* TYPE1SCD
* TYPE2SCD
* TYPE3SCD Basic concepts in SQL
ETL Testing
ETL Testing
Overview
ETL is commonly associated with Data Warehousing projects but there in reality any form of bulk data movement from a source to a target can be considered ETL. Large enterprises often have a need to move application data from one source to another for data integration or data migration purposes. ETL testing is a data-centric testing process to validate that the data has been transformed and loaded into the target as expected.
What you'll learn
Course Conent
What is Data Warehousing?
Difference between OLTP and Data Warehousing
Data Acquisition
* Data Extraction
* Data Transformation
* Data Loading
* Independent DM Database Design
* Star Schema
* Fact Constellation Schema SCD (Slowly Changing Dimensions)
* TYPE1SCD
* TYPE2SCD
* TYPE3SCD Basic concepts in SQL
Overview of ETL Tool Architecture
Components in ETL Tool
*White Box and Block Box testingTransformation rules:
* SAMPLE Loading from source target* SORTER Transformation
* FILTER Transformation
* ROUTER Transformation
* EXPRESSION Transformation
* JOINER Transformation
* UNION Transformation
* AGGREGATOR Transformation
* RANK Transformation
* STORED PROCEEDURE Transformation
* SEQUENCE GENERATOR Transformation
* Flat File
* SQL Transformation
Data warehousing Life Cycle
Different Types of testing
Techniques in ETL
* MINUS Query
* COUNT Query
About us
Bluebell Research Australia Pty. Ltd. is an Australian Startup engaged in training and placing candidates across Australia.
Contact Us
Email: training@bluebellresearch.com.au
Ph: +61 457298829/416769207
Address: 79 George Street, Parramatta, NSW, Australia