Fandom

Scratchpad

SAP data conversion mappings - DIM CUST SITE

216,259pages on
this wiki
Add New Page
Discuss this page0 Share

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.

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’      

Also on Fandom

Random wikia