RETURN TO EDW META DATA REPORTS LIST
(ODS Target Report)

SGHE Enterprise Data Warehouse EDW Source: ACCOUNT_HIERARCHY

Source Column Local Source Target Type Target Target Column Local Target
ACCOUNT_DESC NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_SD

NO

ACCOUNT_DESC_1 NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

ACCOUNT_LEVEL_1_LD

ACCOUNT_LEVEL_1_SD

NO

NO

ACCOUNT_DESC_2 NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

ACCOUNT_LEVEL_2_LD

ACCOUNT_LEVEL_2_SD

NO

NO

ACCOUNT_DESC_3 NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

ACCOUNT_LEVEL_3_SD

ACCOUNT_LEVEL_3_LD

NO

NO

ACCOUNT_DESC_4 NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

ACCOUNT_LEVEL_4_LD

ACCOUNT_LEVEL_4_SD

NO

NO

ACCOUNT_LEVEL_1 NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_LEVEL_1

NO

ACCOUNT_LEVEL_2 NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_LEVEL_2

NO

ACCOUNT_LEVEL_3 NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_LEVEL_3

NO

ACCOUNT_LEVEL_4 NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_LEVEL_4

NO

ACCOUNT_POOL NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_POOL

NO

ACCOUNT_POOL_DESC NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

ACCOUNT_POOL_SD

ACCOUNT_POOL_LD

NO

NO

ACCOUNT_TYPE NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_TYPE

NO

ACCOUNT_TYPE_DESC NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

ACCOUNT_TYPE_SD

ACCOUNT_TYPE_LD

NO

NO

ACCOUNT_TYPE_DESC_1 NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

ACCOUNT_TYPE_LEVEL_1_LD

ACCOUNT_TYPE_LEVEL_1_SD

NO

NO

ACCOUNT_TYPE_DESC_2 NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

ACCOUNT_TYPE_LEVEL_2_LD

ACCOUNT_TYPE_LEVEL_2_SD

NO

NO

ACCOUNT_TYPE_LEVEL_1 NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_TYPE_LEVEL_1

NO

ACCOUNT_TYPE_LEVEL_2 NO

DIMENSION TABLE

WDT_ACCOUNT

ACCOUNT_TYPE_LEVEL_2

NO

INTERNAL_ACCOUNT_TYPE NO

DIMENSION TABLE

WDT_ACCOUNT

INTERNAL_ACCOUNT_TYPE

NO

INTERNAL_ACCOUNT_TYPE_DESC NO

DIMENSION TABLE

WDT_ACCOUNT

WDT_ACCOUNT

INTERNAL_ACCOUNT_TYPE_LD

INTERNAL_ACCOUNT_TYPE_SD

NO

NO



Ver: 3.1