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
