Skip to main content

Posts

Beginners Guide to ETL Testing

Beginners Guide to ETL Testing What is ETL Testing? These days more and more systems are moving from legacy to new technology, and ETL is one of the common methods used to help this transformation. It can consolidate the scattered data for any organization while working with different data format and sources. In this article, we will talk about the basic concept of ETL and how it has been tested. Why we need ETL? ETL stands for extract, transform, and load. In many organizations, the setup of the IT deferments happened long time back. So, in most of the cases the way each deferment handles the data is different. For example, in a retail organization you many have different departments such as sales, marketing, logistics, etc. Each of them is handling the customer information but way they store that data could be quite different. The sales deferment store it by name whereas marketing deferment has it in the number format. ETL can take all this data from different sou...

What are some of the most common challenges faced by software QA team?

Here we go with the top challenges: 1) Testing the complete application: Is it possible? I think impossible. There are millions of test combinations. It’s not possible to test each and every combination both in manual as well as in automation testing. If you try all these combinations you will never ship the product 2) Misunderstanding of company processes: Some times you just don’t pay proper attention what the company-defined processes are and these are for what purposes. There are some myths in testers that they should only go with company processes even these processes are not applicable for their current testing scenario. This results in incomplete and inappropriate application testing. 3) Relationship with developers: Big challenge. Requires very skilled tester to handle this relation positively and even by completing the work in testers way. There are simply hundreds of excuses developers or testers can make when they are not agree with some points. For this tester...

Steps to configure Selenium WebDriver environment

Steps to Download Java Navigate to https://www.java.com/ Click on Free Java Downloads button. Click on the Agree and Start Free Down Button in the page as shown below. Steps to installing Java. After Java is installed, the next step is to set the environment variables. Steps to setup Environment Variables: Navigate to the path where Java is installed and go to the path until as below C:\Program Files\Java\jdk1.8.0_65\bin Copy the above path and Right-click on MyComputer -> Properties. Click on Advanced System Settings and click on “Environment Variables”. In the System Variables, paste the above-copied path and paste in the Path field. Click OK and Click OK Note: To verify if Path is set correctly, Go to Command Prompt by typing cmd in the Run and then in the Command Prompt type javac and should return list available as below: Download Selenium WebDriver based on language in which you want to use for Automation. Say you can use Java, C#, Ruby, Python, etc. The m...

How to Setup and Configure JMeter in Windows

JMeter is one of most popular performance testing tool and since it is open-source, therefore it is often a start point for beginners in performance testing. In this blog, I will share a step-by-step guide that can be used to install JMeter in Windows environment. There will also be some configuration and script designing tips which you will find useful while working on real-time JMeter projects. 1- Setup and Verify Java Apache JMeter is purely a Java based tool; therefore first of all we need to make sure that Java is properly installed and configured in our system. If you are already using any java based applications, then Java might already be installed on your system. To check if Java is already installed open command prompt and run command java -version. If Java is successfully installed and configured then the command will return valid java version number (java version “x.x.x.x”) as shown in image below: If Java is not installed or configured, then you may get a message like ...