Contents
Verify Content 1
The job aids on this page and on Verify Content 2 basically use checksums from Cargo and DPL queries to verify (a) that the actual data is correct (e.g., writer didn't forget to identify new tables/columns) and (b) that the data stored in Cargo and used to generate query results is complete. The pages have been split because having too many queries on a page can kill page performance.
Verify Summary of Table/Column Changes
The Summary of Info Mart Schema Changes page is constructed by Cargo query. To verify that the Cargo table has updated completely following table page updates, do a checksum of the number of entries in the summary table. Update the following running total as releases are published, so you have a correct baseline for the next checksum.
Checksum
As of release 8.5.014.19, there are 394 entries in the summary table.
Unexplained discrepancy from 8.5.014.09, which showed a total of 384.
JD maybe to do: Provide DPL queries to double-check totals. (For performance reasons, the queries would have to be on separate pages.)
Verify Indexes
There are 132 tables (including SDR_*), of which 26 do not have indexes.
Of the 106 tables that have indexes:
- All indexes are present in partitioned (no indexPresentInPartitioned=no).All indexes are present in partitioned (no indexPresentInPartitioned=no).
- All indexes have keyPresentInNonpartitioned on the page.All indexes have keyPresentInNonpartitioned on the page.
- All index keys are present in nonpartitioned (no keyPresentInNonpartitioned[1], etc.=no).All index keys are present in nonpartitioned (no keyPresentInNonpartitioned[1], etc.=no).
Verify Primary and Foreign Keys
Composite primary keys
Since we have elected to show the nonpartitioned settings in the Column List tables, START_DATE_TIME_KEY is not a primary key in most tables, whereas it is in the partitioned script. However, START_DATE_TIME_KEY is part of a composite PK even in the nonpartitioned script. You may need to manually correct Mykola's import file to set START_DATE_TIME_KEY correctly.
The following table lists the GIM tables where START_DATE_TIME_KEY is part of the composite PK. Use the DPL result that follows the table to verify that START_DATE_TIME_KEY has been set correctly.
| Table | Composite PK |
|---|---|
| BGS_SESSION_FACT | CBS_ID,START_DATE_TIME_KEY |
| CALLBACK_FACT | START_DATE_TIME_KEY,ADDED_TS,DS_AUDIT_KEY,EVENT_SEQUENCE |
| CHAT_SESSION_FACT | MEDIA_SERVER_IXN_GUID,START_DATE_TIME_KEY |
| GPM_FACT | MEDIA_SERVER_IXN_GUID,ROUTE_ATTEMPT_ID,RESOURCE_KEY,START_DATE_TIME_KEY |
| SDR_ACTIVITIES_FACT | SESSION_ID,START_DATE_TIME_KEY,SEQUENCE_ID |
| SDR_CUST_ATRIBUTES_FACT | SESSION_ID,START_DATE_TIME_KEY,SDR_CUST_ATRIBUTES_KEY |
| SDR_EXT_REQUEST_FACT | SESSION_ID,START_DATE_TIME_KEY,SEQUENCE_ID |
| SDR_SESSION_FACT | SESSION_ID,START_DATE_TIME_KEY |
| SDR_SURVEY_FACT | SESSION_ID,START_DATE_TIME_KEY,SEQUENCE_ID |
| SDR_SURVEY_TRANSCRIPT_FACT | SESSION_ID,START_DATE_TIME_KEY |
| SDR_USER_INPUTS_FACT | SESSION_ID,START_DATE_TIME_KEY,SEQUENCE_ID |
| SDR_USER_MILESTONE_FACT | SESSION_ID,START_DATE_TIME_KEY,SEQUENCE_ID |
| SM_MEDIA_NEUTRAL_STATE_FACT | START_DATE_TIME_KEY, RESOURCE_KEY, RESOURCE_STATE_KEY, START_TS |
Value of the primaryKey parameter for START_DATE_TIME_KEY on the following table(s):
Documentation:GIM:Library:Table-BGS SESSION FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-CALLBACK FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-CDR FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-CHAT SESSION FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-CHAT THREAD FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-COBROWSE FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-GPM FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-LDR FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR CUST ATRIBUTES FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR EXT REQUEST FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR SESSION FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR SURVEY FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR SURVEY TRANSCRIPT FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR USER INPUTS FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SDR USER MILESTONE FACT:8.5DRAFT - yes Documentation:GIM:Library:Table-SM MEDIA NEUTRAL STATE FACT:8.5DRAFT - yes
Audit keys
Use the following DPL to confirm that *_AUDIT_KEYs display as a foreign key:
All tables show *_AUDIT_KEY as a foreign key.All tables show *_AUDIT_KEY as a foreign key.
Tenant key
Use the following DPL to confirm that TENANT_KEY displays as a foreign key:
All tables show TENANT_KEY as a foreign key.All tables show TENANT_KEY as a foreign key.
Check Highlights, Change Bars, and Font Colors
The following pages have highlighted text:
- Documentation:GIM:Library:AboutThisPDM:8.5DRAFT
- Documentation:GIM:Library:InfoMart85Tables:8.5DRAFT
- Documentation:GIM:Library:InfoMart85Views:8.5DRAFT
- Documentation:GIM:Library:SubjectAreas:8.5DRAFT
- Documentation:GIM:Library:Table-GROUP ANNEX:8.5DRAFT
- Documentation:GIM:Library:View-CDR:8.5DRAFT
- Documentation:GIM:Library:View-CDR DATE TIME:8.5DRAFT
- Documentation:GIM:Library:Z GenerateDataExportList:8.5DRAFT
- Documentation:GIM:Library:Z GenerateExportLists:8.5DRAFT
- Documentation:GIM:Library:Z Instructions:8.5DRAFT
The following pages have change bars: No pages have change bars.