文件名称：练习-源到目标的映射关系-kettle最新培训资料（2019）
文件大小：3.78MB
文件格式：PPT
更新时间：2024-05-12 07:16:16
kettle 学习资料
练习2-源到目标的映射关系 源表 源列 目标表 目标列 转换说明 customer_layout CUSTOMER_NO STG_CUSTOMER CUST_ID Customer_no!=99999 and not isnull(customer_no) FIRSTNAME LASTNAME CUST_NAME The CUST_NAME column is a concatenation of the firstname and lastname ports. ADDRESS CUST_ADDRESS CITY CUST_CITY STATE CUST_STATE ZIP CUST_ZIP_CODE COUNTRY CUST_COUNTRY PHONE_NUMBER CUST_PHONE The CUST_PHONE is a reformat of the PHONE_NUMBER column. The PHONE_NUMBER column is in the format of 9999999999 and needs to be reformatted to (999) 999-9999. GENDER CUST_GENDER The CUST_GENDER is derived from the decoding of the GENDER column. The GENDER column is a 1 character column that contains either 'M' (male) or 'F' (female). Any other values will resolve to 'UNK'. AGE CUST_AGE_GROUP The CUST_AGE_GROUP is derived from the decoding of AGE column. The valid age groups are less than 20, 20 to 29, 30 to 39, 40 to 49, 50 to 60 and GREATER than 60. INCOME CUST_INCOME EMAIL CUST_E_MAIL AGE CUST_AGE