What are the different types of etl 16(1)

What Are The Different Types Of ETL Testing ?

Let us check out this concept called ETL testing and various types of it, in this article.

What is ETL testing?

ETL is ordinarily connected with Data Warehousing ventures however there in actuality any type of bulk data development from a source to an objective can be viewed as ETL. Large organizations regularly have a need to move application data starting with one source then onto the next for data migration or data integration purposes. ETL testing is a data driven testing procedure to approve that the information has been transformed and stacked into the objective not surprisingly.

Every organization classify testing sorts by their own specific manner in view of the testing practices or testing technique assemble @ organizational level. It remains constant for ETL testing too. Here and there, for bigger programs/projects, it changes from client to client. For the most part, beneath are the principle sorts of testing that fall under ETL testing: 1. Transformation or logical testing: To test any logical gaps in the. Here, contingent on the situation, taking after strategies can be utilized: boundary value analysis, comparison testing, equivalence partitioning, error guessing or now and again, graph based testing techniques. It additionally conceals testing for look-up conditions.

2. Reconciliation testing: Some of the time, it is likewise alluded as 'Source to Target count testing'. In this check, matching of number of records is checked. In spite of the fact that this is not the most ideal way, but rather in the event of time crunch, it makes a difference.

3. Constraint testing: Here test engineer, maps data from source to target and distinguish whether the information is mapped or not. Taking after are the key checks: UNIQUE, NULL, NOT NULL, DEFAULT, CHECK, Primary Key Foreign key.

4. Validation testing: It is by and large executed in mission basic or financial project. Here, test engineer, approves every data indicate and coordinate source target data.

5. GUI or navigation testing: To test the GUI or navigation aspects of front end reports.

6. Duplicate check testing: It is done to guarantee that there are no copy values for one of a kind columns. Duplicate data can emerge because of any reason like missing primary key and so forth.

7. Attribute check: To verify if all attributes of source system are there in target table.

8. Historical and incremental data testing: Test to check the data integrity of old and new data with the expansion of new data. It additionally covers the validation of purging policy related situations. If there should be an occurrence of ETL or data warehouse testing, re-testing or relapse testing is likewise a portion of this effort. Their idea/definition continues as before.

Challenges involved: ETL Testing is unique in relation to application testing since it requires a data driven testing approach.

A portion of the difficulties in ETL Testing are: - ETL Testing includes looking at of huge volumes of data ordinarily a large number of records.

- The information that should be tested is in heterogeneous data sources (eg. databases, flat files).

- Data is frequently changed which may require complex SQL queries for comparing the data.

- ETL testing is particularly reliant on the accessibility of test data with various test scenarios.

In spite of the fact that there are slight varieties in the kind of tests that should be executed for every venture, above mentioned are the most widely recognized sorts of tests that should be accomplished for ETL Testing.

On the whole, ETL testing is quite a useful one for the industry at large. This was about ETL testing and its types.