Category: Web server/application server/Web services

Posted on

vlookup function in excel for column value matching

vlookup function in excel for column value matching

Row# 2 and column A showed the match results for Column B Row# 1 as you can see value 1 is matched against Column C records.

Row# 4 and column A showed no match results for Column B Row# 4 as you can see value 5A is not matched against Column C records.

so the code sample you need to use for the record range of 11 rows, as below

=IF(ISNA(VLOOKUP(B2, $C$2:$C$11, 2, FALSE )), “MISSING”, “MATCHED!”)

=IF(ISNA(VLOOKUP(B3, $C$2:$C$11, 2, FALSE )), “MISSING”, “MATCHED!”)

etc

VLOOKUP

 

 

Posted on

Performance testing best practices and activities.

Performance testing best practices and activities.

  1. As first step, Performance Engineer needs to learn the requirements, performance expectations & system architecture.

Note: To learn the performance requirements & expectations, SME (Subject matter expert ) or production user can help. This information will help to define performance goals and SLAs

  1. Then develop best matching performance test scenarios, approach, define goals (SLAs) & sign off test plan.

Note 1: To identify the right performance test scenarios, SME can give some feedback on about the current performance issues in production / live application that he/she is facing.

Note 2:  You can refer another blog of mine on different types of performance scenarios – click link load testing vs performance testing vs stress testing

  1. Now Performance Engineer can developer V– USER scripts and execute the scripts in Controller to generate performance analysis results

Note 1: Apart from delivering performance analysis results, Performance Engineer  can coordinate with other team to monitor real time performance on Database server, Application server and also make sure load balancing is working fine while stress testing.

Some of the e.g. when performance testing is needed

  1. for Database upgrade,
  2. Application upgrade,
  3. Or if user complains that application performance is bad – like page response is not meeting his/her expectations.
Posted on

Robot framework and Selenium2Library

Robot framework and Selenium2Library

Selenium2Library is library created for web testing. Robot framework utilizes this framework

Robot framework is mainly used for acceptance testing and it supports different browsers like IE, Chrome, Firefox etc.

Robot framework can be hosted in Github and script execution can be managed using Jenkins. I will be writing a detailed step by step documentation on Robot framework web testing  implementation.

Posted on

Jenkins vs GitHub

Jenkins vs GitHub

Jenkins allow continuous integration which helps developers or Automation testers to integrate code into a shared repository. It acts an open source automation server for test automation projects. Jenkins offers lots of plugins to integrate various tools.

GitHub is a web-based hosting service supporting distributed version control of codes. for e.g. if someone already registered a domain for a website in GoDaddy or similar domain services site but looking for a free hosting service, Github can be used to store code. Go daddy and Github should be linked to make this happen.

Posted on

What is Structured Query Language(SQL)

What is Structured Query Language(SQL)

SQL is Structured Query Language. e.g.MySQL and Microsoft SQL Server both are relational database management systems)
Data Definition L (DDL) – Create, Alter, Drop
Data Manipulation Language (DML)- Select , Insert, Update, Delete
Data Control Language(DCL) – Grant, Revoke