ABINITIO ONLINE TRAINING

DataWarehousing concepts:

• DBMS and RDBMS
• What is DataWareHousing and necessity of it?
• Data warehousing architecture
• OLAP,ROLAP, MOLAP
• Data mining
• Meta data
• Tables, views
• Constraints
• Fact and Dimensional Tables
• Partitioning of tables
• Concepts of Referential Integrity
• Concepts of Modelling 
• Database Schema
• Concepts of normalization
• Concepts of Slowly Changing Dimensions
• Concepts of Data Mart
• Full and Incremental extraction Process
• Change Data capture

SQL Concepts:

• DDL, DML commands
• All the basic functions (Character Functions, Conversion Functions, Advanced functions, Mathematical Functions and Date Functions)
• Joins
• Practice SQLs for some sample test scenarios
  

ETL testing:

• What is ETL and importance of ETL testing??
• Creating, running and analysing sessions/workflows in Informatica
• Preparation of Test strategy, Test plan and estimations
• Testing scenarios, creation of test cases and scripts
• Test case execution and defect tracking and reporting
  

Report Testing:

• Validation of the report data with DB and UI testing
• Preparation of Test data

Levels of testing

• Unit testing
  
• Intigration testing
  
• Module testing
  
• System testing
  
• Uat