What is ETL Testing & Types of ETL Testing

1. What is ETL Testing & Types of ETL Testing What is ETL Testing? 1) As mentioned previously ETL stands for Extraction, Transformation, and Loading is taken into account to be the three prime database functions. ➢Extraction: Reading data from the database. ➢Transformation: Converting the extracted data into the specified form to store into another database. ➢Loading: Writing the info into the target database. 2) ETL is employed to transfer or migrate the info from one database to a different , to organize data marts or data warehouses. Following diagram elaborates the ETL Process in a precise way: ETL Testing Process ETL Testing Process is analogous to other testing processes and includes some stages. They are: ➢Identifying business requirements ➢Test Planning ➢Designing test cases and test data

2. ➢Test execution and bug reporting ➢Summarizing reports ➢Test closure Types of ETL Testing ETL Testing is often classified into the subsequent categories consistent with the testing process that's been followed. 1) Production Validation Testing: It is also called as Table corresponding or product settlement. it's performed on data before or while being moved into the assembly system within the correct order. 2) Source to focus on Testing: This type of ETL Testing is performed to validate the info values after data transformation. 3) Application Upgrade: It is wont to check whether the info is extracted from an older application or new application or repository. 4) Data Transformation Testing: Multiple SQL queries are required to be run each and each row to verify data transformation standards. 5) Data Completeness Testing: This type of testing is performed to verify if the expected data is loaded at the acceptable destination as per the predefined standards. For more information About this courses Please go through this link ETL Testing Training Contact Information: USA: +1 7327039066 INDIA: +91 8885448788, 9550102466 Email: info@onlineitguru.com