GPI

Vocabulary_ID=10

The following describes the procedure to update the GPI vocabulary with the latest release of the source.

The load process is a complete refresh of data. All new vocabulary entieties will be added. All vocabulary entities that do not exist in the latest files set will be marked as deprecated.

1.1 Scripts Transfer

All scripts and files listed at the bottom of this page should be transferred to specially created directory (eg /data/GPI).

All scripts marked red are under the development at the moment.

Script Name	Description
10_create_schema.sql	Create prestage-stage schema with tables and indexes
10_transform_row_maps.sql	Convert and store in stage table SOURCE_TO_CONCEPT_MAP_STAGE
10_load_maps.sql	Load only new maps into SOURCE_TO_CONCEPT_MAP table, add invalid code information

Comments