Quality is delighting customers
What is ETL testing
What is ETL testing. Please some body give the full explanation or provide a good material on it.
Replies to This Discussion
-
Permalink Reply by bathwalshaili on
-
Hi Wayne,
It would be great if you can send those papers to me as well.
My e-mail id is sbathwal@infocepts.com.
Regards,
Shaili
-
Permalink Reply by Rohit Agrawal on
-
Hi Tarique ,
ETL testing is the heart of Data warehouse testing. It includes validations of data Extracted from source, transformations (functions) applied to data and lastly the target data warehouse(loading).Source could be a relational database(Oracle or SQL Server) or an ERP system or a non relational data sources like Mainframes and Unix.
Unit and integration test scripts are created to validate that the ETL is performed accurately from different sources.
The Referential Integrity checks are done to ensure that relationships between tables is not ambiguous. Surrogate testing is required to check and prevent any orphan records in child tables.
The performance of ETL should be tested with data that resembles closely to Production wrt quality and quantity.
Performance and stress tests are complementary in assessing the efficiency of ETL procedures. Performance tests evaluate the behavior of ETL with reference to a routine workload, i.e., when a domain-typical amount of data has to be extracted and loaded; in particular, they check that the processing time be compatible with the time frames expected for data-staging processes. On the other hand, stress tests simulate an extraordinary workload due to a significantly larger amount of data.
The recovery test of ETL checks for robustness by simulating faults in one or more components and evaluating the system response. For example, you can cut of the power supply while an ETL process is in progress or you can set a database online while an OLAP (Online Analytical Processing) session is in progress to check for restore policies' effectiveness.
-
Permalink Reply by testing whiz on
-
ETL stands for Extract Transformation and Load.It is also known as data warehouse testing.It verifies that data is transformed correctly according to various business rules.But this testing has few drawbacks.One such is data loss during ETL process.
-
-
Hi Tarique Ahamed,
Can you plz share the ETL Testing material ,it would be of great help
ibalaraj3763@gmail.com
Thanks
-
Permalink Reply by Mithun on
-
Hi Wayne,
It would be great if you can send those papers to me as well.
My e-mail id is italimith@gmail.com
Regards,
Mithun
-
-
plz any one having ETL testing materials pzl send it to my below mail id
italimith@gmail.com
-
-
Hi,
For ETL Testing Interview Questions you visit:
http://www.gcreddy.com/2013/02/etl-testing-interview-questions.html
-
-
Hi All,
If anybody have doubts in ETL testing, let me know, will give my level best answers.
Thanks,
Subbu
-
Permalink Reply by Nikhil Pathak on
-
Hello Subbu,
I don't even know the ABC of ETL, can you please explain in detail about ETl. This will be very nice help for all the newbies.
Thanks,
Nikhil
-
-
Hello Nikhil,
For basics as What is ETL? How to perform ETL testing .....such information u can get it from previous posts in this discussion, it will give all basic info so pls go throgh it and come up with some questions,so that i can assist you.
Thanks,
Subbu
-
Permalink Reply by Klakston A on
-
Hi Subbu,
I have listed my questions.Could you please explain for below given my questions.
1. Could you please explain about Event Task Validation,Email Task Validation, Parameter file Validation. 2. how to perform regression Testing in ETL. Regression nothing but we need any side effect is there or not.if any changes in any module. How we are applying Regression in ETL.
Advertisement
Advertisement
Advertisement
Advertisement
© 2021 Created by Quality Testing.
Powered by
