FANDOM


Target Table Name Target Column Name Source Table Source column name Comments Matching column SCD column
DIM_CUST_SITE CUST_SITE_KEY n/a n/a sequence number    
DIM_CUST_SITE CUST_SITE_CUR_FLAG n/a n/a etl process    
DIM_CUST_SITE CUST_SITE_EFF_DATE n/a n/a etl process    
DIM_CUST_SITE CUST_SITE_EFF_END_DATE n/a n/a etl process    
DIM_CUST_SITE SITE_USE_ID sap_cust_site site_customer_number sap feed. Convert to_number    
DIM_CUST_SITE BILL_TO_FLAG sap_cust_site bill_to_flag sap feed   X
DIM_CUST_SITE SHIP_TO_FLAG sap_cust_site ship_to_flag sap feed   X
DIM_CUST_SITE SITE_CUSTOMER_KEY dim_customer customer_key lookup from dim_customer    
DIM_CUST_SITE SITE_CUSTOMER_NUMBER sap_cust_site site_customer_number sap feed X X
DIM_CUST_SITE SITE_CUSTOMER_NAME sap_cust_site site_customer_name sap feed    
DIM_CUST_SITE ADDRESS_LINE1 sap_cust_site address_line_1 sap feed    
DIM_CUST_SITE ADDRESS_LINE2 sap_cust_site address_line_2 sap feed    
DIM_CUST_SITE ADDRESS_LINE3 n/a n/a      
DIM_CUST_SITE ADDRESS_LINE4 n/a n/a      
DIM_CUST_SITE CITY sap_cust_site city sap feed    
DIM_CUST_SITE STATE sap_cust_site region sap feed    
DIM_CUST_SITE POSTAL_CODE sap_cust_site postal_code sap feed    
DIM_CUST_SITE COUNTY sap_cust_site county sap feed    
DIM_CUST_SITE PROVINCE   n/a      
DIM_CUST_SITE COUNTRY sap_cust_site country sap feed    
DIM_CUST_SITE GEOCODE n/a n/a null    
DIM_CUST_SITE CUST_SITE_LOAD_DATE n/a n/a sysdate    
DIM_CUST_SITE CUST_SITE_ORIG_REF sap_cust_site site_customer_number sap feed.    
DIM_CUST_SITE EDW_BATCH_ID n/a n/a etl batch id    
             
Notes: Before loading from SAP feed, update all CUST_SITE_CUR_FLAG to ’N’      

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.