ETL Testing Interview Questions

Generally, basic testing concepts remains same across all domains. So, the basic testing questions will also remain same. The only addition would be some questions on domain. e.g. in case of ETL testing interview questions, it would be some concepts of ETL, how to’s on some specific type of checks / tests in SQL and some set of best practices. Here is the list of some ETL testing interview questions:

Performance Testing vs Load Testing vs Stress Testing - Examples

Performance testing - It is performed to evaluate the performance of components of a particular system in a specific situation. It very wide term. It includes: Load Testing, Stress Testing, capacity testing, volume testing, endurance testing, spike testing, scalability testing and reliability testing etc. This type of testing generally does not give pass or fail. It is basically done to set the benchmark & standard of the application against Concurrency / Throughput, Server response time, Latency, Render response time etc. In other words, you can say it is technical & formal evaluation for responsiveness, speed, scalability and stability characteristics.

SDLC vs STLC–Differences & Similarities Revisited

Few days back, I was taking some interviews. I surprised to see some candidates were not able to explain simple concepts like SDLC & STLC. Everybody, was giving me very standards answers. SDLC - a systematic approach to develop a software and STLC - process of testing a software in a systematic and planned way. No one explains me logical Differences & Similarities between these two.

How to prioritize bugs numerically - An effective way of prioritization of bugs

You must have seen developers & testers fighting with each others on priority of bugs. Testers log the bug as high priority or critical and sometimes, developers surprised to see the priority. Most of the times, both developer & tester will not agree on the priority set by each other. I've seen sometimes, even product manager / project manager / business analyst are not able to prioritize the defects or bugs EFFECTIVELY. Even in many process oriented organizations, it becomes a challenge.

Types of ETL testing–What is covered in ETL testing

Each organization categorize testing types by their own way based on the testing practice or testing strategy build @ organization level. It holds true for ETL testing also. Sometimes, for larger projects / programs, it vary from client to client. Generally, below are the main types of testing that are covered under ETL testing:

Points to take care while doing testing estimation

Important points to take care while doing test effort estimation – These general tips will help us to estimate more accurately:

Model Based Testing – MBT

Model-based testing or MBT is a general term that signifies an approach that bases common testing tasks such as test case generation and test result evaluation on a model of the application under test.

Objectives of Software Testing

Below are not the only objectives of Software Testing:
- Software Testing is designed to establish that the software is working satisfactorily as per the requirements.
- Software Testing is a process designed to prove that the program is error free.
- Software The job of testing is to certify that the software does its job correctly and can be used in production.

Configuring LoadRunner Monitors on the Controller

To use the following monitors, you must first install or configure monitoring components on the server machine:
COM+, Citrix, DB2, IBM WebSphere MQ, iPlanet (NAS), J2EE & .NET Diagnostics, Network Delay, Oracle, PeopleSoft (Tuxedo), SAPGUI, SAP Portal, SAP CCMS, Siebel Server Manager, Siebel Web Server, SiteScope, Tuxedo, UNIX, WebLogic (JMX), WebSphere Application Server.

Creating a Vuser Script with Visual C

Vuser scripts can be created using Visual C 6.0 or higher. To create a Vuser script with Visual C, please follow the below steps:

Run QTP framework in quality center

If you have made an excel driven framework in QTP which runs on the local machine and now want to run it from quality center as well without making major changes in the script, then this post is for you.

Designing Test Object Configuration XML File in QTP

In this file, you define any custom test object classes that you want QTP to use to represent your custom controls in tests and components. Define a test object class for each custom control that cannot be adequately represented by an existing Delphi test object class.

Enabling and Disabling Breakpoints in QTP

You can instruct QTP to ignore an existing breakpoint during a debug session by temporarily disabling the breakpoint. Then, when you run your component or function library, QTP runs the step containing the breakpoint, instead of stopping at it. When you enable the breakpoint again, QTP pauses there during the next run. This is particularly useful if your component or function library contains many steps, and you want to debug a specific part of it.

Why Components Fail at Run-time in QTP

Components fail when QTP encounters a step it cannot perform or the results of a step indicate failure. In many cases this is due to the application being tested not functioning properly. QTP then provides you with test results that assist you in understanding how to fix your application.

How to save Test Scripts to a Quality Center Project

When QTP is connected to a Quality Center project, you can create new tests in QTP and save them directly to your project. To save a test, you give it a descriptive name and associate it with the relevant subject in the test plan tree. This helps you to keep track of the tests created for each subject and to quickly view the progress of test planning and creation.

How to Access Internal Properties and Methods of Run-Time .NET Windows Forms Objects

Object property can be used to retrieve internal properties and activate internal methods of any .NET Windows Forms object in your application.
 
For example, you can set the focus to a particular button and change its caption using statements similar to the following:

Using Siebel Add-in in QTP

Here are some important points to take care while using Siebel Add-in with QTP:

• QTP supports testing on both standard-interactivity and high interactivity Siebel applications.
• Standard-interactivity applications download data as it becomes necessary. This interface is designed for users accessing the application from outside the corporate network.
• High-interactivity applications download the majority of the required data at one time, requiring fewer navigations. This interface is designed for heavy use, for example, by call centers.

How to use formulas in the Data Table

You can use Microsoft Excel formulas in your Data Table of QTP. This enables you to create contextually relevant data during the test run session in QTP. You can also use formulas as part of a checkpoint to check that objects created on-the-fly (dynamically generated) or other variable objects in your Web page or application have the values you expect for a given context.

How to use Formulas in Checkpoints

You can use a formula in a checkpoint to confirm that an object created on-the-fly or another variable object in your Web page or application contains the value it should for a given context. For example, suppose a shopping cart Web site displays a price total. You can create a text checkpoint on the displayed total value and use a Data Table formula to check whether the site properly computes the total, based on the individual prices of the products selected for purchase in each iteration.

Defining Regular Expressions

In QTP, you can use regular expressions only for values of type string. In QTP, you can define a regular expression for a constant value, a Data Table parameter value, an Environment parameter value, or a property value in a programmatic description.

You can define a regular expression by entering the regular expression syntax for the string in the Value box in the Constant Value Options dialog box or the Parameter Options dialog box. You instruct QTP to treat the value as a regular expression by selecting the Regular Expression check box.