Posts Tagged ‘testing’

On our business intelligence team, we use a document to display what we call the “cross walk” for Source Tables, Mart Tables and Reporting Layer objects. And from this document, we can know the ETL mapping between source columns and mart columns, and we also can know the ETL mapping between these mart columns and […]

When we do the automatic testing for web service, we need the JDBC Steps in SoupUI so that we can confirm some value in the Database. How to add the JDBC Steps in SoupUI   a. Adding the file ojdbc14.jar in the folder: C:\Program Files\eviware\soapUI-3.6\lib   b. Adding the following string in the Configuration session: […]

Recently one of the projects that I was involved in was finished. The testing was blocked at the end phase, and the cost was almost exhausted even though the testing had not been finished when testers were rolled off. People always talk about quality, and most people agree that quality should be the most important […]

We have team members who attended a Boot Camp where they learned skills such as how to write a unit test.  They are very smart and created a lot of unit tests for their code. We use unit test coverage rates to judge the quality of unit tests. The boot camp team got a 87.5% […]

Summary: In BI testing, we create views for large amounts of data, but performance issues can occur when we need to pivot a column and make it a string. To improve the performance, we divide this column into two groups first, one is for the unique value that doesn’t need any combination, and another one […]

This blog briefly talks about the situations which may lead to the difficulty of measuring a product’s quality. Most of time, when producing a product such as an iPad, there are very detailed metrics that can be used to determine the product’s quality. For a project generating a software system, there should also be such […]

Author Nancy Xu   Sr. Technical Consultant Recently we finished another ecommerce project website testing. Comparing this site with other sites we have developed, I found there are some common designs within these two products. Please see them bellow in the list. Product Navigation: website’s navigation allows visitors to get from page to page and discover […]

After doing QA testing estimation for several projects, when it comes to design the template, I still believe the hardest part  is to identify the complexity and figure out the factors. And the secondary difficult thing to do is how to add the effort for any contingencies. Finally before to use the template or be confident […]

Selecting and deploying a test management system is probably one of the hardest topics in BI mainly due to the lack of lightweight, easy to use test management frameworks well suited to BI.  Most of the mature test management suites target application and, most recently, web application development.  And that’s not all that useful for […]

In order to know the expected “after” of a test, you need to know the “before” (usually!).  Testing in BI requires test fixtures, a defined state of the system in the “before” state.  In BI, this is almost the same as a test data set, but we add in non-data system configurations, user sets, and […]

BI is built on a foundation of data.  Therefore, testing in BI requires test data, and that means we’ve got to get it from somewhere! I’ve seen two general strategies here: Load the test system directly with production data, meaning that the contents of the test system change with each “refresh”. Generate test data sets […]

“Our BI system needs better testing.  How?” always piques my interest.  The breadth of the BI ecosystem means that testing the system end-to-end involves crossing many technologies, areas of responsibility (functional competencies), and physical systems.  This covers most (all) the tool classes in this series, at very least: Data extracts/data acquisition – wide variety of […]