1 / 5

Etl testing training from INDIA|USA|UK.

ETL systems are used by businesses to integrate data from multiple sources. ETL stands for Extract Transformation and Load, It collect the data from various sources such as data from Heterogeneous System (DB), Transform the data into Data warehouse (Target).<br> ETL testing is quite different from conventional testing. There are many challenges we faced while performing data warehouse testing.

sudeeps
Download Presentation

Etl testing training from INDIA|USA|UK.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SUDEEP TECHNOLOGIES 74-15-4, 3rd floor, Swarna Plaza, oppst.Auto Nagar terminal, Krishna Nagar, Vijayawada-520007. Ph: 040-65240555, 9700042555, www.sudeeptechnologies.com ETL AND REPORT TESTING COURSE CONTENT We give ETL testing training online from Hyderabad, India from the best renowned Trainers of India. Our trainers are professionals with real time experience. Our ETL Testing training given online is an added advantage for you, as you can learn many Things with practical approach. We deliver advanced training by real time experience. What is ETL Data is important for businesses to make the critical business decisions. ETL Testing plays a significant role validating and ensuring that the business Information is exact, consistent and reliable. Also, it minimizes hazard of data Loss in production. ETL testing is the heart of Data warehouse testing. ETL systems are used by Businesses to integrate data from multiple sources. ETL stands for Extract Transformation and Load, It collect the data from various sources such as data from Heterogeneous System (DB), Transform the data into Data warehouse (Target)

  2. ETL Testing Challenges: ETL testing is quite different from conventional testing. There are many challenges we faced while performing data warehouse testing. Here is the list of few ETL testing challenges Incompatible and duplicate data. Loss of data during ETL process. Unavailability of inclusive test bed. Testers have no privileges to execute ETL jobs by their own. Volume and complexity of data is very huge. Fault in business process and procedures.  Trouble acquiring and building test data. Missing business flow information. How ETL Testing works: The solution is to use a Data warehouse to store information from different sources in a Uniform structure using ETL. ETL can transform dissimilar data sets into a unified structure. Later use BI tools to derive meaningful insights and reports from this data. (ex The sales department have stored it by customer’s name, while marketing Department by customer id. Here Datawarehouse to store information in different sources)

  3. Different phases of ETL testing process 1. Business and Requirement understanding 2. Test Planning and Estimation 3. Designing Test Cases and Preparing Test Data 4. Test Execution with Bug reporting and closure 5. Summary report and Result analysis 6. Test Closure What is covered in ETL testing (Types of ETL Testing) Each organization categorize testing types are different, The ETL testing strategy build according to their organization level. So every organization maintain their own ETL testing types. Sometimes, for larger projects / programs, it vary from client to client. Generally, the main types of testing that are covered under ETL testing are Reconciliation testing Constraint testing Validation testing (source to target data) Testing for duplicate check Testing for attribute check Logical or transformation testing Incremental and historical data testing GUI / navigation testing

  4. OUR ETL and report testing COURSE CONTENT: Data warehousing concepts: DBMS and RDBMS What is Data Warehousing 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 Modeling 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 analyzing sessions/workflows in Informatica

  5. 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 Integration testing Module testing System testing Uat Practice sessions on ETL Testing SUDEEP TECHNOLOGIES 74-15-4, 3rd floor, Swarna Plaza, oppst.Auto Nagar terminal, Krishna Nagar, Vijayawada-520007. Ph: 040-65240555, 9700042555, www.sudeeptechnologies.com

More Related