Lavender Technology Interview Questions and Answers

SCD Type 2 implementation involves tracking historical changes in data by creating new records for each change.

• Identify the columns that need to be tracked for changes

• Add effective start and end dates to track the validity of each record

• Insert new records for changes and update end dates for previous records

• Maintain a surrogate key to uniquely identify each version of the record

I can join the team within 2 weeks.

• I can start within 2 weeks of receiving the offer.

• I need to give notice to my current employer.

• I may need to relocate, which could affect my start date.

Challenges in automation include dynamic UI elements, data synchronization, and maintenance of test scripts.

• Dynamic UI elements can be challenging to automate as they may change frequently.

• Data synchronization between different systems can be difficult to achieve in automation.

• Maintenance of test scripts can be time-consuming, especially when application changes frequently.

To read data and assert with db value in API automation, use API response to extract data and compare with database query result.

• Extract data from API response using JSON parsing libraries like Gson or Jackson

• Execute database query to retrieve expected value

• Compare the extracted data with the database value using assertion libraries like TestNG or JUnit

Correlation is the process of extracting dynamic values from server responses and passing them to subsequent requests. Parameterization is the process of replacing hard-coded values in scripts with variables.

• Correlation involves identifying and capturing dynamic values like session IDs or tokens from server responses.

• Parameterization involves replacing hard-coded values in scripts with variables to make them reusable a...read more

Load testing is to test the system under normal and peak load conditions, stress testing is to test the system beyond its limits, and all testing is a combination of both.

• Load testing checks the system's ability to handle expected load levels, ensuring performance under normal conditions.

• Stress testing pushes the system beyond its limits to identify breaking points and measure performance degradation.

• All testing combin...read more

PTLC stands for Performance Testing Life Cycle, which is a set of activities involved in the performance testing process.

• PTLC involves planning, preparation, execution, analysis, and reporting of performance tests.

• It includes defining performance goals, creating test scenarios, setting up test environments, running tests, analyzing results, and making recommendations.

• Example: In PTLC, performance engineers work closely...read more

Issues faced in Loadrunner scripting, execution, and reports

• Scripting: faced issues with correlation, parameterization, and dynamic data handling

• Execution: encountered problems with test environment setup, resource constraints, and test data management

• Reports: struggled with result analysis, performance bottlenecks identification, and report customization

LG calculation and workload modelling process involves determining the number of Load Generators required and creating a realistic simulation of user behavior.

• Calculate the number of Load Generators needed based on expected user load and performance goals.

• Create workload models by analyzing user behavior patterns, transaction volumes, and system usage.

• Consider factors like peak load times, user distribution, and transa...read more

NFR scenarios refer to non-functional requirements that define the quality attributes of a system.

• NFR scenarios focus on aspects like performance, scalability, reliability, and security.

• Examples include load testing to assess system performance under expected load, stress testing to evaluate system behavior under extreme conditions, and security testing to identify vulnerabilities.

• NFR scenarios help ensure that the sys...read more