Verify Content

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

Mykola's tool populates the |primaryKey parameter based on the partitioned SQL script, which means START_DATE_TIME_KEY is shown as a primary key. This parameter must be cleared manually, since we have elected to show the nonpartitioned settings in the Column List tables. However, do not clear START_DATE_TIME_KEY in the following tables, since it is part of a composite PK even in the nonpartitioned script:

• SM_MEDIA_NEUTRAL_STATE_FACT
• CALLBACK_FACT
• SDR_SESSION_FACT
• SDR_USER_MILESTONE_FACT
• SDR_USER_INPUTS_FACT
• SDR_EXT_REQUEST_FACT
• SDR_CUST_ATRIBUTES_FACT

Use the following DPL to verify that unwanted |primaryKey = yes settings have been cleared.

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

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.

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.