Avatar Data Warehouse - IRIS
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
Scenario 1: Data Warehouse Processing (IRIS)- Table row validations
Specific Setup:
- Have Avatar database server set up that is running on "IRIS" based system that's configured with the parent namespace and one or more child namespaces
- Have a server installed with the latest released version of "Avatar Data Warehouse Middleware" for "IRIS".
- Netsmart has been configured the middleware to initiate the data warehouse process
- Have a "Microsoft SQL Server" where table data processed by the data warehouse process will be stored
- Have a database program that can query the data in the tables stored on the data warehouse server. For example program "DBeaver Universal Database Manager" or "Crystal Reports"
- In form "User Definition", a user had been created [AvatarDW] as the designated data warehouse user.
- [AvatarDW] has been assigned permissions to tables determined to be included in the data warehouse process, that includes tables selected in parent namespace and in any child namespaces
- In form "Data Warehouse Transient Comparison Configuration", the designated data warehouse user [AvatarDW] has the designated tables selected in previous selected in "Mark Tables for Full Load" section
- Have a report or query that will display data in the "SYSTEM.dss_inc_error_log" table
- Have a report or query that will display data in the "SYSTEM.dss_inc_full_load_history" table
- Netsmart has run "Data Warehouse Middleware" process on the middleware server, in the parent namespace and each child namespace
Steps
- Generate the report to display data in the "SYSTEM.dss_inc_error_log" table
- Validate there are no results indicating the data warehouse middleware process has completed successfully
- Generate the report to display data in the "SYSTEM.dss_inc_full_load_history" table
- Validate the expected data rows are present on the report for the parent and child namespace tables selected for data warehouse processing in the setup
- Validate each row has "Insert" populated in the "Type" field
- Open the program to query data on the 'SQL' database server and connect to the database
- Run at query to display rows filed the "dss_completion_flag" table.
- Validate the expected tables are present on the results, for the parent and child namespace tables selected for data warehouse processing, in the setup
- Validate the "dss_status" field for each row is set to "1", indicating the table was loaded successfully
- From the database "Table" tree list, select tables form the parent and child namespaces
- Click to display the rows in the table
- Validate all data rows are displayed, as expected
|
Topics
• Data Warehouse
|
