分類: Informatica

MT/DIM

DIM_CURRENT/DIM_OLD/DIM_TEMP
TRUNCATE tmp –> INNER JOIN比對,如完全一樣INSERT tmp
1–> 上END DATE, UPDATE ( END_DATE IS NULL and _tmp no data )
2–> INSERT ( select _current and _tmp not exits )

MT/FCT

串SK & measure出來的值

MT/REF

PK,部分功能同DIM

INIT

建初始 @

EL

SP_EL_DIM_IMPORT.sql
–STEP 1: DROP COLUMN EXT_DATE
–STEP 2: EMPTY EL_TABLE
–STEP 3: CREATE BULK INSERT STATEMENT
–STEP 4: EXECUTE BULK INSERT STATEMENT
–STEP 5: ADD COLUMN EXT_DATE
–STEP 6: UPDATE EXT_DATE

資料提供：BOP\BOP_DW\BI_TXT\
自行產生：BOP\BOP_DW\DIM_TXT\

DDL

Creat Table