Author: Sharath Chandran

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

Posted on

Apache JMeter features and uses:

Apache JMeter features and uses:

Apache JMeter is a performance tool developed in Java.

Supports both load and performance tests,
Supports different applications/server/protocol types,
Web – HTTP, HTTPS  –  i.e application made in Java, NodeJS, PHP, ASP.NET etc
SOAP / REST Webservices, FTP , LDAP & TCP etc.

Additionally it supports Database via JDBC, Message-oriented middleware  via JMS, Mail – SMTP(S), POP3(S) and IMAP(S), also Native commands or shell scripts & Java Objects

Posted on

LoadRunner version 12.53

LoadRunner version 12.53

I am yet to try the trial version of LoadRunner 12.53, However I read the following are some of the features shall be available for users

Git integration in VuGen
REST step builder editor in VuGen
64-bit replay support in various Java protocols and C Vuser protocol
New PCoIP remote access protocol
Enhanced SAPUI5 recording in TruClient
HTTP Video Streaming (HTML5, HLS) support
JSON manipulation APIs
Web – HTTP/HTML and Mobile Application – HTTP/HTML protocol unification
Linux load generator improvements
Enhancements to Java-based protocols etc are main features that I would like to try..

Posted on

Java vs JavaScript

Java vs JavaScript

Java is an OOP programming language and written in Integrated Development Environment(IDE) like ECLIPSE however Java Script is an OOP scripting language and does not require any IDE. Java is class based but Java script is not. Java code needs compiling on IDE but JavaScript code does not. Java script is extensively used in World Wide Web apart from HTML and CSS. Java creates applications that run in a virtual machine or browser while JavaScript code is run on a browser only. JavaScript uses much smaller, easier and simpler set of commands than Java. Java is more rigid and complex.

 

 

Posted on

Java OOP concepts

Java OOP concepts

Object-Oriented Programming is a methodology to design a program using classes and objects. Java uses OOP.
Object – an entity that has state and behavior is known as an object
classes – Collection of objects is called class.

Polymorphism – When one task is performed by different ways or ability of an object to take on many forms.
Abstraction – Hiding internal details and showing functionality is known as abstraction.
Encapsulation – is a process of binding or wrapping the data with the code.
Inheritance – When one object acquires all the properties and behaviors of parent object. It helps on code re-usability.