ETL training in Hyderabad

Contact preethitstech

Phone : 9951180008

Contact by email

Contact form


Data warehouse Concepts
• What is Data Warehouse?
• Need to Data warehouse
• Data warehouse characteristics
• Introduction to OLTP and OLAP systems
• Data warehouse Architecture
• Data marts
• Data Modelling
o ER Modelling
o Dimensional Modelling
o Data modelling creation steps

• Difference between Relational and Dimensional modeling
• Normalization and De-Normalization
• Data warehouse schema
o Start Schema
o Snowflake Schema
o Galaxy Schema
o Difference between Start and Snowflake schema
• What is fact table? Type of fact tables?
• What is Dimension table? Types of Dimension Tables?
• Slowly Changing dimension
ETL Concepts
• What is ETL?
• Different ETL tools available in the Market
• Difference between ETL and BI tools
• Data Load in ETL
• Data Cleansing
• Data scrubbing
• Data Merging
• Data Aggregation
• ETL vs ELT
SQL Concepts
• SQL Statements
• SQL Constraints
• SQL SET Operators
• SQL Functions
• SQL Joins
• SQL Clauses
ETL Testing
• ETL Testing vs Database Testing
• ETL Testing vs BI Testing
• ETL Testing categories
• ETL tester Roles and Responsibilities
• ETL Testing Process
• ETL Testing Techniques
• ETL Testing Plan
• ETL Testing Scenarios
• ETL Bug life cycle
• ETL testing Challenges
• ETL Testing Automation tools
BI Testing (OBIEE 11 G)
• RPD Components
• RPD testing
• BI Testing Categories
• BI Testing Scenarios
Informatica 9.6
• Informatica Components
• Sources
• Targets
• Transformations in Informatica
• Workflow Manager and schedule workflows
UNIX Basic Commands for ETL Tester

Posted on : 11/06/2018, #, Edit

It is ok to contact this poster with commercial interests.

« Rjs Academy-NEET Coaching centre in ChennaiSAP SuccessFactors Online Training »