Introduction

The country dimension is intended for those fact tables and star schemas that need to capture performance measurements in the sales domain.

Description

The country dimension is derived from:

  1. geo entity

The discriminating factor is the geoTypeId (value = "COUNTRY")

and consists of following elements (fields):

name

alias

type

description

dimensionId
id-longthe unique identifier of the record
geoId
idthe natural (primary) key from table 1 (see above): geoId
geoName
description

The name of the country

geoCode
short-varchar
abbreviation
short-varchar
telCountryCode
short-varchar
ccTld
short-varchar


Related tickets