地理階層のロードの例
このトピックでは、地理階層のロード方法を示す例を示します。
地理階層の作成
次のGeographyHierarchy.datファイルの例では、基本的な地理階層レコードを作成します。
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||||||||||||このGeographyHierarchy.datでは、CountryCode 'US'について「WI, ABBOTSFORD, United States, WI」の値を持つレコードが2つあり、それらは「level 1、level 2、geography element 1、geography element 2」に対応しています。したがって、値「CLARK、ABBOTSFORD」と「MARATHON、ABBOTSFORD」を、レコードのgeography element 3とgeography element 4に指定することで、これら2つの地理ノードを一意に定義できます。
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|||||||地理階層の更新
次のGeographyHierarchy.datファイルの例では、地理階層のStartDateおよびStatusCodeを更新し、フランス用に新しい地理階層ノードを追加して、ドイツの地理階層ノードを削除します。
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|||||||||||||地理階層の削除
次のGeographyHierarchy.datファイルの例では、名前属性を使用して地理階層レコードを削除します。
METADATA|GeographyHierarchy|Name|StartDate|StartOnActivationFlag|StatusCode
DELETE|GeographyHierarchy|HDLGH-Jun25-0547|||