ETL TESTINING - KMRsoft ETL TESTINING - KMRsoft

tx-course

ETL TESTINING

ETL TESTINING

ETL testing online training at KMR Software service is an etl testing online course that will include concepts like ETL testing certification and it helps how to prepare you to crack your certification exams.

• Software Testing Life Cycle
• Software Development Life Cycle
• Manual Testing Experience is Plus
• Usage of HP quality Center
• Defect Life Cycle

• What is Data Ware House?
• Difference between OLTP and Data warehousing

• Data Extraction
• Transformation
• Data loading

• Star Schema
• Snow Flake Schema

• Type-1 SCD
• Type-2 SCD
• Type-3 SCD

• SELECT
• Single Row Functions
• Aggregate Functions
• JOINS
• SUBQUERYS
• SET Operators
• Analytical Functions
• DDL, DML, Views (High level Concepts)

 Introduction
o What is use of ETL TESTING?
o Responsibilities of an ETL Tester
Testing methodologies
o Smoke Testing
o Functional Testing
o System Testing
o ETL Testing Work Flow Process
o How to Prepare the ETL Test Plan
o How to reporting the Bugs in ETL Testing?
o ETL Testing Responsibilities
o How to design the Test cases in ETL Testing
o How to detect the bugs through database queries
o ETL Performing Testing & Performing Tuning

• ETL Testing with Informatica PowerCenter
o SAMPLE Loading from source to target
o SORTER Transformation
o FILTER Transformation
o ROUTER Transformation
o EXPRESSION Transformation
o JOINER Transformation
o UNION Transformation
o AGGREAGATOR Transformation
o RANK Transformation
o STORED PROCEDURE Transformation
o SEQUENCE GENERATOR Transformation
o Flat File
o Look up Transformation
o Slowly Changing Dimension Type 1
o SCD Type 2
o SCD Type 3

 

Our Courses

Need Help? Chat with us