Country Dimension - country_dimension_ctl_d.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: country_dimension_ctl_d.sql -- -- Author: Steve Roach -- -- Date: 05-SEP-2006 -- -- Version: 01.00 -- -- -- -- Description: Create seed data for sub-system Countries Dimension on CTL. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 05-SEP-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- DELETE FROM raw_html WHERE run_no IN (SELECT run_no FROM html_page_access WHERE html_page_name IN ('COUNTRIES')) / DELETE FROM parsed_html WHERE raw_run_no IN (SELECT run_no FROM html_page_access WHERE html_page_name IN ('COUNTRIES')) / DELETE FROM html_parse_passes WHERE raw_run_no IN (SELECT run_no FROM html_page_access WHERE html_page_name IN ('COUNTRIES')) / DELETE FROM html_page_access WHERE html_page_name IN ('COUNTRIES') / DELETE FROM html_pages WHERE name IN ('COUNTRIES') / DELETE FROM mapping_histories WHERE mapping_library IN ('M_S2S_COUNTRIES' ,'M_S2V_COUNTRIES' ,'M_V2O_COUNTRIES' ,'M_O2W_COUNTRIES') / DELETE FROM mapping_libraries WHERE mapping_name IN ('M_S2S_COUNTRIES' ,'M_S2V_COUNTRIES' ,'M_V2O_COUNTRIES' ,'M_O2W_COUNTRIES') / COMMIT / INSERT INTO html_pages ( name ,url ,username ,password ) VALUES ( 'COUNTRIES' ,'http://www.unicode.org/onlinedat/countries.html' ,NULL ,NULL ) / COMMIT / INSERT INTO mapping_libraries ( mapping_name ,rep_from ,rep_to ) VALUES ( 'M_S2S_COUNTRIES' ,'STAGING' ,'STAGING' ) / INSERT INTO mapping_libraries ( mapping_name ,rep_from ,rep_to ) VALUES ( 'M_S2V_COUNTRIES' ,'STAGING' ,'VALIDATION' ) / INSERT INTO mapping_libraries ( mapping_name ,rep_from ,rep_to ) VALUES ( 'M_V2O_COUNTRIES' ,'VALIDATION' ,'ODS' ) / INSERT INTO mapping_libraries ( mapping_name ,rep_from ,rep_to ) VALUES ( 'M_O2W_COUNTRIES' ,'WAREHOUSE' ,'VALIDATION' ) / COMMIT /