Entries Tagged 'Database Testing' ↓

How to Perform ETL Testing Using Informatica PowerCenter Tool

It is a known fact that ETL testing is one of the crucial aspects of any Business Intelligence (BI) based application. In order to get the quality assurance and acceptance to go live in business, the BI application should be tested well beforehand.

The primary objective of ETL testing is to ensure that the Extract, Transform & Load functionality is working as per the business requirements and in sync with the performance standards.  Continue reading →

How to Perform Backend Testing

What is Backend Testing and How to perform it?

Software Applications are complex; there is more than what meets the eye.

Most system testing efforts go through GUI. This is because testing validates if the software is ‘fit for use’ by the end-user or not. End-users use GUI and so do we; that is why it is really important that software fares well in this area.

But, software has a lot of other elements too that aren’t directly visible or available to the user for direct interaction. It does not make these elements any less important and they must too undergo thorough testing.  Continue reading →

A Simple Approach for XML to Database Testing

This article will help understand the XML to Database testing concept, which is a challenging testing type.

The data comparison is a critical task to accomplish with quality. Any flaw will result one or many failures in an application.

XML is an electronic communication message format that contains data and Database is a physical storage with tables/columns containing data. Continue reading →

An Excellent Way of Data Testing Using XML Technologies (White Paper)

In the SDLC, if the application uses waterfall model, testing activities are planned at the end. This poses a risk of rework with respect to requirements, design, code and test cases if QA team identifies defects. It is better to avoid waiting till the end to identify the defects in an application.

Tests that are not based on functional execution of the application can find defects without mandating the release of all the components into the test environment. This can be accomplished by data testing. Continue reading →

How to Test and Validate Your Database Backup and Recovery?

In this article we shall discuss about verifying and testing your database backups. We will be explaining concepts such as what, why and how about Database backups and methods to test the backup.

We will take Oracle database as a case study for this tutorial.

Case Study: Testing Oracle Database Backups: Continue reading →