Answer:- • When a tester finds a bug, the bug is assigned NEW or OPEN with status. • The bug is either assigned to Development Project Managers or is given to Bug Bounty Program. They will check whether it is a valid defect. If not valid, the bug is rejected, and its new status is REJECTED. • Now, the tester checks whether a similar defect was raised earlier. If yes, the defect is assigned a status ‘DUPLICATE’ • Once the bug is fixed, the defect is assigned a status ‘FIXED’ • Next, the tester will re-test the code. In case, the test case passes, the defect is CLOSED • If the test case fails again, the bug is RE-OPENED and assigned to the developer.

Answer:- JMeter comes with a synchronizing timer which can handle the requests of multiple threads. It is able to get the required number of threads and release them at once to cause a spike.

Answer:- Silk Test is a tool developed for performing regression and functionality testing of the application. Silk Test is a tool, used when we are testing the applications based on Windows, Java, Web or traditional client/server. Silk Test helps in preparing the test plan and managing of those test plans to provide direct access to the database and field validation.

Answer:- The Requirement Traceability Matrix (RTM) is a bi-directional matrix that captures the details of requirements and their traceability. Created at the initial steps of a project, RTM tracks the requirement by analyzing the deliverables and business requirements

Answer:- Software applications are made up of several elementary processes. There are two types of elementary processes: • Dynamic elementary Process: The dynamic elementary involves the process of moving data from one location to another. The location can be either within the application or outside it. • Static elementary Process: It involves maintaining the data of the application.

Answer:- Software applications are made up of several elementary processes. There are two types of elementary processes: • Dynamic elementary Process: The dynamic elementary involves the process of moving data from one location to another. The location can be either within the application or outside it. • Static elementary Process: It involves maintaining the data of the application.

Answer:- QA plays a crucial role in project development. Some of them are outlined here- • Reduce the defects and errors • Preventing defects from occurring • Maintain the system quality as per the specifications • Test the projects on failure parameters to check its fault tolerance

Answer:- • LoadRunner(HP): This testing tool contains a wide array of application environments, platforms, and databases. It is typically suitable for web applications and others. • QA load(Compuware): This tool is used for load testing of web, database, and char-based systems. • WebLoad(RadView): It is used to compare running tests with test metrics. • Rational Performance Tester (IBM): It allows finding out the presence and cause of bottlenecks. • Silk Performer (Borland): This testing tool lets you predict the behavior of e-business environment. • Explain the concepts of Test Fusion Report of QTP. • Test Fusion report displays different aspects of the test run, soon after the tester runs a test. The Test Fusion report is used to display all the aspects of test run, it specifies where the application failures occurred, the test data used, and the detailed explanation of every checkpoint stating pass or failure and the application screenshots of every step by highlighting the discrepancies. • Test Fusion Report is a compilation of the entire testing process. It includes an overview of where the failures occurred, the test data that was used in testing, screenshots to support inconsistencies and a detailed view of checkpoints.

Answer:- • ETL Testing • Writing scripts for automating the testing process • No need for additional technical knowledge other than the understanding of the software • Fast and systematic, and provides top results • Manual testing • A method of observing and testing • Needs technical knowledge of SQL and Shell scripting • Needs time and effort, and is prone to errors

Answer:- ETL refers to the Extracting, Transforming, and Loading of data from any outside system to the required place. These are the basic three steps in the data integration process. ‘Extracting’ means locating data and removing it from the source file; ‘Transforming’ is the process of transporting it to the required target file, and in the ‘Loading’ stage the file is loaded to the target system in the specified format.

Answer:- • To keep an eye on data that is being transferred from one system to another • To keep track of the efficiency and speed of the process • To achieve fast and the best results

Answer:- An ETL Tester: • Requires in-depth knowledge of the ETL tools and processes • Needs to write SQL queries for various scenarios during the testing phase • Should be able to carry out different types of tests and keep a check on the other functionalities of the process • Needs to carry out quality checks on a regular basis

Answer:- • Cognos Decision Stream • Oracle Warehouse Builder • Business Objects XI • SAS Business Warehouse • SAS Enterprise ETL Server

Answer:- ETL Testing Process: Although there are many ETL tools, there is a simple testing process commonly used in ETL Testing. It is as important as the implementation of the ETL tool into your business. Having a well-defined ETL Testing strategy can make the testing process much easier. Hence, this process needs to be completed before you start the data integration with the selected ETL tool. In this ETL Testing process, a group of experts comprising the programming and developing team will start writing SQL statements. The development team may customize them according to the requirements. ETL Testing process has the following stages: • Analyzing requirements: Understanding the business structure and their particular requirements. • Validation and test estimation: Estimating the time and expertise required to carry on with the procedure. • Test planning and designing the testing environment: Based on the inputs from the estimation, an ETL environment is planned and worked out. • Test data preparation and execution: Data for the test is prepared and executed as per the requirements. • Summary report: Upon the completion of the test run, a brief summary report is prepared for improvising and concluding.