Jump to: navigation, search
(→‎Verify Primary and Foreign Keys)
Line 64: Line 64:
 
{{AnchorDiv|PKs}}
 
{{AnchorDiv|PKs}}
 
==Verify Primary and Foreign Keys==
 
==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:
+
===Composite primary keys===
−
{{ColumnFormat|content=
+
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 composite PKs in the following tables:
−
* SM_MEDIA_NEUTRAL_STATE_FACT
+
{|
−
* CALLBACK_FACT
+
! Table
−
* SDR_SESSION_FACT
+
! Composite PK
−
* SDR_USER_MILESTONE_FACT
+
|-
−
* SDR_USER_INPUTS_FACT
+
| CALLBACK_FACT  
−
* SDR_EXT_REQUEST_FACT
+
| START_DATE_TIME_KEY,ADDED_TS,DS_AUDIT_KEY,EVENT_SEQUENCE
−
* SDR_CUST_ATRIBUTES_FACT}}
+
|-
−
Use the following DPL to verify that unwanted {{!}}primaryKey = yes settings have been cleared.
+
| 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_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
 +
|}
 +
Use the following DPL to verify that START_DATE_TIME_KEY has been set correctly.
  
 
{{#dpl:
 
{{#dpl:
Line 87: Line 111:
 
}}
 
}}
  
 +
===Audit keys===
 
Use the following DPL to confirm that *_AUDIT_KEYs display as a foreign key:
 
Use the following DPL to confirm that *_AUDIT_KEYs display as a foreign key:
  

Revision as of 12:53, June 20, 2017

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

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 composite PKs in the following tables:

Table Composite PK
CALLBACK_FACT START_DATE_TIME_KEY,ADDED_TS,DS_AUDIT_KEY,EVENT_SEQUENCE
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_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

Use the following DPL to verify that START_DATE_TIME_KEY has been set correctly.

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.

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:

The following pages have change bars: No pages have change bars.

Comments or questions about this documentation? Contact us for support!