Example: AAAAAAAAOKJNECAA r_reason_desc CHAR Weighted List row = r_reason_sk; ‘return_reasons’, (100) value_col= 0; weight column: 0 Notes. DISTRIBUTE BY REPLICATION ; ship_mode (UNUSED/UNREFERENCED) size: size of 20 ship_mode Type NULL? Table is Description used by Example: querys: 1|AAAAAAAABAAAAAAA|EXPRESS|AIR|UPS|YvxVaJI10| sm_ship_mode_sk BIGINT NOT Dense unique sequence. Starts at ${SK_ID_OFFSET} NULL sm_ship_mode_id CHAR (16) NOT Unique String, len: 16 NULL charset: “ABCDEFGHIJKLMNOPQRSTUVWXYZ” Example: AAAAAAAAOKJNECAA sm_type CHAR (30) Weighted list Value:0 weight:0 “ship_mode". sm_code CHAR (10) Weighted list Value:0 weight:0 “ship_mode_code". sm_carrier CHAR (20) Weighted list ". Value:0 weight:0 “ship_mode_carrier sm_contract CHAR (20) RandString ALPHANUM, min/max: RS_SM_CONTRACT, SM_CONTRACT Notes: DISTRIBUTE BY REPLICATION ; income_band (NOT USED!) size: fixed 20 income_band Type NULL? Table is used Description by querys: Example: 1|0|10000| ib_income_band_sk, BIGINT NOT Dense unique sequence. Starts at ${SK_ID_OFFSET} NULL ib_lower_bound INTEGER Weighted List ; row= ib_income_band_sk, valueCol=0 ‘income_band’ ib_upper_bound INTEGER Weighted List ; row= ib_income_band_sk, valueCol=1 ‘income_band’ Note: DISTRIBUTE BY REPLICATION ;
Example: AAAAAAAAOKJNECAA r_reason_desc CHAR (100) Weighted List ‘return_reasons’, row = r_reason_sk; value_col= 0; weight column: 0 Notes. DISTRIBUTE BY REPLICATION ; ship_mode (UNUSED/UNREFERENCED) size: size of 20 ship_mode Type NULL? Table is used by querys: Description Example: 1|AAAAAAAABAAAAAAA|EXPRESS|AIR|UPS|YvxVaJI10| sm_ship_mode_sk BIGINT NOT NULL Dense unique sequence. Starts at ${SK_ID_OFFSET} sm_ship_mode_id CHAR (16) NOT NULL Unique String, len: 16 charset: “ABCDEFGHIJKLMNOPQRSTUVWXYZ” Example: AAAAAAAAOKJNECAA sm_type CHAR (30) Weighted list “ship_mode". Value:0 weight:0 sm_code CHAR (10) Weighted list “ship_mode_code". Value:0 weight:0 sm_carrier CHAR (20) Weighted list “ship_mode_carrier ". Value:0 weight:0 sm_contract CHAR (20) RandString ALPHANUM, min/max: RS_SM_CONTRACT, SM_CONTRACT Notes: DISTRIBUTE BY REPLICATION ; income_band (NOT USED!) size: fixed 20 income_band Type NULL? Table is used by querys: Description Example: 1|0|10000| ib_income_band_sk, BIGINT NOT NULL Dense unique sequence. Starts at ${SK_ID_OFFSET} ib_lower_bound INTEGER Weighted List ‘income_band’ ; row= ib_income_band_sk, valueCol=0 ib_upper_bound INTEGER Weighted List ‘income_band’ ; row= ib_income_band_sk, valueCol=1 Note: DISTRIBUTE BY REPLICATION ;
tpcx-bb_v1.2.0.docx