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

SGHE Enterprise Data Warehouse EDW Source: FUND_HIERARCHY

Source Column Local Source Target Type Target Target Column Local Target
FUND_DESC_1 NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_LEVEL_1_LD

FUND_LEVEL_1_SD

NO

NO

FUND_DESC_2 NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_LEVEL_2_SD

FUND_LEVEL_2_LD

NO

NO

FUND_DESC_3 NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_LEVEL_3_LD

FUND_LEVEL_3_SD

NO

NO

FUND_DESC_4 NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_LEVEL_4_LD

FUND_LEVEL_4_SD

NO

NO

FUND_DESC_5 NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_LEVEL_5_SD

FUND_LEVEL_5_LD

NO

NO

FUND_LEVEL_1 NO

DIMENSION TABLE

WDT_FUND

FUND_LEVEL_1

NO

FUND_LEVEL_2 NO

DIMENSION TABLE

WDT_FUND

FUND_LEVEL_2

NO

FUND_LEVEL_3 NO

DIMENSION TABLE

WDT_FUND

FUND_LEVEL_3

NO

FUND_LEVEL_4 NO

DIMENSION TABLE

WDT_FUND

FUND_LEVEL_4

NO

FUND_LEVEL_5 NO

DIMENSION TABLE

WDT_FUND

FUND_LEVEL_5

NO

FUND_POOL NO

DIMENSION TABLE

WDT_FUND

FUND_POOL

NO

FUND_POOL_DESC NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_POOL_LD

FUND_POOL_SD

NO

NO

FUND_TYPE NO

DIMENSION TABLE

WDT_FUND

FUND_TYPE

NO

FUND_TYPE_DESC NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_TYPE_LD

FUND_TYPE_SD

NO

NO

FUND_TYPE_DESC_1 NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_TYPE_LEVEL_1_SD

FUND_TYPE_LEVEL_1_LD

NO

NO

FUND_TYPE_DESC_2 NO

DIMENSION TABLE

WDT_FUND

WDT_FUND

FUND_TYPE_LEVEL_2_LD

FUND_TYPE_LEVEL_2_SD

NO

NO

FUND_TYPE_LEVEL_1 NO

DIMENSION TABLE

WDT_FUND

FUND_TYPE_LEVEL_1

NO

FUND_TYPE_LEVEL_2 NO

DIMENSION TABLE

WDT_FUND

FUND_TYPE_LEVEL_2

NO



Ver: 3.1