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.

Answer:- ETL Testing includes: • Verifying whether the data is transformed accurately according to business requirements • Verifying that the projected data is loaded into the data warehouse without any truncation or data loss • Making sure that the ETL application reports any invalid data and replaces with default values • Making sure that the data loads within the expected time frame to improve scalability and performance

Answer:- • Calculation Bug • User Interface Bug • Source Bug • Load Condition Bug • ECP-related Bug In addition to the above ETL Testing questions, there may be other vital questions where you might be asked to mention the ETL tools that you have used earlier. Also, you might be asked about any debugging issues you have faced in your earlier real-time experience.

Answer:- Fact is a central component of a multi-dimensional model that contains the measures to be analyzed. Facts are related to dimensions. Types of facts are: • Additive Facts • Semi-additive Facts • Non-additive Facts

Answer:- Cubes are data processing units comprised of fact tables and dimensions from the data warehouse. They provide a multi-dimensional analysis. OLAP stands for ‘Online Analytics Processing,’ and OLAP Cubes store voluminous data in a multi-dimensional form for reporting purposes. They consist of facts called ‘measures’ categorized by dimensions.

Answer:- Types of data warehouse applications are: • Info Processing • Analytical Processing • Data Mining Data mining can be defined as the process of extracting hidden predictive information from large databases and interpreting the data, while data warehousing may make use of a data mine for the analytical processing of the data in a faster way. Data warehousing is the process of aggregating data from multiple sources into one common repository.

Answer:- Software testing is a validation process which confirms that a system works as per the business requirements. It qualifies a system on various aspects such as usability, accuracy, completeness, efficiency, etc. ANSI/IEEE 1059 is the global standard that defines the basic principles of testing.

Answer:- The testing activity ends when the testing team completes the following milestones. • Test case execution The successful completion of a full test cycle after the final bug fix marks the end of the testing phase. • Testing deadline The end date of the validation stage also declares the closure of the validation if no critical or high-priority defects remain in the system. • Code Coverage(CC) ratio It is the amount of code concealed via automated tests. If the team achieves the intended level of code coverage (CC) ratio, then it can choose to end the validation. • Mean Time Between Failure (MTBF) rate Mean time between failure (MTBF) refers to the average amount of time that a device or product functions before failing. This unit of measurement includes only operational time between failures and does not include repair times, assuming the item is repaired and begins functioning again. MTBF figures are often used to project how likely a single unit is to fail within a certain period of time

Answer:- In software testing, verification is a process to confirm that product development is taking place as per the specifications and using the standard development procedures. The process comprises the following activities: • Inspections • Reviews • Walk-throughs • Demos

Answer:- Static testing is a white-box testing technique that directs developers to verify their code with the help of a checklist to find errors in it. Developers can start the static testing without actually finalizing the application or program. Static testing is more cost-effective than dynamic testing as it more areas than dynamic testing in a shorter time.

Answer:- It is a standard software testing approach that requires testers to assess the functionality of the software as per the business requirements. The software is treated as a black box and validated as per the end user’s point of view.

Answer:- A test plan stores all possible testing activities to ensure a quality product. It gathers data from the product description, requirement, and use case documents. The test plan document includes the following: • Testing objectives • Test scope • Testing the frame • Environment • Reason for testing • Criteria for entrance and exit • Deliverables • Risk factors

Answer:- Test coverage is a quality metric to represent the amount (in percentage) of testing completed for a product. It is relevant for both functional and non-functional testing activities. This metric is used to add missing test cases.