ETL Testing Training in Electronic City
Let eMexo Technologies Best ETL Testing Training in Electronic City, Bangalore take you from the fundamentals of ETL Testing to Advance ETL Testing and make you an expert in automating real time applications. Here are the major topics we cover under this ETL Testing course Syllabus Data Warehousing Concepts, ETL Testing,Challenges in DWH ETL Testing compare to other testing, ETL Testing Workflow activities involved, Types of ETL Testing, SQL Queries for ETL Testing, Incremental load testing, Power Center Components. Every topic will be covered in mostly practical way with examples for our ETL Testing Course in Electronic City.
All the topics will be covered with Practical and hands on training. Our trainers have industry experience with live project experience in cutting edge technologies which they teach. We hire only Best ETL Testing industry specialists as trainer for our ETL Testing training in Electronic City, Bangalore.
If you are looking for ETL Testing Training in Electronic City eMexo Technologies is the Best ETL Testing Training Institute in Electronic City. Come over to our training institute for a free demo class. Let our trainer give you a demo on ETL Testing and only then you take the decision to enroll into the ETL Testing Training in Electronic City.
ETL Testing Training Institute in Electronic City Features
FAQs
Book Your Free Demo Class For ETL Testing Course in Electronic City
-
DWH: Data Warehousing Concepts
- What is Data Warehouse?
- Need of Data Warehouse
- Introduction to OLTP, ETL and OLAP Systems
- Difference between OLTP and OLAP
- Data Warehouse Architecture
- Data Marts
- ODS [Operational Data Store]
- Dimensional Modelling
- Difference between relation and dimensional modelling
- Star Schema and Snowflake Schema
- What is fact table
- What is Dimension table
- Normalization and Denormalization
-
ETL Testing
- ETL architecture
- What is ETL and importance of ETL testing
- How DWH ETL Testing is different from the Application Testing
- SDLC/STLC in the ETL Projects (ex: V Model, Waterfall model)
- Types of ETL Testing
- SQL Queries for ETL Testing
- Incremental load testing
- Initial Load / Full load testing
- Different ETL tools available in the market
- Power Center Components
- Informatica Concepts and Overview
- Sources
- Targets
- Transformations – Active and Passive Transformations
- Workflow Manager
- Session
- Decision task
- Control Task
- Event wait task
- Timer task
- Indirect Loading
- Constraint based load ordering
- Target Load plan
- Worklet ,Mapplet ,Reusable transformation
- Migration- ML migration and Folder Copy
- Scheduling Workflow
- Parameter and variables
- XML Source, Target and Transformations
- Performance Tuning
- Preparation of Test Cases
- Executing Test case
- Preparing Sample data
- Data validation in Source and target
- Load and performance testing
- Unit testing Procedures
- Error handling procedures