Examples of Loading Geography Hierarchy

This topic provides examples that show how to load geography hierarchies.

Creating Geography Hierarchy

This example GeographyHierarchy.dat file creates a basic geography hierarchy record.

METADATA|GeographyHierarchy|Name|StartDate|StartOnActivationFlag|StatusCode
MERGE|GeographyHierarchy|HDLGH-Jun25-0544||Y|ORA_ACTIVE
METADATA|GeographyHierarchyNode|Name|HierarchyId|CountryCode|Level1|Level2|GeographyElement1|GeographyElement2|GeographyElement3|GeographyElement4|GeographyElement5|GeographyElement6|GeographyElement7|GeographyElement8|GeographyElement9|GeographyElement10|DeleteFlag
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0544||DE|||||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0544||IT|TOSCANA|FIRENZE|||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0544||CA|NL||||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0544||CA|ON|Toronto|||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0544||CA|ON|Mississauga|||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0544||US|WA|SEATTLE|||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0544||US|SC||||||||||||

In this GeographyHierarchy.dat, for CountryCode 'US,' there are two records with the values WI, ABBOTSFORD, United States, WI at level 1, level 2, geography element 1, geography element 2, respectively. Hence, by additionally configuring the values CLARK, ABBOTSFORD, and MARATHON, ABBOTSFORD at geography element 3, and geography element 4 for the records, you can uniquely define two geography nodes.

METADATA|GeographyHierarchy|Name|StartDate|StartOnActivationFlag|StatusCode
MERGE|GeographyHierarchy|HDLGH-Jun25-0547|2021/06/29 00:00:00|N|ORA_DRAFT
METADATA|GeographyHierarchyNode|Name|HierarchyId|CountryCode|Level1|Level2|GeographyElement1|GeographyElement2|GeographyElement3|GeographyElement4|GeographyElement5|GeographyElement6|GeographyElement7|GeographyElement8|GeographyElement9|GeographyElement10|DeleteFlag
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||DE|||||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||IT|TOSCANA|FIRENZE|||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||CA|NL||||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||CA|ON|Toronto|||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||CA|ON|Mississauga|||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||US|WA|SEATTLE|||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||US|SC||||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||US|WI|ABBOTSFORD|United States|WI|CLARK|ABBOTSFORD|||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||US|WI|ABBOTSFORD|United States|WI|MARATHON|ABBOTSFORD|||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||US|MD|Parkville|United States|MD|Baltimore (Ind City)|Parkville|||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||US|MD|Parkville|United States|MD|Baltimore|Parkville|||||||

Updating Geography Hierarchy

This example GeographyHierarchy.dat file updates the StartDate and StatusCode of the geography hierarchy, adds a new geography hierarchy node for France, and deletes the geography hierarchy node for Germany.

METADATA|GeographyHierarchy|Name|StartDate|StartOnActivationFlag|StatusCode
MERGE|GeographyHierarchy|HDLGH-Jun25-0547|2021/06/30 00:00:00|N|ORA_ACTIVE
METADATA|GeographyHierarchyNode|Name|HierarchyId|CountryCode|Level1|Level2|GeographyElement1|GeographyElement2|GeographyElement3|GeographyElement4|GeographyElement5|GeographyElement6|GeographyElement7|GeographyElement8|GeographyElement9|GeographyElement10|DeleteFlag
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||DE|||||||||||||Y
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||IT|TOSCANA|FIRENZE|||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||CA|NL||||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||CA|ON|Toronto|||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||CA|ON|Mississauga|||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||US|WA|SEATTLE|||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||US|SC||||||||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||US|WI|ABBOTSFORD|United States|WI|CLARK|ABBOTSFORD|||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||US|WI|ABBOTSFORD|United States|WI|MARATHON|ABBOTSFORD|||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||US|MD|Parkville|United States|MD|Baltimore (Ind City)|Parkville|||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||US|MD|Parkville|United States|MD|Baltimore|Parkville|||||||
MERGE|GeographyHierarchyNode|HDLGH-Jun25-0547||FR|||||||||||||

Deleting Geography Hierarchy

This example GeographyHierarchy.dat file deletes the geography hierarchy record using the Name attribute.

METADATA|GeographyHierarchy|Name|StartDate|StartOnActivationFlag|StatusCode
DELETE|GeographyHierarchy|HDLGH-Jun25-0547|||