ETL TESTING

What is ETL? 

ETL stands for ‘extraction, transforming, and loading.’ This is the process by which data is taken from various sources, such as database servers, and transformed to fit with your business’s operational needs. This step involves assessing the quality levels of the data. Once that information has been assessed, it is then loaded into your company’s database, referred to as a warehouse.   The process of ETL allows a business to collect important data, change it to fit their goals and models, and then store it for use. In a world of digital enterprise, it is a critical part of running an effective and efficient business.

The ETL Testing Process

Because data is so important to a successful business, poor performance or inaccurate procedure can cost time and money. Therefore, ETL testing is designed to ensure that the person in charge of the ETL process has the best understanding of it possible. By asking questions of new applicants or current employees ETL testing will ensure the most efficient and up to date abilities of the person and the process.

ETL testing will also help to ensure the best work possible is being done and will confirm the correctness of data being transformed. This is measured against the rules and requirements of the company itself. It also verifies that the transformed data can loaded without any loss of information, is used to validate the accuracy of reports, ensures that the process meets performance requirements, and finally, is used to evaluate the entire reporting structure. If you plan on stepping into a role that will require an ETL interview check, out Udemy’s course on data extraction tips and tricks, which can help you learn great methods to help you prepare for your burgeoning career.

Key Challenges

• How to validate millions of records across heterogenious data sources such as flat files, databases (eg. Oracle, DB2, SQL Server), Hadoop?
• How to automate ETL Testing without writing custom code?
• How to automate regression testing of ETL?
• How to test Incremental ETL?
• How to validate 100% of the data and not just sample datasets?
• How to increase my ETL test coverage?
• How to reduce the ETL and data testing costs?
• How to compare report output with the data in the source system (end-to-end testing)?
• How to test that the data in flat files got loaded into database properly? How to validate that the incoming files are conforming to the data quality requirements?

DEMO 

Try Our Free Demo Today! call +91-9494646355

ON JOB SUPPORT:

We provide technical assistance for six months. So, if you have any query even while working you can always get back to us.

Manual testing

Manual testing is the process through which software developers run tests manually, comparing program expectations and actual outcomes in order to find software defects.

These manual tests are no more than the tester using the program as an end user would, and then determining whether or not the program acts appropriately. Manual testing is a good fit for smaller projects as well as companies without significant financial resources.

Pros of Manual Testing

1. Short-term cost is lower

Buying software automation tools is expensive. With manual testing, you won’t have to put the same up-front costs into the software.

2. More likely to find real user issues

Automated tests are just that – automatic. They’re robotic and don’t necessarily act as a real user would. Manual testing, on the other hand, allows the developing program to be used as it would be upon launch. Any bugs that may pop up when a user handles the program in a certain way are more likely to be caught with manual testing.

3. Manual testing is flexible

When one of those brilliant thoughts comes to you, something that could change the course of the project, you want to be able to work on it immediately. With automated testing this is difficult. You have to set up test cases, program it into the automated tool, and then run the tests. With manual testing, you can just quickly test and see the results. Automatic tests take more time to set up, which doesn’t allow you to test ideas quickly and easily.

Cons of Manual Testing:

1. Certain tasks are difficult to do manually

There are certain actions that are difficult to do manually. For example? Low level interface regression testing. This kind of testing is extremely difficult to perform manually, and, as a result, is prone to mistakes and oversight when done by hand. Automated testing, once set up, is much better equipped to find errors for this kind of testing.

2. Not stimulating

Manual testing can be repetitive and boring – no one wants to keep filling out the same forms time after time. As a result, many testers have a hard time staying engaged in this process, and errors are more likely to occur.

3. Can’t reuse manual tests

With automated tests, if you add anything to the program, you can rerun all of the required tests instantly – the tests are already set up. This isn’t the case with manual testing. If there is any change to the software, you have to run the tests again by hand. This is valuable time lost.

DEMO 

Try Our Free Demo Today! call +91-9494646355

ON JOB SUPPORT:

We provide technical assistance for six months. So, if you have any query even while working you can always get back to us.

HP QTP

Introduction to QTP

HP QTP is an automated functional testing tool that helps testers to execute automated

Tests in order to identify any errors,

Defects or gaps in contrary to the expected results of the application under test.

It was designed by Mercury Interactive and later on acquired by HP

Versions

• 5.5: First release: Released in 2001
• 6.0: Released in 2002
• 6.5: Released in 2003
• 7.0: Never released
• 8.0: Released in 2004
• 8.2: Released in 2005
• 9.0: Released in 2007
• 9.1: Released in 2007
• 9.2: Released in 2007
• 9.5: Released in 2008
• 10.0: Released in 2009
• 11.0: Released in 2010
• 11.5: Released in 2012 [renamed Unified Functional Testing]
• 11.52: Released in June 2013
• 11.53: Released in November 2013
• 12.0: Released March 2014
• 12.01: Released July 2014

License models

HP Unified Functional Testing is available through single-seat licenses, as well as floating or concurrent licenses. A trial version of the software is also available. 

Comparison Matrix

QTP Advantages:

• Developing automated tests using VBScript doesn't require a highly skilled coder and relatively easy when compared other object oriented programming languages.
• Easy to use, ease of navigation, results validation and Report generation.
• Readily Integrated with Test Management Tool (Hp-Quality Center) which enables easy scheduling and Monitoring.
• Can also be used for Mobile Application Testing.
• Since it is a Hp product, the full support is provided by HP and by its forums for addressing technical issues.

QTP Disadvantages:

• Unlike Selenium, QTP works in Windows operating system only.
• Not all versions of Browsers are supported and the testers need to wait for the patch to be released for each one of the major versions.
• Having said that it is a commercial tool, the licensing cost is very high.
• Even though scripting time is less, the execution time is relatively higher as it puts load on CPU & RAM.

DEMO 

Try Our Free Demo Today! call +91-9494646355

On Job Support:

We provide technical assistance for six months. So, if you have any query even while working you can always get back to us.