Courses Search

(search any course. example: Sap Bw, Java etc.)

Register for a Demo



















helpdesk@sscyient.com    +1 (415)-873 0245

1 ETL Testing Online Training

 

2 Purpose of Datawarehouse

3 Tools used to Load data into the data warehouse

4 About Datawarehouse Testing

5 Need for ETL Testing

6 ETL Testing phases

  • Business understanding
  • Test plan creation
  • Test environment setup
  • Test script generations
  • Execution
  • Reporting

7 How is ETL Testing different from normal Testing

8 How to ensure no data loss

9 Transformation Rules

10 Data validation Strategies

  • Data file loads
  • Data validation with in staging tables to check all Mapping rules
  • Data validation with in Target tables to ensure data is present in required format

11 Staging Area

  • Test approach and procedure in staging area

12 SOR Area

  • Test approach and procedure in SOR area

13 Datamarts Area

  • Test approach and procedure in Datamarts area

14 Live project examples of ETL Testing with Data stage ETL Tool

15 Most commonly used SQL oracle queries useful in ETL Testing

Other Courses
© Copyrights SSCyient 2014. All Rights Reserved. Sitemap