(→Audit keys) |
|||
| Line 65: | Line 65: | ||
==Verify Primary and Foreign Keys== | ==Verify Primary and Foreign Keys== | ||
===Composite primary 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 | + | 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. It is part of the composite PK in the following tables: |
| + | <span style="font-size:75%"> | ||
{| | {| | ||
! Table | ! Table | ||
| Line 96: | Line 97: | ||
| SM_MEDIA_NEUTRAL_STATE_FACT | | SM_MEDIA_NEUTRAL_STATE_FACT | ||
| START_DATE_TIME_KEY, RESOURCE_KEY, RESOURCE_STATE_KEY, START_TS | | START_DATE_TIME_KEY, RESOURCE_KEY, RESOURCE_STATE_KEY, START_TS | ||
| − | |} | + | |}</span> |
Use the following DPL to verify that START_DATE_TIME_KEY has been set correctly. | Use the following DPL to verify that START_DATE_TIME_KEY has been set correctly. | ||
Revision as of 13:18, June 20, 2017
Contents
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 START_DATE_TIME_KEY correctly. It is part of the composite PK 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.
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.