| Test Scenarios | Test Cases |
| ETL verification | - Verify data is mapped correctly from source to target system
|
| | - Verify all tables and their fields are copied from source to target
|
| | - Verify keys configured to be auto-generated are created properly in target system
|
| | - Verify that null fields are not populated
|
| | - Verify data is neither garbled nor truncated
|
| | - Verify data type and format in target system is as expected
|
| | - Verify there is no duplicity of data in the target system
|
| | - Verify transformations are applied correctly
|
| | - Verify that the precision of data in numeric fields is accurate
|
| | - Verify exception handling is robust
|
| Staging data | - Reconciliation check- record count between the STG (staging) tables and target tables are same after applying filter rules
|
| | - Insert a record which is not loaded into target table for given key combination
|
| | - Copy records, sending same records that are already loaded into target tables-should not be loaded
|
| | - Update a record for a key when value columns changed on day_02 loads
|
| | - Delete the records logically in the target tables
|
| | - Values loaded by process tables
|
| | - Values loaded by reference tables
|
| Data Loading in BI | - Check if the target and source data base are connected well and there are no access issues.
|
| | - For a full load, check the truncate option and ensure its working fine.
|
| | - While loading the data, check for the performance of the session
|
| | - Check for non-fatal errors.
|
| | - Verify you can fail the calling parent task if the child task fails.
|
| | - Verify that the logs are updated
|
| | - Verify mapping and workflow parameters are configured accurately
|
| | - Verify the number of tables in source and target systems is the same
|
| | - Compare the attributes from stage tables to that of the target tables. They should be matched.
|
| BI Reports | |
| | - Decimal precision for key figures
|
| | - In a given page display the number of rows and columns
|
| | - Free characteristics in the report
|
| | - How are blank values/data displayed for both characteristics and key figures in the report
|
| | - Whether search for characteristics is based on key or key&text as applicable
|
| | - Does search option on text is case sensitive- Upper, Lower or both
|
