ETL Testing

[Matrix_2006]

Can anyone tell me What is ETL testing? What is the procedure for conducting ETL Test

[mfsi-satyakamm]

ETL(Extraction, Transforming & Loading)
Its more of a like playing data of the database.
In Extraction, the data is being extracted from the database.
In Transformation, the data is transformed by following certain rules.
In loading, the data is being loaded back to the database.
In short here we test - can we properly extract data, then manipulate/change/transform the data following certain rules & lastly load the data back to the data base or not.

[mfsi_nilanjan]

ETL stands for Extract Transform Load--means extract the data from source tables and feed those data to the target table in the desired format maintaining all the rules.Informatica, Control-M are most known ETL tools.

ETL Testing implies - Testing this entire process using a tool or at table level with the help of test cases and Rules Mapping document.

[mfsi_sudhansup]

Hi All,
ETL stands Extract, Transform and Load. It is an ETL process to extract data, mostly from different types of systems, transform it into a structure that's more appropriate for reporting and analysis and finally load it into the database

In this step we extract data from different internal and external sources, structured and/or unstructured. ETL - Transform the data

Once the data is available , it is all on one platform and one database. So we can easily join and union tables, filter and sort the data using specific attributes, pivot to another structure and make business calculations. In this step of the ETL process, we can check on data quality and cleans the data if necessary.

Finally, data is loaded into a data warehouse or data base.

Thanks
Sudhansu