Creating Test Cases

In the Mapping Manager, you can define test cases at:

• Project-level
• Map-level

At the project-level, you can create multiple test cases. Whereas, at the map-level, you can create a single test case.

Creating Project-Level Test Cases

To create project-level test cases, follow these steps.

1. Go to Application Menu > Data Catalog > Mapping Manager > Workspace Mappings.
2. Expand a project and click the Test Case node.
   The Test Case Summary page appears.

3. Click .

The Add New Test Case page appears.
Note: Test cases created for a project are also applicable to the mappings under a project.


4. Enter appropriate values in the fields. Fields marked with a red asterisk are mandatory. Refer to the following table for field descriptions.

Field Name	Description
Test Case Name	Specifies the name of the test case. For example, Verifying the Completeness of Source Metadata.
Test Case Label	Specifies the unique label for the test case. For example, Source Metadata.
Type of Testing	Specifies the type of testing. For example, Metadata Testing.
Test SQL Script	Specifies the SQL script required in the test execution. For example, select * from dbo.ADS_ASSOCIATIONS.
Description	Specifies the test objective in brief. For example: The objective of the test case is to verify the completeness of source metadata.
Expected Result	Specifies the expected result of the test case in detail. For example: The source table should have 50 columns.
Actual Result	Specifies the actual test result after the execution of the test. For example: The source table has 39 columns.
Testing Comments	Specifies the testing comments about the test case. For example: The source metadata was scanned from a Sql Server database.

5. Click Save and Exit.

The test case is created and added to the Test Cases node.

Creating Map-Level Test Cases

To create map-level test cases, follow these steps.

1. Go to Application Menu > Data Catalog > Mapping Manager > Workspace Mappings.
2. Click a mapping and click the Test Specification tab.

It displays the existing project-level test cases.


3. Click .

The Add New Test Case page appears.


4. Enter appropriate values in the fields. Fields marked with a red asterisk are mandatory. Refer to the following table for field descriptions.

Field Name	Description
Test Case Name	Specifies the name of the test case. For example, Verifying the Completeness of Source Metadata.
Test Case Label	Specifies the unique label for the test case. For example, Source Metadata.
Priority	Specifies the priority of the test case. For example, High. Priority for business rules and functional test cases can be medium or higher.
Type of Testing	Specifies the type of testing. For example, Metadata Testing.
Extendable	Specifies whether the test case is visible even when this map is archived. A map is archived whenever you create a new version of the map.
Test SQL Script	Specifies the SQL script required in the test execution. For example, select * from dbo.ADS_ASSOCIATIONS.
Description	Specifies the test objective in brief. For example: The objective of the test case is to verify the completeness of source metadata.
Expected Result	Specifies the expected result of the test case in detail. For example: The source table should have 50 columns.
Actual Result	Specifies the actual test result after the execution of the test. For example: The source table has 39 columns.
Testing Comments	Specifies the testing comments about the test case. For example: The source metadata was scanned from a Sql Server database.
Test Case Status	Specifies the status of the test case. For example, Passed.
Approved	Specifies whether the test case is approved.

5. Click Save and Exit.

The test case is added under the Test Specification tab.

Once a test case is created, you can enrich it by:

• Adding validation steps
• Adding documents

Managing test cases involves:

• Updating test case status
• Approving test cases
• Exporting test cases
• Deleting test cases