#__AW_Repository_Version '12.2.0.0000';
#__AW_Product_Version '12.2.0.0';
#__AW_ATL_Locale 'eng_au.utf-8';
ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Mon Apr 12 14:57:57 2010' )
CREATE DATABASE DATASTORE DEMO_E2E_SBO::'fb9ad710-4902-4725-ac35-bc14d3360518' SET ("DB2_version" = 'DB2 UDB 9.x',
"DBLiveLoad" = 'no',
"DB_connection_retry_count" = '3',
"DB_retry_interval" = '10000',
"Oracle_default_number_precision" = '28',
"Oracle_default_number_scale" = '7',
"abap_execution_mode" = 'generate_and_execute',
"abap_job_class" = 'C',
"abap_upload_application" = 'S',
"abap_upload_package" = '$TMP',
"abap_upload_status" = 'T',
"application_type" = 'Custom',
"attunity_workspace" = 'Navigator',
"case_sensitive" = 'no',
"cdc_enabled" = 'no',
"data_federator_version" = 'Data Federator 11.x',
"database_type" = 'Microsoft_SQL_Server',
"datastore_repotype" = 'local',
"db_date_format" = 'yyyy-mm-dd',
"db_datetime_format" = 'yyyy-mm-dd hh:mi:ss',
"db_decimal_separator" = '.',
"db_driver_supports_array_fetch" = 'odbc_automatic',
"db_driver_supports_param_sql" = 'odbc_automatic',
"db_time_format" = 'hh:mi:ss',
"ds_configuration_enabled" = 'yes',
"ds_configurations" = '<?xml version="1.0" encoding="WINDOWS-1252" ?>
<DSConfigurations>
<DSConfiguration default="true" name="Configuration1">
<case_sensitive>no</case_sensitive>
<database_type>Microsoft_SQL_Server</database_type>
<loader_xact_size>1000</loader_xact_size>
<locale_codepage>&lt;default&gt;</locale_codepage>
<locale_language>&lt;default&gt;</locale_language>
<locale_territory>&lt;default&gt;</locale_territory>
<mssql_windows_authentication>no</mssql_windows_authentication>
<password>;9FE2393FF3CA25C5688D6687ED16C919F171C32A44EC8500A598F17CE4651F8486F61D9D13587A4EF226C085DB4F5F73</password>
<server_codepage>&lt;default&gt;</server_codepage>
<sql_server_database>DEMO_E2E_SBO</sql_server_database>
<sql_server_dataserver>localhost</sql_server_dataserver>
<sql_server_version>Microsoft SQL Server 2008</sql_server_version>
<user>sa</user>
</DSConfiguration>
</DSConfigurations>
',
"enable_data_transfer" = 'yes',
"ftp_passwd" = ';559C6A7816572D64CB2BA3965C5EF56C4850C6C12E9905633CC56F59DDD7E41D',
"import_unknown_type" = 'no',
"informix_version" = 'Informix IDS 10.0',
"js_db_on_same_machine" = 'no',
"loader_file_location" = 'shared_directory',
"loader_xact_size" = '1000',
"locale_codepage" = '<default>',
"locale_language" = '<default>',
"locale_territory" = '<default>',
"mssql_windows_authentication" = 'no',
"mysql_version" = 'MySQL 5.0',
"name" = 'DEMO_E2E_SBO',
"neoview_datasource" = 'Admin_Load_DataSource',
"neoview_version" = 'HP Neoview 2.4',
"netezza_version" = 'Netezza NPS 2.5',
"odbc_autocommit_support" = 'odbc_automatic',
"odbc_convert_func_support" = 'odbc_automatic',
"odbc_func_absolute" = 'odbc_automatic',
"odbc_func_avg" = 'odbc_automatic',
"odbc_func_ceiling" = 'odbc_automatic',
"odbc_func_count" = 'odbc_automatic',
"odbc_func_count_distinct" = 'odbc_automatic',
"odbc_func_dayofmonth" = 'odbc_automatic',
"odbc_func_dayofyear" = 'odbc_automatic',
"odbc_func_floor" = 'odbc_automatic',
"odbc_func_lcase" = 'odbc_automatic',
"odbc_func_length" = 'odbc_automatic',
"odbc_func_ln" = 'odbc_automatic',
"odbc_func_log" = 'odbc_automatic',
"odbc_func_ltrim_blanks" = 'odbc_automatic',
"odbc_func_max" = 'odbc_automatic',
"odbc_func_min" = 'odbc_automatic',
"odbc_func_mod" = 'odbc_automatic',
"odbc_func_month" = 'odbc_automatic',
"odbc_func_power" = 'odbc_automatic',
"odbc_func_quarter" = 'odbc_automatic',
"odbc_func_round" = 'odbc_automatic',
"odbc_func_rtrim_blanks" = 'odbc_automatic',
"odbc_func_soundex" = 'odbc_automatic',
"odbc_func_sqrt" = 'odbc_automatic',
"odbc_func_substring" = 'odbc_automatic',
"odbc_func_sum" = 'odbc_automatic',
"odbc_func_sysdate" = 'odbc_automatic',
"odbc_func_systime" = 'odbc_automatic',
"odbc_func_truncate" = 'odbc_automatic',
"odbc_func_ucase" = 'odbc_automatic',
"odbc_func_week" = 'odbc_automatic',
"odbc_func_year" = 'odbc_automatic',
"odbc_ifthenelse_func_support" = 'no',
"odbc_ms_access" = 'no',
"odbc_nvarchar_type_name" = '<unknown>',
"odbc_nvl_func_support" = 'odbc_automatic',
"odbc_outer_join_support" = 'odbc_automatic',
"oracle_version" = 'Oracle 11g',
"password" = ';9FE2393FF3CA25C5688D6687ED16C919F171C32A44EC8500A598F17CE4651F8486F61D9D13587A4EF226C085DB4F5F73',
"pcache_force_utf16" = 'no',
"rem_repo_passwd" = 'no',
"runtime_in_utf16" = '1',
"sap_language" = 'E - English',
"sap_system_number" = '00',
"sap_use_rfc_ini" = 'no',
"secure_repo" = 'no',
"server_codepage" = '<default>',
"server_sorts_in_binary" = 'yes',
"sql_server_database" = 'DEMO_E2E_SBO',
"sql_server_dataserver" = 'localhost',
"sql_server_version" = 'Microsoft SQL Server 2008',
"sybase_iq_version" = 'Sybase IQ 12.7',
"sybase_version" = 'Sybase ASE 15.x',
"teradata_version" = 'Teradata 12',
"transaction_isolation_level" = 'Database default',
"transfer_password" = ';559C6A7816572D64CB2BA3965C5EF56CBDA6025B350E45E0D1261733E2DAFAE4',
"trex_version" = 'TREX 7.x',
"unknown_type_size" = '255',
"use_named_pipe" = 'no',
"user" = 'sa',
"xml_recursion_level" = '0');

 AlGUIComment (ActaName_1 = 'RTable_Type',ActaValue_1 = 'TABLE' , 
ActaName_2 = 'RDescription',ActaValue_2 = '' , 
ActaName_3 = 'REstimated_Row_Count',ActaValue_3 = '50000' , 
ActaName_4 = 'RLoader_Is_Template_Table',ActaValue_4 = 'no' , 
ActaName_5 = 'RSavedAfterCheckOut',ActaValue_5 = 'YES' , 
ActaName_6 = 'RDate_created',ActaValue_6 = 'Thu Apr 15 20:40:42 2010' , 
ActaName_7 = 'RDate_last_loaded',ActaValue_7 = 'Tue Jun 01 05:03:01 2010' , 
ActaName_8 = 'RDate_modified',ActaValue_8 = 'Thu Apr 15 20:41:19 2010' , 
ActaName_9 = 'RTotal_Number_Of_Rows_Processed',ActaValue_9 = '168' , 
ActaName_10 = 'RNumber_Of_Rows_Rejected',ActaValue_10 = '0' , 
ActaName_11 = 'RNumber_Of_Inserts',ActaValue_11 = '168' , 
ActaName_12 = 'RNumber_Of_Updates',ActaValue_12 = '0' , 
ActaName_13 = 'RNumber_Of_Deletes',ActaValue_13 = '0' , 
ActaName_14 = 'RElapsed_Time_For_Load',ActaValue_14 = '0 Seconds' )
CREATE TABLE DEMO_E2E_SBO.DBO.DIM_DATE(DATE_SK INT  KEY  NULL  SET("ui_mapping_text" = 'julian(Date_Generation.DI_GENERATED_DATE)'), 
YEAR INT  NULL  SET("ui_mapping_text" = 'year(Date_Generation.DI_GENERATED_DATE)'), 
QUARTER INT  NULL  SET("ui_mapping_text" = 'quarter(Date_Generation.DI_GENERATED_DATE)'), 
MONTH INT  NULL  SET("ui_mapping_text" = 'month(Date_Generation.DI_GENERATED_DATE)'), 
"DATE" DATE  NULL  SET("Content_Type" = 'DATE', "Description" = 'The date is automatically generated by the Date_Generation transform', "ui_mapping_text" = 'Date_Generation.DI_GENERATED_DATE')) 
PRIMARY KEY (DATE_SK) 
SET("db_alias_name" = 'DBO')
;

 AlGUIComment (ActaName_1 = 'RTable_Type',ActaValue_1 = 'TABLE' , 
ActaName_2 = 'RDescription',ActaValue_2 = '' , 
ActaName_3 = 'REstimated_Row_Count',ActaValue_3 = '50000' , 
ActaName_4 = 'RLoader_Is_Template_Table',ActaValue_4 = 'no' , 
ActaName_5 = 'RSavedAfterCheckOut',ActaValue_5 = 'YES' , 
ActaName_6 = 'RDate_created',ActaValue_6 = 'Thu Apr 15 20:40:42 2010' , 
ActaName_7 = 'RDate_last_loaded',ActaValue_7 = 'Tue Jun 01 05:03:02 2010' , 
ActaName_8 = 'RDate_modified',ActaValue_8 = 'Thu Apr 15 20:41:24 2010' , 
ActaName_9 = 'RTotal_Number_Of_Rows_Processed',ActaValue_9 = '155' , 
ActaName_10 = 'RNumber_Of_Rows_Rejected',ActaValue_10 = '0' , 
ActaName_11 = 'RNumber_Of_Inserts',ActaValue_11 = '155' , 
ActaName_12 = 'RNumber_Of_Updates',ActaValue_12 = '0' , 
ActaName_13 = 'RNumber_Of_Deletes',ActaValue_13 = '0' , 
ActaName_14 = 'RElapsed_Time_For_Load',ActaValue_14 = '0 Seconds' )
CREATE TABLE DEMO_E2E_SBO.DBO.DIM_LGA(LGA_SK INT  KEY  NULL  SET("ui_mapping_text" = 'Query.LGA_SK'), 
STATE_REGION VARCHAR(100)  NULL  SET("ui_mapping_text" = 'E2E_Region_LGAs.Region'), 
LOCAL_GOVERNMENT_AUTHORITY VARCHAR(100)  NULL  SET("ui_mapping_text" = 'Query.Local_Government_Authority')) 
PRIMARY KEY (LGA_SK) 
SET("db_alias_name" = 'DBO')
;

 AlGUIComment (ActaName_1 = 'RTable_Type',ActaValue_1 = 'TABLE' , 
ActaName_2 = 'RDescription',ActaValue_2 = '' , 
ActaName_3 = 'REstimated_Row_Count',ActaValue_3 = '50000' , 
ActaName_4 = 'RLoader_Is_Template_Table',ActaValue_4 = 'no' , 
ActaName_5 = 'RSavedAfterCheckOut',ActaValue_5 = 'YES' , 
ActaName_6 = 'RDate_created',ActaValue_6 = 'Thu Apr 15 20:40:43 2010' , 
ActaName_7 = 'RDate_last_loaded',ActaValue_7 = 'Tue Jun 01 05:03:03 2010' , 
ActaName_8 = 'RDate_modified',ActaValue_8 = 'Thu Apr 15 20:41:30 2010' , 
ActaName_9 = 'RTotal_Number_Of_Rows_Processed',ActaValue_9 = '68' , 
ActaName_10 = 'RNumber_Of_Rows_Rejected',ActaValue_10 = '0' , 
ActaName_11 = 'RNumber_Of_Inserts',ActaValue_11 = '68' , 
ActaName_12 = 'RNumber_Of_Updates',ActaValue_12 = '0' , 
ActaName_13 = 'RNumber_Of_Deletes',ActaValue_13 = '0' , 
ActaName_14 = 'RElapsed_Time_For_Load',ActaValue_14 = '0 Seconds' )
CREATE TABLE DEMO_E2E_SBO.DBO.DIM_OFFENCE_TYPE(OFFENCE_TYPE_SK INT  KEY  NULL  SET("ui_mapping_text" = 'gen_row_num()'), 
OFFENCE_CATEGORY VARCHAR(100)  NULL  SET("ui_mapping_text" = 'STG_SOURCE."Offence category"'), 
OFFENCE_SUBCATEGORY VARCHAR(100)  NULL  SET("ui_mapping_text" = 'nvl(STG_SOURCE.SUBCATEGORY,STG_SOURCE."Offence category")')) 
PRIMARY KEY (OFFENCE_TYPE_SK) 
SET("db_alias_name" = 'DBO')
;

 AlGUIComment (ActaName_1 = 'RTable_Type',ActaValue_1 = 'TABLE' , 
ActaName_2 = 'RDescription',ActaValue_2 = '' , 
ActaName_3 = 'REstimated_Row_Count',ActaValue_3 = '50000' , 
ActaName_4 = 'RLoader_Is_Template_Table',ActaValue_4 = 'no' , 
ActaName_5 = 'RSavedAfterCheckOut',ActaValue_5 = 'YES' , 
ActaName_6 = 'RDate_created',ActaValue_6 = 'Mon Apr 19 23:05:32 2010' , 
ActaName_7 = 'RDate_last_loaded',ActaValue_7 = 'Tue Jun 01 05:07:24 2010' , 
ActaName_8 = 'RDate_modified',ActaValue_8 = 'Sun May 30 11:12:02 2010' , 
ActaName_9 = 'RTotal_Number_Of_Rows_Processed',ActaValue_9 = '1770720' , 
ActaName_10 = 'RNumber_Of_Rows_Rejected',ActaValue_10 = '0' , 
ActaName_11 = 'RNumber_Of_Inserts',ActaValue_11 = '1770720' , 
ActaName_12 = 'RNumber_Of_Updates',ActaValue_12 = '0' , 
ActaName_13 = 'RNumber_Of_Deletes',ActaValue_13 = '0' , 
ActaName_14 = 'RElapsed_Time_For_Load',ActaValue_14 = '1 Minutes and 19 Seconds' )
CREATE TABLE DEMO_E2E_SBO.DBO.FACT_CRIMES(CRIME_SK INT  KEY  NULL  SET("ui_mapping_text" = 'gen_row_num( )'), 
DATE_SK INT  NULL  SET("ui_mapping_text" = 'julian(to_date(\'01 \' || Pivot.Month,\'DD MON YYYY\'))'), 
LGA_SK INT  NULL  SET("ui_mapping_text" = 'lookup_ext([DEMO_E2E_SBO.DBO.DIM_LGA,\'PRE_LOAD_CACHE\',\'MAX\'], [LGA_SK],[NULL],[LOCAL_GOVERNMENT_AUTHORITY,\'=\',Pivot.LGA]) SET ("run_as_separate_process"=\'no\', "output_cols_info"=\'<?xml version="1.0" encoding="UTF-8"?><output_cols_info><col index="1" expression="no"/>
</output_cols_info>\' )'), 
OFFENCE_TYPE_SK INT  NULL  SET("ui_mapping_text" = 'lookup_ext([DEMO_E2E_SBO.DBO.DIM_OFFENCE_TYPE,\'PRE_LOAD_CACHE\',\'MAX\'], [OFFENCE_TYPE_SK],[NULL],[OFFENCE_CATEGORY,\'=\',Pivot."Offence category",OFFENCE_SUBCATEGORY,\'=\',Pivot.SUBCATEGORY]) SET ("run_as_separate_process"=\'no\', "output_cols_info"=\'<?xml version="1.0" encoding="UTF-8"?><output_cols_info><col index="1" expression="no"/>
</output_cols_info>\' )'), 
NUMBER_OF_CRIMES INT  NULL  SET("ui_mapping_text" = 'Pivot.Number_of_Crimes')) 
PRIMARY KEY (CRIME_SK) 
SET("db_alias_name" = 'DBO')
;

 AlGUIComment (ActaName_1 = 'RTable_Type',ActaValue_1 = 'TABLE' , 
ActaName_2 = 'RDescription',ActaValue_2 = '' , 
ActaName_3 = 'REstimated_Row_Count',ActaValue_3 = '50000' , 
ActaName_4 = 'RLoader_Is_Template_Table',ActaValue_4 = 'no' , 
ActaName_5 = 'RSavedAfterCheckOut',ActaValue_5 = 'YES' , 
ActaName_6 = 'RDate_created',ActaValue_6 = 'Thu Apr 15 20:37:48 2010' , 
ActaName_7 = 'RDate_last_loaded',ActaValue_7 = 'Tue Jun 01 05:03:01 2010' , 
ActaName_8 = 'RDate_modified',ActaValue_8 = 'Thu Apr 15 20:39:13 2010' , 
ActaName_9 = 'RTotal_Number_Of_Rows_Processed',ActaValue_9 = '10540' , 
ActaName_10 = 'RNumber_Of_Rows_Rejected',ActaValue_10 = '0' , 
ActaName_11 = 'RNumber_Of_Inserts',ActaValue_11 = '10540' , 
ActaName_12 = 'RNumber_Of_Updates',ActaValue_12 = '0' , 
ActaName_13 = 'RNumber_Of_Deletes',ActaValue_13 = '0' , 
ActaName_14 = 'RElapsed_Time_For_Load',ActaValue_14 = '2 Seconds' )
CREATE TABLE DEMO_E2E_SBO.DBO.STG_SOURCE(LGA VARCHAR(50)  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source.LGA'), 
"Offence category" VARCHAR(75)  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Offence category"'), 
SUBCATEGORY VARCHAR(75)  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source.Subcategory'), 
"Jan 1995" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jan 1995"'), 
"Feb 1995" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Feb 1995"'), 
"Mar 1995" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Mar 1995"'), 
"Apr 1995" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Apr 1995"'), 
"May 1995" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."May 1995"'), 
"Jun 1995" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jun 1995"'), 
"Jul 1995" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jul 1995"'), 
"Aug 1995" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Aug 1995"'), 
"Sep 1995" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Sep 1995"'), 
"Oct 1995" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Oct 1995"'), 
"Nov 1995" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Nov 1995"'), 
"Dec 1995" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Dec 1995"'), 
"Jan 1996" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jan 1996"'), 
"Feb 1996" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Feb 1996"'), 
"Mar 1996" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Mar 1996"'), 
"Apr 1996" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Apr 1996"'), 
"May 1996" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."May 1996"'), 
"Jun 1996" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jun 1996"'), 
"Jul 1996" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jul 1996"'), 
"Aug 1996" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Aug 1996"'), 
"Sep 1996" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Sep 1996"'), 
"Oct 1996" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Oct 1996"'), 
"Nov 1996" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Nov 1996"'), 
"Dec 1996" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Dec 1996"'), 
"Jan 1997" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jan 1997"'), 
"Feb 1997" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Feb 1997"'), 
"Mar 1997" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Mar 1997"'), 
"Apr 1997" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Apr 1997"'), 
"May 1997" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."May 1997"'), 
"Jun 1997" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jun 1997"'), 
"Jul 1997" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jul 1997"'), 
"Aug 1997" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Aug 1997"'), 
"Sep 1997" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Sep 1997"'), 
"Oct 1997" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Oct 1997"'), 
"Nov 1997" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Nov 1997"'), 
"Dec 1997" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Dec 1997"'), 
"Jan 1998" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jan 1998"'), 
"Feb 1998" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Feb 1998"'), 
"Mar 1998" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Mar 1998"'), 
"Apr 1998" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Apr 1998"'), 
"May 1998" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."May 1998"'), 
"Jun 1998" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jun 1998"'), 
"Jul 1998" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jul 1998"'), 
"Aug 1998" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Aug 1998"'), 
"Sep 1998" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Sep 1998"'), 
"Oct 1998" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Oct 1998"'), 
"Nov 1998" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Nov 1998"'), 
"Dec 1998" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Dec 1998"'), 
"Jan 1999" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jan 1999"'), 
"Feb 1999" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Feb 1999"'), 
"Mar 1999" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Mar 1999"'), 
"Apr 1999" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Apr 1999"'), 
"May 1999" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."May 1999"'), 
"Jun 1999" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jun 1999"'), 
"Jul 1999" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jul 1999"'), 
"Aug 1999" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Aug 1999"'), 
"Sep 1999" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Sep 1999"'), 
"Oct 1999" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Oct 1999"'), 
"Nov 1999" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Nov 1999"'), 
"Dec 1999" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Dec 1999"'), 
"Jan 2000" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jan 2000"'), 
"Feb 2000" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Feb 2000"'), 
"Mar 2000" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Mar 2000"'), 
"Apr 2000" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Apr 2000"'), 
"May 2000" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."May 2000"'), 
"Jun 2000" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jun 2000"'), 
"Jul 2000" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jul 2000"'), 
"Aug 2000" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Aug 2000"'), 
"Sep 2000" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Sep 2000"'), 
"Oct 2000" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Oct 2000"'), 
"Nov 2000" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Nov 2000"'), 
"Dec 2000" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Dec 2000"'), 
"Jan 2001" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jan 2001"'), 
"Feb 2001" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Feb 2001"'), 
"Mar 2001" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Mar 2001"'), 
"Apr 2001" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Apr 2001"'), 
"May 2001" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."May 2001"'), 
"Jun 2001" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jun 2001"'), 
"Jul 2001" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jul 2001"'), 
"Aug 2001" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Aug 2001"'), 
"Sep 2001" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Sep 2001"'), 
"Oct 2001" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Oct 2001"'), 
"Nov 2001" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Nov 2001"'), 
"Dec 2001" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Dec 2001"'), 
"Jan 2002" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jan 2002"'), 
"Feb 2002" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Feb 2002"'), 
"Mar 2002" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Mar 2002"'), 
"Apr 2002" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Apr 2002"'), 
"May 2002" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."May 2002"'), 
"Jun 2002" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jun 2002"'), 
"Jul 2002" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jul 2002"'), 
"Aug 2002" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Aug 2002"'), 
"Sep 2002" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Sep 2002"'), 
"Oct 2002" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Oct 2002"'), 
"Nov 2002" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Nov 2002"'), 
"Dec 2002" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Dec 2002"'), 
"Jan 2003" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jan 2003"'), 
"Feb 2003" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Feb 2003"'), 
"Mar 2003" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Mar 2003"'), 
"Apr 2003" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Apr 2003"'), 
"May 2003" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."May 2003"'), 
"Jun 2003" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jun 2003"'), 
"Jul 2003" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jul 2003"'), 
"Aug 2003" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Aug 2003"'), 
"Sep 2003" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Sep 2003"'), 
"Oct 2003" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Oct 2003"'), 
"Nov 2003" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Nov 2003"'), 
"Dec 2003" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Dec 2003"'), 
"Jan 2004" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jan 2004"'), 
"Feb 2004" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Feb 2004"'), 
"Mar 2004" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Mar 2004"'), 
"Apr 2004" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Apr 2004"'), 
"May 2004" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."May 2004"'), 
"Jun 2004" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jun 2004"'), 
"Jul 2004" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jul 2004"'), 
"Aug 2004" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Aug 2004"'), 
"Sep 2004" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Sep 2004"'), 
"Oct 2004" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Oct 2004"'), 
"Nov 2004" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Nov 2004"'), 
"Dec 2004" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Dec 2004"'), 
"Jan 2005" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jan 2005"'), 
"Feb 2005" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Feb 2005"'), 
"Mar 2005" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Mar 2005"'), 
"Apr 2005" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Apr 2005"'), 
"May 2005" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."May 2005"'), 
"Jun 2005" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jun 2005"'), 
"Jul 2005" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jul 2005"'), 
"Aug 2005" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Aug 2005"'), 
"Sep 2005" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Sep 2005"'), 
"Oct 2005" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Oct 2005"'), 
"Nov 2005" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Nov 2005"'), 
"Dec 2005" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Dec 2005"'), 
"Jan 2006" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jan 2006"'), 
"Feb 2006" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Feb 2006"'), 
"Mar 2006" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Mar 2006"'), 
"Apr 2006" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Apr 2006"'), 
"May 2006" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."May 2006"'), 
"Jun 2006" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jun 2006"'), 
"Jul 2006" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jul 2006"'), 
"Aug 2006" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Aug 2006"'), 
"Sep 2006" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Sep 2006"'), 
"Oct 2006" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Oct 2006"'), 
"Nov 2006" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Nov 2006"'), 
"Dec 2006" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Dec 2006"'), 
"Jan 2007" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jan 2007"'), 
"Feb 2007" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Feb 2007"'), 
"Mar 2007" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Mar 2007"'), 
"Apr 2007" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Apr 2007"'), 
"May 2007" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."May 2007"'), 
"Jun 2007" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jun 2007"'), 
"Jul 2007" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jul 2007"'), 
"Aug 2007" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Aug 2007"'), 
"Sep 2007" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Sep 2007"'), 
"Oct 2007" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Oct 2007"'), 
"Nov 2007" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Nov 2007"'), 
"Dec 2007" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Dec 2007"'), 
"Jan 2008" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jan 2008"'), 
"Feb 2008" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Feb 2008"'), 
"Mar 2008" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Mar 2008"'), 
"Apr 2008" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Apr 2008"'), 
"May 2008" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."May 2008"'), 
"Jun 2008" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jun 2008"'), 
"Jul 2008" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Jul 2008"'), 
"Aug 2008" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Aug 2008"'), 
"Sep 2008" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Sep 2008"'), 
"Oct 2008" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Oct 2008"'), 
"Nov 2008" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Nov 2008"'), 
"Dec 2008" INT  NULL  SET("ui_mapping_text" = 'E2E_SBO_Source."Dec 2008"')) 
SET("db_alias_name" = 'DBO')
;
ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Tue Apr 13 16:31:43 2010' , "ActaName_3" = 'RDate_modified' , "ActaValue_3" = 'Sun May 30 11:11:39 2010', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name' )
CREATE FILE DATASTORE E2E_Region_LGAs::'33929310-416c-4418-b8e0-cfc988ef7f06'(Region VARCHAR(100)  SET( "Content_Type"='REGION' ), LGA VARCHAR(100) ) SET ("abap_file_format" = 'no',
"blank_pad" = 'leading',
"cache" = 'yes',
"column_delimiter" = ',',
"column_width" = '1',
"column_width1" = '100',
"column_width2" = '100',
"date_format" = 'yyyy.mm.dd',
"datetime_format" = 'yyyy.mm.dd hh24:mi:ss',
"file_format" = 'ascii',
"file_location" = 'local',
"file_name" = 'Regions and LGAs.csv',
"file_type" = 'delimited_file',
"locale_codepage" = '<default>',
"locale_language" = '<default>',
"locale_territory" = '<default>',
"name" = 'E2E_Region_LGAs',
"reader_capture_data_conversion_errors" = 'no',
"reader_capture_row_format_errors" = 'yes',
"reader_log_data_conversion_warnings" = 'yes',
"reader_log_row_format_warnings" = 'yes',
"reader_maximum_warnings_to_log" = '-99',
"reader_write_error_rows_to_file" = 'no',
"root_dir" = 'C:\\Users\\josh.fletcher\\Desktop\\E2E SBO',
"row_delimiter" = '\\n',
"skip_row_header" = 'yes',
"table_weight" = '0',
"time_format" = 'hh24:mi:ss',
"transfer_custom" = 'no',
"use_root_dir" = 'no',
"write_bom" = 'no' );ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Mon Apr 12 16:51:32 2010' , "ActaName_3" = 'RDate_modified' , "ActaValue_3" = 'Sun May 30 11:12:36 2010', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name' )
CREATE FILE DATASTORE E2E_SBO_Source::'169e060f-4eb7-4837-b6cd-e738c04572f2'(LGA VARCHAR(50) , "Offence category" VARCHAR(75) , Subcategory VARCHAR(75) , "Jan 1995" INT , "Feb 1995" INT , "Mar 1995" INT , "Apr 1995" INT , "May 1995" INT , "Jun 1995" INT , "Jul 1995" INT , "Aug 1995" INT , "Sep 1995" INT , "Oct 1995" INT , "Nov 1995" INT , "Dec 1995" INT , "Jan 1996" INT , "Feb 1996" INT , "Mar 1996" INT , "Apr 1996" INT , "May 1996" INT , "Jun 1996" INT , "Jul 1996" INT , "Aug 1996" INT , "Sep 1996" INT , "Oct 1996" INT , "Nov 1996" INT , "Dec 1996" INT , "Jan 1997" INT , "Feb 1997" INT , "Mar 1997" INT , "Apr 1997" INT , "May 1997" INT , "Jun 1997" INT , "Jul 1997" INT , "Aug 1997" INT , "Sep 1997" INT , "Oct 1997" INT , "Nov 1997" INT , "Dec 1997" INT , "Jan 1998" INT , "Feb 1998" INT , "Mar 1998" INT , "Apr 1998" INT , "May 1998" INT , "Jun 1998" INT , "Jul 1998" INT , "Aug 1998" INT , "Sep 1998" INT , "Oct 1998" INT , "Nov 1998" INT , "Dec 1998" INT , "Jan 1999" INT , "Feb 1999" INT , "Mar 1999" INT , "Apr 1999" INT , "May 1999" INT , "Jun 1999" INT , "Jul 1999" INT , "Aug 1999" INT , "Sep 1999" INT , "Oct 1999" INT , "Nov 1999" INT , "Dec 1999" INT , "Jan 2000" INT , "Feb 2000" INT , "Mar 2000" INT , "Apr 2000" INT , "May 2000" INT , "Jun 2000" INT , "Jul 2000" INT , "Aug 2000" INT , "Sep 2000" INT , "Oct 2000" INT , "Nov 2000" INT , "Dec 2000" INT , "Jan 2001" INT , "Feb 2001" INT , "Mar 2001" INT , "Apr 2001" INT , "May 2001" INT , "Jun 2001" INT , "Jul 2001" INT , "Aug 2001" INT , "Sep 2001" INT , "Oct 2001" INT , "Nov 2001" INT , "Dec 2001" INT , "Jan 2002" INT , "Feb 2002" INT , "Mar 2002" INT , "Apr 2002" INT , "May 2002" INT , "Jun 2002" INT , "Jul 2002" INT , "Aug 2002" INT , "Sep 2002" INT , "Oct 2002" INT , "Nov 2002" INT , "Dec 2002" INT , "Jan 2003" INT , "Feb 2003" INT , "Mar 2003" INT , "Apr 2003" INT , "May 2003" INT , "Jun 2003" INT , "Jul 2003" INT , "Aug 2003" INT , "Sep 2003" INT , "Oct 2003" INT , "Nov 2003" INT , "Dec 2003" INT , "Jan 2004" INT , "Feb 2004" INT , "Mar 2004" INT , "Apr 2004" INT , "May 2004" INT , "Jun 2004" INT , "Jul 2004" INT , "Aug 2004" INT , "Sep 2004" INT , "Oct 2004" INT , "Nov 2004" INT , "Dec 2004" INT , "Jan 2005" INT , "Feb 2005" INT , "Mar 2005" INT , "Apr 2005" INT , "May 2005" INT , "Jun 2005" INT , "Jul 2005" INT , "Aug 2005" INT , "Sep 2005" INT , "Oct 2005" INT , "Nov 2005" INT , "Dec 2005" INT , "Jan 2006" INT , "Feb 2006" INT , "Mar 2006" INT , "Apr 2006" INT , "May 2006" INT , "Jun 2006" INT , "Jul 2006" INT , "Aug 2006" INT , "Sep 2006" INT , "Oct 2006" INT , "Nov 2006" INT , "Dec 2006" INT , "Jan 2007" INT , "Feb 2007" INT , "Mar 2007" INT , "Apr 2007" INT , "May 2007" INT , "Jun 2007" INT , "Jul 2007" INT , "Aug 2007" INT , "Sep 2007" INT , "Oct 2007" INT , "Nov 2007" INT , "Dec 2007" INT , "Jan 2008" INT , "Feb 2008" INT , "Mar 2008" INT , "Apr 2008" INT , "May 2008" INT , "Jun 2008" INT , "Jul 2008" INT , "Aug 2008" INT , "Sep 2008" INT , "Oct 2008" INT , "Nov 2008" INT , "Dec 2008" INT ) SET ("abap_file_format" = 'no',
"blank_pad" = 'leading',
"cache" = 'yes',
"column_delimiter" = ',',
"column_width" = '1',
"column_width1" = '50',
"column_width10" = '2',
"column_width100" = '2',
"column_width101" = '2',
"column_width102" = '2',
"column_width103" = '2',
"column_width104" = '2',
"column_width105" = '2',
"column_width106" = '2',
"column_width107" = '2',
"column_width108" = '2',
"column_width109" = '2',
"column_width11" = '2',
"column_width110" = '2',
"column_width111" = '2',
"column_width112" = '2',
"column_width113" = '2',
"column_width114" = '2',
"column_width115" = '2',
"column_width116" = '2',
"column_width117" = '2',
"column_width118" = '2',
"column_width119" = '2',
"column_width12" = '2',
"column_width120" = '2',
"column_width121" = '2',
"column_width122" = '2',
"column_width123" = '2',
"column_width124" = '2',
"column_width125" = '2',
"column_width126" = '2',
"column_width127" = '2',
"column_width128" = '2',
"column_width129" = '2',
"column_width13" = '2',
"column_width130" = '2',
"column_width131" = '2',
"column_width132" = '2',
"column_width133" = '2',
"column_width134" = '2',
"column_width135" = '2',
"column_width136" = '2',
"column_width137" = '2',
"column_width138" = '2',
"column_width139" = '2',
"column_width14" = '2',
"column_width140" = '2',
"column_width141" = '2',
"column_width142" = '2',
"column_width143" = '2',
"column_width144" = '2',
"column_width145" = '2',
"column_width146" = '2',
"column_width147" = '2',
"column_width148" = '2',
"column_width149" = '2',
"column_width15" = '2',
"column_width150" = '2',
"column_width151" = '2',
"column_width152" = '2',
"column_width153" = '2',
"column_width154" = '2',
"column_width155" = '2',
"column_width156" = '2',
"column_width157" = '2',
"column_width158" = '2',
"column_width159" = '2',
"column_width16" = '2',
"column_width160" = '2',
"column_width161" = '2',
"column_width162" = '2',
"column_width163" = '2',
"column_width164" = '2',
"column_width165" = '2',
"column_width166" = '2',
"column_width167" = '2',
"column_width168" = '2',
"column_width169" = '2',
"column_width17" = '2',
"column_width170" = '2',
"column_width171" = '2',
"column_width172" = '2',
"column_width18" = '2',
"column_width19" = '2',
"column_width2" = '75',
"column_width20" = '2',
"column_width21" = '2',
"column_width22" = '2',
"column_width23" = '2',
"column_width24" = '2',
"column_width25" = '2',
"column_width26" = '2',
"column_width27" = '2',
"column_width28" = '2',
"column_width29" = '2',
"column_width3" = '75',
"column_width30" = '2',
"column_width31" = '2',
"column_width32" = '2',
"column_width33" = '2',
"column_width34" = '2',
"column_width35" = '2',
"column_width36" = '2',
"column_width37" = '2',
"column_width38" = '2',
"column_width39" = '2',
"column_width4" = '2',
"column_width40" = '2',
"column_width41" = '2',
"column_width42" = '2',
"column_width43" = '2',
"column_width44" = '2',
"column_width45" = '2',
"column_width46" = '2',
"column_width47" = '2',
"column_width48" = '2',
"column_width49" = '2',
"column_width5" = '2',
"column_width50" = '2',
"column_width51" = '2',
"column_width52" = '2',
"column_width53" = '2',
"column_width54" = '2',
"column_width55" = '2',
"column_width56" = '2',
"column_width57" = '2',
"column_width58" = '2',
"column_width59" = '2',
"column_width6" = '2',
"column_width60" = '2',
"column_width61" = '2',
"column_width62" = '2',
"column_width63" = '2',
"column_width64" = '2',
"column_width65" = '2',
"column_width66" = '2',
"column_width67" = '2',
"column_width68" = '2',
"column_width69" = '2',
"column_width7" = '2',
"column_width70" = '2',
"column_width71" = '2',
"column_width72" = '2',
"column_width73" = '2',
"column_width74" = '2',
"column_width75" = '2',
"column_width76" = '2',
"column_width77" = '2',
"column_width78" = '2',
"column_width79" = '2',
"column_width8" = '2',
"column_width80" = '2',
"column_width81" = '2',
"column_width82" = '2',
"column_width83" = '2',
"column_width84" = '2',
"column_width85" = '2',
"column_width86" = '2',
"column_width87" = '2',
"column_width88" = '2',
"column_width89" = '2',
"column_width9" = '2',
"column_width90" = '2',
"column_width91" = '2',
"column_width92" = '2',
"column_width93" = '2',
"column_width94" = '2',
"column_width95" = '2',
"column_width96" = '2',
"column_width97" = '2',
"column_width98" = '2',
"column_width99" = '2',
"date_format" = 'yyyy.mm.dd',
"datetime_format" = 'yyyy.mm.dd hh24:mi:ss',
"file_format" = 'ascii',
"file_location" = 'local',
"file_name" = 'NSW Crimes Data 95-08.csv',
"file_type" = 'delimited_file',
"locale_codepage" = '<default>',
"locale_language" = '<default>',
"locale_territory" = '<default>',
"name" = 'E2E_SBO_Source',
"reader_capture_data_conversion_errors" = 'no',
"reader_capture_row_format_errors" = 'yes',
"reader_log_data_conversion_warnings" = 'yes',
"reader_log_row_format_warnings" = 'yes',
"reader_maximum_warnings_to_log" = '-99',
"reader_write_error_rows_to_file" = 'no',
"root_dir" = 'C:\\Users\\josh.fletcher\\Desktop\\E2E SBO',
"row_delimiter" = '\\n',
"skip_row_header" = 'yes',
"table_weight" = '0',
"text_delimiter" = '"',
"time_format" = 'hh24:mi:ss',
"transfer_custom" = 'no',
"use_root_dir" = 'no',
"write_bom" = 'no' );ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Mon Apr 12 14:56:14 2010' , "ActaName_3" = 'RDate_modified' , "ActaValue_3" = 'Tue Jun 01 05:08:36 2010' )
CREATE SESSION J_E2E_SBO::'5c14982a-6207-4569-a975-23b2364e9442'( )
BEGIN
ALGUICOMMENT( x = '97', y = '-100',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>394</CX><CY>-179</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-190</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>' )
CALL DATAFLOW DF_E2E_Stage_Source::'80ef2c17-dc1b-4dc4-b4d9-38ce5b301b65'();
ALGUICOMMENT( x = '400', y = '-275',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>328</CX><CY>-179</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-190</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>' )
CALL DATAFLOW DF_E2E_Dim_Date::'6f593a0e-6d50-4db6-a927-c2c879c5bb70'();
ALGUICOMMENT( x = '775', y = '-441',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>328</CX><CY>-179</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-190</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>' )
CALL DATAFLOW DF_E2E_Dim_LGA::'6c9cfbdd-c297-4eeb-8c9f-5ebf64ec7620'();
ALGUICOMMENT( x = '1184', y = '-631',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>394</CX><CY>-179</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-190</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>' )
CALL DATAFLOW DF_E2E_Dim_Offence_Type::'1bd8c800-e9f7-4173-b658-0c44113291a5'();
ALGUICOMMENT( x = '1709', y = '-822',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>385</CX><CY>-179</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-190</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>' )
CALL DATAFLOW DF_E2E_Fact_Crimes::'3153b63e-872a-47a1-babf-f5ec7aa7b28c'();
END

SET("job_checkpoint_enabled" = 'no',
"job_collect_statistics" = 'no',
"job_collect_statistics_monitor" = 'no',
"job_enable_assemblers" = 'yes',
"job_enable_audit" = 'yes',
"job_enable_dataquality" = 'yes',
"job_export_repo" = 'no',
"job_export_reports" = 'no',
"job_guid" = '5c14982a-6207-4569-a975-23b2364e9442',
"job_isrecoverable" = 'no',
"job_mode" = 'Multi-Process',
"job_monitor_sample_rate" = '1000',
"job_name" = 'J_E2E_SBO',
"job_print_version" = 'no',
"job_testmode_enabled" = 'no',
"job_trace_abapquery" = 'no',
"job_trace_all" = 'no',
"job_trace_ascomm" = 'no',
"job_trace_assemblers" = 'no',
"job_trace_audit" = 'no',
"job_trace_dataflow" = 'yes',
"job_trace_idoc_file" = 'no',
"job_trace_memory_loader" = 'no',
"job_trace_memory_reader" = 'no',
"job_trace_optimized_dataflow" = 'no',
"job_trace_parallel_execution" = 'no',
"job_trace_rfc_function" = 'no',
"job_trace_row" = 'no',
"job_trace_script" = 'no',
"job_trace_session" = 'yes',
"job_trace_sql_only" = 'no',
"job_trace_sqlfunctions" = 'no',
"job_trace_sqlloaders" = 'no',
"job_trace_sqlreaders" = 'no',
"job_trace_sqltransforms" = 'no',
"job_trace_stored_procedure" = 'no',
"job_trace_table" = 'no',
"job_trace_table_reader" = 'no',
"job_trace_transform" = 'no',
"job_trace_userfunction" = 'no',
"job_trace_usertransform" = 'no',
"job_trace_workflow" = 'yes',
"job_type" = 'batch',
"job_use_statistics" = 'yes',
"locale_codepage" = '<default>',
"locale_language" = '<default>',
"locale_territory" = '<default>')
ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Mon Apr 12 16:52:31 2010' , "ActaName_3" = 'Rcolumn_mapping_calculated' , "ActaValue_3" = 'yes' , "ActaName_4" = 'RDate_modified' , "ActaValue_4" = 'Sun May 30 11:16:49 2010' )
CREATE DATAFLOW DF_E2E_Stage_Source::'80ef2c17-dc1b-4dc4-b4d9-38ce5b301b65'

BEGIN 
ALGUICOMMENT( x = '147', y = '-116' , ui_display_name = '"NSW Crimes Data 95-08.csv"(E2E_SBO_Source)',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>325</CX><CY>-183</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Description', Input_2nd_Column_Name = 'Type', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = '' )
GUID::'4e561c31-db55-4721-a5a7-b5c5b86dfeef' READ FILE E2E_SBO_Source."NSW Crimes Data 95-08.csv"  OUTPUT ( E2E_SBO_Source ) SET (
"adaptable" = 'no',
"cache" = 'yes',
"connection_port" = 'no',
"file_location" = 'local',
"name" = 'E2E_SBO_Source',
"reader_capture_data_conversion_errors" = 'no',
"reader_capture_row_format_errors" = 'yes',
"reader_filename_col" = 'DI_FILENAME',
"reader_filename_col_size" = '100',
"reader_filename_only" = 'no',
"reader_include_filename" = 'no',
"reader_log_data_conversion_warnings" = 'yes',
"reader_log_row_format_warnings" = 'yes',
"reader_maximum_warnings_to_log" = '-99',
"reader_write_error_rows_to_file" = 'no',
"root_dir" = 'C:\\Users\\josh.fletcher\\Desktop\\E2E SBO',
"table_weight" = '0',
"transfer_custom" = 'no');
ALGUICOMMENT( x = '509', y = '-328' , ui_acta_from_schema_0 = 'E2E_SBO_Source' ,UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>238</CX><CY>-164</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name', UI_PASSTHRU_VSPLIT_PCT = '50' )
GUID::'3f49841f-b3b8-4f5a-ad29-591e2da1b54e' CREATE VIEW Query ( LGA varchar(50) SET("ui_mapping_text"='E2E_SBO_Source.LGA') ,
 "Offence category" varchar(75) SET("ui_mapping_text"='E2E_SBO_Source."Offence category"') ,
 Subcategory varchar(75) SET("ui_mapping_text"='E2E_SBO_Source.Subcategory') ,
 "Jan 1995" int SET("ui_mapping_text"='E2E_SBO_Source."Jan 1995"') ,
 "Feb 1995" int SET("ui_mapping_text"='E2E_SBO_Source."Feb 1995"') ,
 "Mar 1995" int SET("ui_mapping_text"='E2E_SBO_Source."Mar 1995"') ,
 "Apr 1995" int SET("ui_mapping_text"='E2E_SBO_Source."Apr 1995"') ,
 "May 1995" int SET("ui_mapping_text"='E2E_SBO_Source."May 1995"') ,
 "Jun 1995" int SET("ui_mapping_text"='E2E_SBO_Source."Jun 1995"') ,
 "Jul 1995" int SET("ui_mapping_text"='E2E_SBO_Source."Jul 1995"') ,
 "Aug 1995" int SET("ui_mapping_text"='E2E_SBO_Source."Aug 1995"') ,
 "Sep 1995" int SET("ui_mapping_text"='E2E_SBO_Source."Sep 1995"') ,
 "Oct 1995" int SET("ui_mapping_text"='E2E_SBO_Source."Oct 1995"') ,
 "Nov 1995" int SET("ui_mapping_text"='E2E_SBO_Source."Nov 1995"') ,
 "Dec 1995" int SET("ui_mapping_text"='E2E_SBO_Source."Dec 1995"') ,
 "Jan 1996" int SET("ui_mapping_text"='E2E_SBO_Source."Jan 1996"') ,
 "Feb 1996" int SET("ui_mapping_text"='E2E_SBO_Source."Feb 1996"') ,
 "Mar 1996" int SET("ui_mapping_text"='E2E_SBO_Source."Mar 1996"') ,
 "Apr 1996" int SET("ui_mapping_text"='E2E_SBO_Source."Apr 1996"') ,
 "May 1996" int SET("ui_mapping_text"='E2E_SBO_Source."May 1996"') ,
 "Jun 1996" int SET("ui_mapping_text"='E2E_SBO_Source."Jun 1996"') ,
 "Jul 1996" int SET("ui_mapping_text"='E2E_SBO_Source."Jul 1996"') ,
 "Aug 1996" int SET("ui_mapping_text"='E2E_SBO_Source."Aug 1996"') ,
 "Sep 1996" int SET("ui_mapping_text"='E2E_SBO_Source."Sep 1996"') ,
 "Oct 1996" int SET("ui_mapping_text"='E2E_SBO_Source."Oct 1996"') ,
 "Nov 1996" int SET("ui_mapping_text"='E2E_SBO_Source."Nov 1996"') ,
 "Dec 1996" int SET("ui_mapping_text"='E2E_SBO_Source."Dec 1996"') ,
 "Jan 1997" int SET("ui_mapping_text"='E2E_SBO_Source."Jan 1997"') ,
 "Feb 1997" int SET("ui_mapping_text"='E2E_SBO_Source."Feb 1997"') ,
 "Mar 1997" int SET("ui_mapping_text"='E2E_SBO_Source."Mar 1997"') ,
 "Apr 1997" int SET("ui_mapping_text"='E2E_SBO_Source."Apr 1997"') ,
 "May 1997" int SET("ui_mapping_text"='E2E_SBO_Source."May 1997"') ,
 "Jun 1997" int SET("ui_mapping_text"='E2E_SBO_Source."Jun 1997"') ,
 "Jul 1997" int SET("ui_mapping_text"='E2E_SBO_Source."Jul 1997"') ,
 "Aug 1997" int SET("ui_mapping_text"='E2E_SBO_Source."Aug 1997"') ,
 "Sep 1997" int SET("ui_mapping_text"='E2E_SBO_Source."Sep 1997"') ,
 "Oct 1997" int SET("ui_mapping_text"='E2E_SBO_Source."Oct 1997"') ,
 "Nov 1997" int SET("ui_mapping_text"='E2E_SBO_Source."Nov 1997"') ,
 "Dec 1997" int SET("ui_mapping_text"='E2E_SBO_Source."Dec 1997"') ,
 "Jan 1998" int SET("ui_mapping_text"='E2E_SBO_Source."Jan 1998"') ,
 "Feb 1998" int SET("ui_mapping_text"='E2E_SBO_Source."Feb 1998"') ,
 "Mar 1998" int SET("ui_mapping_text"='E2E_SBO_Source."Mar 1998"') ,
 "Apr 1998" int SET("ui_mapping_text"='E2E_SBO_Source."Apr 1998"') ,
 "May 1998" int SET("ui_mapping_text"='E2E_SBO_Source."May 1998"') ,
 "Jun 1998" int SET("ui_mapping_text"='E2E_SBO_Source."Jun 1998"') ,
 "Jul 1998" int SET("ui_mapping_text"='E2E_SBO_Source."Jul 1998"') ,
 "Aug 1998" int SET("ui_mapping_text"='E2E_SBO_Source."Aug 1998"') ,
 "Sep 1998" int SET("ui_mapping_text"='E2E_SBO_Source."Sep 1998"') ,
 "Oct 1998" int SET("ui_mapping_text"='E2E_SBO_Source."Oct 1998"') ,
 "Nov 1998" int SET("ui_mapping_text"='E2E_SBO_Source."Nov 1998"') ,
 "Dec 1998" int SET("ui_mapping_text"='E2E_SBO_Source."Dec 1998"') ,
 "Jan 1999" int SET("ui_mapping_text"='E2E_SBO_Source."Jan 1999"') ,
 "Feb 1999" int SET("ui_mapping_text"='E2E_SBO_Source."Feb 1999"') ,
 "Mar 1999" int SET("ui_mapping_text"='E2E_SBO_Source."Mar 1999"') ,
 "Apr 1999" int SET("ui_mapping_text"='E2E_SBO_Source."Apr 1999"') ,
 "May 1999" int SET("ui_mapping_text"='E2E_SBO_Source."May 1999"') ,
 "Jun 1999" int SET("ui_mapping_text"='E2E_SBO_Source."Jun 1999"') ,
 "Jul 1999" int SET("ui_mapping_text"='E2E_SBO_Source."Jul 1999"') ,
 "Aug 1999" int SET("ui_mapping_text"='E2E_SBO_Source."Aug 1999"') ,
 "Sep 1999" int SET("ui_mapping_text"='E2E_SBO_Source."Sep 1999"') ,
 "Oct 1999" int SET("ui_mapping_text"='E2E_SBO_Source."Oct 1999"') ,
 "Nov 1999" int SET("ui_mapping_text"='E2E_SBO_Source."Nov 1999"') ,
 "Dec 1999" int SET("ui_mapping_text"='E2E_SBO_Source."Dec 1999"') ,
 "Jan 2000" int SET("ui_mapping_text"='E2E_SBO_Source."Jan 2000"') ,
 "Feb 2000" int SET("ui_mapping_text"='E2E_SBO_Source."Feb 2000"') ,
 "Mar 2000" int SET("ui_mapping_text"='E2E_SBO_Source."Mar 2000"') ,
 "Apr 2000" int SET("ui_mapping_text"='E2E_SBO_Source."Apr 2000"') ,
 "May 2000" int SET("ui_mapping_text"='E2E_SBO_Source."May 2000"') ,
 "Jun 2000" int SET("ui_mapping_text"='E2E_SBO_Source."Jun 2000"') ,
 "Jul 2000" int SET("ui_mapping_text"='E2E_SBO_Source."Jul 2000"') ,
 "Aug 2000" int SET("ui_mapping_text"='E2E_SBO_Source."Aug 2000"') ,
 "Sep 2000" int SET("ui_mapping_text"='E2E_SBO_Source."Sep 2000"') ,
 "Oct 2000" int SET("ui_mapping_text"='E2E_SBO_Source."Oct 2000"') ,
 "Nov 2000" int SET("ui_mapping_text"='E2E_SBO_Source."Nov 2000"') ,
 "Dec 2000" int SET("ui_mapping_text"='E2E_SBO_Source."Dec 2000"') ,
 "Jan 2001" int SET("ui_mapping_text"='E2E_SBO_Source."Jan 2001"') ,
 "Feb 2001" int SET("ui_mapping_text"='E2E_SBO_Source."Feb 2001"') ,
 "Mar 2001" int SET("ui_mapping_text"='E2E_SBO_Source."Mar 2001"') ,
 "Apr 2001" int SET("ui_mapping_text"='E2E_SBO_Source."Apr 2001"') ,
 "May 2001" int SET("ui_mapping_text"='E2E_SBO_Source."May 2001"') ,
 "Jun 2001" int SET("ui_mapping_text"='E2E_SBO_Source."Jun 2001"') ,
 "Jul 2001" int SET("ui_mapping_text"='E2E_SBO_Source."Jul 2001"') ,
 "Aug 2001" int SET("ui_mapping_text"='E2E_SBO_Source."Aug 2001"') ,
 "Sep 2001" int SET("ui_mapping_text"='E2E_SBO_Source."Sep 2001"') ,
 "Oct 2001" int SET("ui_mapping_text"='E2E_SBO_Source."Oct 2001"') ,
 "Nov 2001" int SET("ui_mapping_text"='E2E_SBO_Source."Nov 2001"') ,
 "Dec 2001" int SET("ui_mapping_text"='E2E_SBO_Source."Dec 2001"') ,
 "Jan 2002" int SET("ui_mapping_text"='E2E_SBO_Source."Jan 2002"') ,
 "Feb 2002" int SET("ui_mapping_text"='E2E_SBO_Source."Feb 2002"') ,
 "Mar 2002" int SET("ui_mapping_text"='E2E_SBO_Source."Mar 2002"') ,
 "Apr 2002" int SET("ui_mapping_text"='E2E_SBO_Source."Apr 2002"') ,
 "May 2002" int SET("ui_mapping_text"='E2E_SBO_Source."May 2002"') ,
 "Jun 2002" int SET("ui_mapping_text"='E2E_SBO_Source."Jun 2002"') ,
 "Jul 2002" int SET("ui_mapping_text"='E2E_SBO_Source."Jul 2002"') ,
 "Aug 2002" int SET("ui_mapping_text"='E2E_SBO_Source."Aug 2002"') ,
 "Sep 2002" int SET("ui_mapping_text"='E2E_SBO_Source."Sep 2002"') ,
 "Oct 2002" int SET("ui_mapping_text"='E2E_SBO_Source."Oct 2002"') ,
 "Nov 2002" int SET("ui_mapping_text"='E2E_SBO_Source."Nov 2002"') ,
 "Dec 2002" int SET("ui_mapping_text"='E2E_SBO_Source."Dec 2002"') ,
 "Jan 2003" int SET("ui_mapping_text"='E2E_SBO_Source."Jan 2003"') ,
 "Feb 2003" int SET("ui_mapping_text"='E2E_SBO_Source."Feb 2003"') ,
 "Mar 2003" int SET("ui_mapping_text"='E2E_SBO_Source."Mar 2003"') ,
 "Apr 2003" int SET("ui_mapping_text"='E2E_SBO_Source."Apr 2003"') ,
 "May 2003" int SET("ui_mapping_text"='E2E_SBO_Source."May 2003"') ,
 "Jun 2003" int SET("ui_mapping_text"='E2E_SBO_Source."Jun 2003"') ,
 "Jul 2003" int SET("ui_mapping_text"='E2E_SBO_Source."Jul 2003"') ,
 "Aug 2003" int SET("ui_mapping_text"='E2E_SBO_Source."Aug 2003"') ,
 "Sep 2003" int SET("ui_mapping_text"='E2E_SBO_Source."Sep 2003"') ,
 "Oct 2003" int SET("ui_mapping_text"='E2E_SBO_Source."Oct 2003"') ,
 "Nov 2003" int SET("ui_mapping_text"='E2E_SBO_Source."Nov 2003"') ,
 "Dec 2003" int SET("ui_mapping_text"='E2E_SBO_Source."Dec 2003"') ,
 "Jan 2004" int SET("ui_mapping_text"='E2E_SBO_Source."Jan 2004"') ,
 "Feb 2004" int SET("ui_mapping_text"='E2E_SBO_Source."Feb 2004"') ,
 "Mar 2004" int SET("ui_mapping_text"='E2E_SBO_Source."Mar 2004"') ,
 "Apr 2004" int SET("ui_mapping_text"='E2E_SBO_Source."Apr 2004"') ,
 "May 2004" int SET("ui_mapping_text"='E2E_SBO_Source."May 2004"') ,
 "Jun 2004" int SET("ui_mapping_text"='E2E_SBO_Source."Jun 2004"') ,
 "Jul 2004" int SET("ui_mapping_text"='E2E_SBO_Source."Jul 2004"') ,
 "Aug 2004" int SET("ui_mapping_text"='E2E_SBO_Source."Aug 2004"') ,
 "Sep 2004" int SET("ui_mapping_text"='E2E_SBO_Source."Sep 2004"') ,
 "Oct 2004" int SET("ui_mapping_text"='E2E_SBO_Source."Oct 2004"') ,
 "Nov 2004" int SET("ui_mapping_text"='E2E_SBO_Source."Nov 2004"') ,
 "Dec 2004" int SET("ui_mapping_text"='E2E_SBO_Source."Dec 2004"') ,
 "Jan 2005" int SET("ui_mapping_text"='E2E_SBO_Source."Jan 2005"') ,
 "Feb 2005" int SET("ui_mapping_text"='E2E_SBO_Source."Feb 2005"') ,
 "Mar 2005" int SET("ui_mapping_text"='E2E_SBO_Source."Mar 2005"') ,
 "Apr 2005" int SET("ui_mapping_text"='E2E_SBO_Source."Apr 2005"') ,
 "May 2005" int SET("ui_mapping_text"='E2E_SBO_Source."May 2005"') ,
 "Jun 2005" int SET("ui_mapping_text"='E2E_SBO_Source."Jun 2005"') ,
 "Jul 2005" int SET("ui_mapping_text"='E2E_SBO_Source."Jul 2005"') ,
 "Aug 2005" int SET("ui_mapping_text"='E2E_SBO_Source."Aug 2005"') ,
 "Sep 2005" int SET("ui_mapping_text"='E2E_SBO_Source."Sep 2005"') ,
 "Oct 2005" int SET("ui_mapping_text"='E2E_SBO_Source."Oct 2005"') ,
 "Nov 2005" int SET("ui_mapping_text"='E2E_SBO_Source."Nov 2005"') ,
 "Dec 2005" int SET("ui_mapping_text"='E2E_SBO_Source."Dec 2005"') ,
 "Jan 2006" int SET("ui_mapping_text"='E2E_SBO_Source."Jan 2006"') ,
 "Feb 2006" int SET("ui_mapping_text"='E2E_SBO_Source."Feb 2006"') ,
 "Mar 2006" int SET("ui_mapping_text"='E2E_SBO_Source."Mar 2006"') ,
 "Apr 2006" int SET("ui_mapping_text"='E2E_SBO_Source."Apr 2006"') ,
 "May 2006" int SET("ui_mapping_text"='E2E_SBO_Source."May 2006"') ,
 "Jun 2006" int SET("ui_mapping_text"='E2E_SBO_Source."Jun 2006"') ,
 "Jul 2006" int SET("ui_mapping_text"='E2E_SBO_Source."Jul 2006"') ,
 "Aug 2006" int SET("ui_mapping_text"='E2E_SBO_Source."Aug 2006"') ,
 "Sep 2006" int SET("ui_mapping_text"='E2E_SBO_Source."Sep 2006"') ,
 "Oct 2006" int SET("ui_mapping_text"='E2E_SBO_Source."Oct 2006"') ,
 "Nov 2006" int SET("ui_mapping_text"='E2E_SBO_Source."Nov 2006"') ,
 "Dec 2006" int SET("ui_mapping_text"='E2E_SBO_Source."Dec 2006"') ,
 "Jan 2007" int SET("ui_mapping_text"='E2E_SBO_Source."Jan 2007"') ,
 "Feb 2007" int SET("ui_mapping_text"='E2E_SBO_Source."Feb 2007"') ,
 "Mar 2007" int SET("ui_mapping_text"='E2E_SBO_Source."Mar 2007"') ,
 "Apr 2007" int SET("ui_mapping_text"='E2E_SBO_Source."Apr 2007"') ,
 "May 2007" int SET("ui_mapping_text"='E2E_SBO_Source."May 2007"') ,
 "Jun 2007" int SET("ui_mapping_text"='E2E_SBO_Source."Jun 2007"') ,
 "Jul 2007" int SET("ui_mapping_text"='E2E_SBO_Source."Jul 2007"') ,
 "Aug 2007" int SET("ui_mapping_text"='E2E_SBO_Source."Aug 2007"') ,
 "Sep 2007" int SET("ui_mapping_text"='E2E_SBO_Source."Sep 2007"') ,
 "Oct 2007" int SET("ui_mapping_text"='E2E_SBO_Source."Oct 2007"') ,
 "Nov 2007" int SET("ui_mapping_text"='E2E_SBO_Source."Nov 2007"') ,
 "Dec 2007" int SET("ui_mapping_text"='E2E_SBO_Source."Dec 2007"') ,
 "Jan 2008" int SET("ui_mapping_text"='E2E_SBO_Source."Jan 2008"') ,
 "Feb 2008" int SET("ui_mapping_text"='E2E_SBO_Source."Feb 2008"') ,
 "Mar 2008" int SET("ui_mapping_text"='E2E_SBO_Source."Mar 2008"') ,
 "Apr 2008" int SET("ui_mapping_text"='E2E_SBO_Source."Apr 2008"') ,
 "May 2008" int SET("ui_mapping_text"='E2E_SBO_Source."May 2008"') ,
 "Jun 2008" int SET("ui_mapping_text"='E2E_SBO_Source."Jun 2008"') ,
 "Jul 2008" int SET("ui_mapping_text"='E2E_SBO_Source."Jul 2008"') ,
 "Aug 2008" int SET("ui_mapping_text"='E2E_SBO_Source."Aug 2008"') ,
 "Sep 2008" int SET("ui_mapping_text"='E2E_SBO_Source."Sep 2008"') ,
 "Oct 2008" int SET("ui_mapping_text"='E2E_SBO_Source."Oct 2008"') ,
 "Nov 2008" int SET("ui_mapping_text"='E2E_SBO_Source."Nov 2008"') ,
 "Dec 2008" int SET("ui_mapping_text"='E2E_SBO_Source."Dec 2008"')  ) 
AS SELECT  E2E_SBO_Source.LGA
 
 ,
 E2E_SBO_Source."Offence category"
 
 ,
 E2E_SBO_Source.Subcategory
 
 ,
 E2E_SBO_Source."Jan 1995"
 
 ,
 E2E_SBO_Source."Feb 1995"
 
 ,
 E2E_SBO_Source."Mar 1995"
 
 ,
 E2E_SBO_Source."Apr 1995"
 
 ,
 E2E_SBO_Source."May 1995"
 
 ,
 E2E_SBO_Source."Jun 1995"
 
 ,
 E2E_SBO_Source."Jul 1995"
 
 ,
 E2E_SBO_Source."Aug 1995"
 
 ,
 E2E_SBO_Source."Sep 1995"
 
 ,
 E2E_SBO_Source."Oct 1995"
 
 ,
 E2E_SBO_Source."Nov 1995"
 
 ,
 E2E_SBO_Source."Dec 1995"
 
 ,
 E2E_SBO_Source."Jan 1996"
 
 ,
 E2E_SBO_Source."Feb 1996"
 
 ,
 E2E_SBO_Source."Mar 1996"
 
 ,
 E2E_SBO_Source."Apr 1996"
 
 ,
 E2E_SBO_Source."May 1996"
 
 ,
 E2E_SBO_Source."Jun 1996"
 
 ,
 E2E_SBO_Source."Jul 1996"
 
 ,
 E2E_SBO_Source."Aug 1996"
 
 ,
 E2E_SBO_Source."Sep 1996"
 
 ,
 E2E_SBO_Source."Oct 1996"
 
 ,
 E2E_SBO_Source."Nov 1996"
 
 ,
 E2E_SBO_Source."Dec 1996"
 
 ,
 E2E_SBO_Source."Jan 1997"
 
 ,
 E2E_SBO_Source."Feb 1997"
 
 ,
 E2E_SBO_Source."Mar 1997"
 
 ,
 E2E_SBO_Source."Apr 1997"
 
 ,
 E2E_SBO_Source."May 1997"
 
 ,
 E2E_SBO_Source."Jun 1997"
 
 ,
 E2E_SBO_Source."Jul 1997"
 
 ,
 E2E_SBO_Source."Aug 1997"
 
 ,
 E2E_SBO_Source."Sep 1997"
 
 ,
 E2E_SBO_Source."Oct 1997"
 
 ,
 E2E_SBO_Source."Nov 1997"
 
 ,
 E2E_SBO_Source."Dec 1997"
 
 ,
 E2E_SBO_Source."Jan 1998"
 
 ,
 E2E_SBO_Source."Feb 1998"
 
 ,
 E2E_SBO_Source."Mar 1998"
 
 ,
 E2E_SBO_Source."Apr 1998"
 
 ,
 E2E_SBO_Source."May 1998"
 
 ,
 E2E_SBO_Source."Jun 1998"
 
 ,
 E2E_SBO_Source."Jul 1998"
 
 ,
 E2E_SBO_Source."Aug 1998"
 
 ,
 E2E_SBO_Source."Sep 1998"
 
 ,
 E2E_SBO_Source."Oct 1998"
 
 ,
 E2E_SBO_Source."Nov 1998"
 
 ,
 E2E_SBO_Source."Dec 1998"
 
 ,
 E2E_SBO_Source."Jan 1999"
 
 ,
 E2E_SBO_Source."Feb 1999"
 
 ,
 E2E_SBO_Source."Mar 1999"
 
 ,
 E2E_SBO_Source."Apr 1999"
 
 ,
 E2E_SBO_Source."May 1999"
 
 ,
 E2E_SBO_Source."Jun 1999"
 
 ,
 E2E_SBO_Source."Jul 1999"
 
 ,
 E2E_SBO_Source."Aug 1999"
 
 ,
 E2E_SBO_Source."Sep 1999"
 
 ,
 E2E_SBO_Source."Oct 1999"
 
 ,
 E2E_SBO_Source."Nov 1999"
 
 ,
 E2E_SBO_Source."Dec 1999"
 
 ,
 E2E_SBO_Source."Jan 2000"
 
 ,
 E2E_SBO_Source."Feb 2000"
 
 ,
 E2E_SBO_Source."Mar 2000"
 
 ,
 E2E_SBO_Source."Apr 2000"
 
 ,
 E2E_SBO_Source."May 2000"
 
 ,
 E2E_SBO_Source."Jun 2000"
 
 ,
 E2E_SBO_Source."Jul 2000"
 
 ,
 E2E_SBO_Source."Aug 2000"
 
 ,
 E2E_SBO_Source."Sep 2000"
 
 ,
 E2E_SBO_Source."Oct 2000"
 
 ,
 E2E_SBO_Source."Nov 2000"
 
 ,
 E2E_SBO_Source."Dec 2000"
 
 ,
 E2E_SBO_Source."Jan 2001"
 
 ,
 E2E_SBO_Source."Feb 2001"
 
 ,
 E2E_SBO_Source."Mar 2001"
 
 ,
 E2E_SBO_Source."Apr 2001"
 
 ,
 E2E_SBO_Source."May 2001"
 
 ,
 E2E_SBO_Source."Jun 2001"
 
 ,
 E2E_SBO_Source."Jul 2001"
 
 ,
 E2E_SBO_Source."Aug 2001"
 
 ,
 E2E_SBO_Source."Sep 2001"
 
 ,
 E2E_SBO_Source."Oct 2001"
 
 ,
 E2E_SBO_Source."Nov 2001"
 
 ,
 E2E_SBO_Source."Dec 2001"
 
 ,
 E2E_SBO_Source."Jan 2002"
 
 ,
 E2E_SBO_Source."Feb 2002"
 
 ,
 E2E_SBO_Source."Mar 2002"
 
 ,
 E2E_SBO_Source."Apr 2002"
 
 ,
 E2E_SBO_Source."May 2002"
 
 ,
 E2E_SBO_Source."Jun 2002"
 
 ,
 E2E_SBO_Source."Jul 2002"
 
 ,
 E2E_SBO_Source."Aug 2002"
 
 ,
 E2E_SBO_Source."Sep 2002"
 
 ,
 E2E_SBO_Source."Oct 2002"
 
 ,
 E2E_SBO_Source."Nov 2002"
 
 ,
 E2E_SBO_Source."Dec 2002"
 
 ,
 E2E_SBO_Source."Jan 2003"
 
 ,
 E2E_SBO_Source."Feb 2003"
 
 ,
 E2E_SBO_Source."Mar 2003"
 
 ,
 E2E_SBO_Source."Apr 2003"
 
 ,
 E2E_SBO_Source."May 2003"
 
 ,
 E2E_SBO_Source."Jun 2003"
 
 ,
 E2E_SBO_Source."Jul 2003"
 
 ,
 E2E_SBO_Source."Aug 2003"
 
 ,
 E2E_SBO_Source."Sep 2003"
 
 ,
 E2E_SBO_Source."Oct 2003"
 
 ,
 E2E_SBO_Source."Nov 2003"
 
 ,
 E2E_SBO_Source."Dec 2003"
 
 ,
 E2E_SBO_Source."Jan 2004"
 
 ,
 E2E_SBO_Source."Feb 2004"
 
 ,
 E2E_SBO_Source."Mar 2004"
 
 ,
 E2E_SBO_Source."Apr 2004"
 
 ,
 E2E_SBO_Source."May 2004"
 
 ,
 E2E_SBO_Source."Jun 2004"
 
 ,
 E2E_SBO_Source."Jul 2004"
 
 ,
 E2E_SBO_Source."Aug 2004"
 
 ,
 E2E_SBO_Source."Sep 2004"
 
 ,
 E2E_SBO_Source."Oct 2004"
 
 ,
 E2E_SBO_Source."Nov 2004"
 
 ,
 E2E_SBO_Source."Dec 2004"
 
 ,
 E2E_SBO_Source."Jan 2005"
 
 ,
 E2E_SBO_Source."Feb 2005"
 
 ,
 E2E_SBO_Source."Mar 2005"
 
 ,
 E2E_SBO_Source."Apr 2005"
 
 ,
 E2E_SBO_Source."May 2005"
 
 ,
 E2E_SBO_Source."Jun 2005"
 
 ,
 E2E_SBO_Source."Jul 2005"
 
 ,
 E2E_SBO_Source."Aug 2005"
 
 ,
 E2E_SBO_Source."Sep 2005"
 
 ,
 E2E_SBO_Source."Oct 2005"
 
 ,
 E2E_SBO_Source."Nov 2005"
 
 ,
 E2E_SBO_Source."Dec 2005"
 
 ,
 E2E_SBO_Source."Jan 2006"
 
 ,
 E2E_SBO_Source."Feb 2006"
 
 ,
 E2E_SBO_Source."Mar 2006"
 
 ,
 E2E_SBO_Source."Apr 2006"
 
 ,
 E2E_SBO_Source."May 2006"
 
 ,
 E2E_SBO_Source."Jun 2006"
 
 ,
 E2E_SBO_Source."Jul 2006"
 
 ,
 E2E_SBO_Source."Aug 2006"
 
 ,
 E2E_SBO_Source."Sep 2006"
 
 ,
 E2E_SBO_Source."Oct 2006"
 
 ,
 E2E_SBO_Source."Nov 2006"
 
 ,
 E2E_SBO_Source."Dec 2006"
 
 ,
 E2E_SBO_Source."Jan 2007"
 
 ,
 E2E_SBO_Source."Feb 2007"
 
 ,
 E2E_SBO_Source."Mar 2007"
 
 ,
 E2E_SBO_Source."Apr 2007"
 
 ,
 E2E_SBO_Source."May 2007"
 
 ,
 E2E_SBO_Source."Jun 2007"
 
 ,
 E2E_SBO_Source."Jul 2007"
 
 ,
 E2E_SBO_Source."Aug 2007"
 
 ,
 E2E_SBO_Source."Sep 2007"
 
 ,
 E2E_SBO_Source."Oct 2007"
 
 ,
 E2E_SBO_Source."Nov 2007"
 
 ,
 E2E_SBO_Source."Dec 2007"
 
 ,
 E2E_SBO_Source."Jan 2008"
 
 ,
 E2E_SBO_Source."Feb 2008"
 
 ,
 E2E_SBO_Source."Mar 2008"
 
 ,
 E2E_SBO_Source."Apr 2008"
 
 ,
 E2E_SBO_Source."May 2008"
 
 ,
 E2E_SBO_Source."Jun 2008"
 
 ,
 E2E_SBO_Source."Jul 2008"
 
 ,
 E2E_SBO_Source."Aug 2008"
 
 ,
 E2E_SBO_Source."Sep 2008"
 
 ,
 E2E_SBO_Source."Oct 2008"
 
 ,
 E2E_SBO_Source."Nov 2008"
 
 ,
 E2E_SBO_Source."Dec 2008"
 
 
	FROM E2E_SBO_Source SET (
"distinct_run_as_separate_process" = 'no',
"group_by_run_as_separate_process" = 'no',
"join_run_as_separate_process" = 'no',
"order_by_run_as_separate_process" = 'no',
"run_as_separate_process" = 'no');
ALGUICOMMENT( x = '944', y = '-497' , ui_display_name = 'STG_SOURCE(DEMO_E2E_SBO.DBO)',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>438</CX><CY>-183</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = '', UI_PASSTHRU_VSPLIT_PCT = '50' )
GUID::'a2081862-ee46-4dc5-bb77-483e3f11566c' LOAD TABLE DEMO_E2E_SBO.DBO.STG_SOURCE  INPUT ( Query ) SET (
"LDRLiveLoad" = 'no',
"Table_Type" = 'TABLE',
"connection_port" = 'no',
"ldr_configuration_enabled" = 'yes',
"ldr_configurations" = '<?xml version="1.0" encoding="UTF-8"?>
<LDRConfigurations>
<LDRConfiguration database_type="Microsoft_SQL_Server" database_version="Microsoft SQL Server 2008">
<auto_correct_using_merge>Yes</auto_correct_using_merge>
<bulk_ldr_all_rows></bulk_ldr_all_rows>
<bulk_ldr_max_errors></bulk_ldr_max_errors>
<bulk_ldr_rows_per_commit></bulk_ldr_rows_per_commit>
<enable_partitioning>no</enable_partitioning>
<ignore_column_case>yes</ignore_column_case>
<ignore_columns_null>No</ignore_columns_null>
<ignore_columns_value></ignore_columns_value>
<loader_auto_correct>no</loader_auto_correct>
<loader_bulk_load>0</loader_bulk_load>
<loader_compare_column>compare_by_name</loader_compare_column>
<loader_delete_map></loader_delete_map>
<loader_drop_and_create_table>no</loader_drop_and_create_table>
<loader_insert_map></loader_insert_map>
<loader_load_choice>replace</loader_load_choice>
<loader_num_parallel_loaders>1</loader_num_parallel_loaders>
<loader_overflow_file>DEMO_E2E_SBO_DBO_STG_SOURCE.txt</loader_overflow_file>
<loader_post_load1></loader_post_load1>
<loader_pre_load1></loader_pre_load1>
<loader_quote_names>0</loader_quote_names>
<loader_transactional>no</loader_transactional>
<loader_transactional_order>0</loader_transactional_order>
<loader_update_key_columns>no</loader_update_key_columns>
<loader_update_map></loader_update_map>
<loader_use_user_defined_keys>no</loader_use_user_defined_keys>
<loader_xact_size>1000</loader_xact_size>
<mssql_bulk_ldr_mode>append</mssql_bulk_ldr_mode>
<mssql_bulk_ldr_packet_size>4</mssql_bulk_ldr_packet_size>
<overflow_file_format>Write data</overflow_file_format>
<use_overflow_file>no</use_overflow_file>
<use_unicode_varchar>no</use_unicode_varchar>
<sql_text></sql_text>
</LDRConfiguration>
</LDRConfigurations>',
"loader_template_table" = 'no',
"name" = 'DEMO_E2E_SBO',
"use_unicode_varchar" = 'no');
END

SET("Cache_type" = 'pageable_cache',
"Parallelism_degree" = '0',
"allows_both_input_and_output" = 'yes',
"run_once" = 'no',
"use_dataflow_links" = 'no',
"use_datastore_links" = 'yes',
"validation_xform_exists" = 'no',
"validation_xform_stats" = 'no')
ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Mon Apr 12 17:01:10 2010' , "ActaName_3" = 'Rcolumn_mapping_calculated' , "ActaValue_3" = 'yes' , "ActaName_4" = 'RDate_modified' , "ActaValue_4" = 'Sun May 30 11:16:49 2010' )
CREATE DATAFLOW DF_E2E_Dim_Date::'6f593a0e-6d50-4db6-a927-c2c879c5bb70'

BEGIN 
ALGUICOMMENT( x = '122', y = '-131',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>263</CX><CY>-164</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = '' )
GUID::'54fd323c-086c-4156-9d97-a91f1efef1e9' CALL TRANSFORM Date_Generation ( ) 
OUTPUT ( Date_Generation ( DI_GENERATED_DATE date SET("Description"='The date is automatically generated by the Date_Generation transform', "Content_Type"='DATE')  )  )
SET ("cache" = 'no',
"end_date" = '2008.12.31',
"increment" = 'monthly',
"start_date" = '1995.01.01',
"table_weight" = '0');
ALGUICOMMENT( x = '472', y = '-331' , ui_acta_from_schema_0 = 'Date_Generation' ,UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>238</CX><CY>-164</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Output_Width_Name = '121', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name', UI_PASSTHRU_VSPLIT_PCT = '50' )
GUID::'e5631345-6363-4b7b-b4c9-0ba9c633bceb' CREATE VIEW Query ( Date_SK int KEY  SET("ui_mapping_text"='julian(Date_Generation.DI_GENERATED_DATE)') ,
 Year int SET("ui_mapping_text"='year(Date_Generation.DI_GENERATED_DATE)') ,
 Quarter int SET("ui_mapping_text"='quarter(Date_Generation.DI_GENERATED_DATE)') ,
 Month int SET("ui_mapping_text"='month(Date_Generation.DI_GENERATED_DATE)') ,
 "Date" date SET("Description"='The date is automatically generated by the Date_Generation transform', "ui_mapping_text"='Date_Generation.DI_GENERATED_DATE', "Content_Type"='DATE')  ) 
AS SELECT  julian(Date_Generation.DI_GENERATED_DATE)
 
 ,
 year(Date_Generation.DI_GENERATED_DATE)
 
 ,
 quarter(Date_Generation.DI_GENERATED_DATE)
 
 ,
 month(Date_Generation.DI_GENERATED_DATE)
 
 ,
 Date_Generation.DI_GENERATED_DATE
 
 
	FROM Date_Generation SET (
"distinct_run_as_separate_process" = 'no',
"group_by_run_as_separate_process" = 'no',
"join_run_as_separate_process" = 'no',
"order_by_run_as_separate_process" = 'no',
"run_as_separate_process" = 'no');
ALGUICOMMENT( x = '869', y = '-506' , ui_display_name = 'DIM_DATE(DEMO_E2E_SBO.DBO)',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>416</CX><CY>-183</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = '', UI_PASSTHRU_VSPLIT_PCT = '50' )
GUID::'37fa22e4-12ba-45ab-83c0-62569eddfb8c' LOAD TABLE DEMO_E2E_SBO.DBO.DIM_DATE  INPUT ( Query ) SET (
"LDRLiveLoad" = 'no',
"Table_Type" = 'TABLE',
"connection_port" = 'no',
"ldr_configuration_enabled" = 'yes',
"ldr_configurations" = '<?xml version="1.0" encoding="UTF-8"?>
<LDRConfigurations>
<LDRConfiguration database_type="Microsoft_SQL_Server" database_version="Microsoft SQL Server 2008">
<auto_correct_using_merge>Yes</auto_correct_using_merge>
<bulk_ldr_all_rows></bulk_ldr_all_rows>
<bulk_ldr_max_errors></bulk_ldr_max_errors>
<bulk_ldr_rows_per_commit>1000</bulk_ldr_rows_per_commit>
<enable_partitioning>no</enable_partitioning>
<ignore_column_case>yes</ignore_column_case>
<ignore_columns_null>No</ignore_columns_null>
<ignore_columns_value></ignore_columns_value>
<loader_auto_correct>no</loader_auto_correct>
<loader_bulk_load></loader_bulk_load>
<loader_compare_column>compare_by_name</loader_compare_column>
<loader_delete_map></loader_delete_map>
<loader_drop_and_create_table>no</loader_drop_and_create_table>
<loader_insert_map></loader_insert_map>
<loader_load_choice>replace</loader_load_choice>
<loader_num_parallel_loaders>1</loader_num_parallel_loaders>
<loader_overflow_file>DEMO_E2E_SBO_DBO_DIM_DATE.txt</loader_overflow_file>
<loader_post_load1></loader_post_load1>
<loader_pre_load1></loader_pre_load1>
<loader_quote_names>0</loader_quote_names>
<loader_transactional>no</loader_transactional>
<loader_transactional_order>0</loader_transactional_order>
<loader_update_key_columns>no</loader_update_key_columns>
<loader_update_map></loader_update_map>
<loader_use_user_defined_keys>no</loader_use_user_defined_keys>
<loader_xact_size>1000</loader_xact_size>
<mssql_bulk_ldr_mode>append</mssql_bulk_ldr_mode>
<mssql_bulk_ldr_packet_size>0</mssql_bulk_ldr_packet_size>
<overflow_file_format>Write data</overflow_file_format>
<use_overflow_file>no</use_overflow_file>
<use_unicode_varchar>no</use_unicode_varchar>
<sql_text></sql_text>
</LDRConfiguration>
</LDRConfigurations>',
"loader_template_table" = 'no',
"name" = 'DEMO_E2E_SBO',
"use_unicode_varchar" = 'no');
END

SET("Cache_type" = 'pageable_cache',
"Parallelism_degree" = '0',
"allows_both_input_and_output" = 'yes',
"run_once" = 'no',
"use_dataflow_links" = 'no',
"use_datastore_links" = 'yes',
"validation_xform_exists" = 'no',
"validation_xform_stats" = 'no')
ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Mon Apr 12 16:56:21 2010' , "ActaName_3" = 'Rcolumn_mapping_calculated' , "ActaValue_3" = 'yes' , "ActaName_4" = 'RDate_modified' , "ActaValue_4" = 'Sun May 30 11:16:49 2010' )
CREATE DATAFLOW DF_E2E_Dim_LGA::'6c9cfbdd-c297-4eeb-8c9f-5ebf64ec7620'

BEGIN 
ALGUICOMMENT( x = '175', y = '-134',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>394</CX><CY>-183</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name' )
GUID::'f5b4f738-250e-48b2-b71d-8ecc201f2aae' READ TABLE DEMO_E2E_SBO.DBO.STG_SOURCE  OUTPUT ( STG_SOURCE ) SET (
"array_fetch_size" = '1000',
"cache" = 'yes',
"connection_port" = 'no',
"enable_partitioning" = 'no',
"name" = 'DEMO_E2E_SBO',
"package_size" = '0',
"reader_is_DB2CDC_table" = 'no',
"reader_overflow_file" = 'overflow_file',
"reader_template_table" = 'no',
"reader_use_overflow_file" = 'no',
"reader_use_trex_transaction" = 'no',
"table_weight" = '0');
ALGUICOMMENT( x = '500', y = '-350' , ui_acta_from_schema_0 = 'STG_SOURCE' ,UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>238</CX><CY>-164</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Output_Width_Name = '127', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name', UI_PASSTHRU_VSPLIT_PCT = '50' )
GUID::'4f07ae53-4272-41c7-9387-b3e7df2b1e6c' CREATE VIEW Query ( LGA_SK int KEY  SET("ui_mapping_text"='gen_row_num( )
 
') ,
 State_Region varchar(100) SET("ui_mapping_text"='\'\'') ,
 Local_Government_Authority varchar(100) SET("ui_mapping_text"='STG_SOURCE.LGA
 
')  ) 
AS SELECT  gen_row_num( )
 
 ,
 ''
 
 ,
 STG_SOURCE.LGA
 
 
	FROM STG_SOURCE GROUP BY  STG_SOURCE.LGA SET (
"distinct_run_as_separate_process" = 'no',
"group_by_run_as_separate_process" = 'no',
"join_run_as_separate_process" = 'no',
"order_by_run_as_separate_process" = 'no',
"run_as_separate_process" = 'no');
ALGUICOMMENT( x = '847', y = '-525' , ui_acta_from_schema_0 = 'E2E_Region_LGAs'  , ui_acta_from_schema_1 = 'Query'  , ui_where_text = 'Query.Local_Government_Authority = E2E_Region_LGAs.LGA' ,UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>238</CX><CY>-164</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Input_Width_Name = '143', Output_Width_Name = '120', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name', UI_PASSTHRU_VSPLIT_PCT = '50' )
GUID::'3a642055-1811-4dbe-9d93-d8f89e08ecb6' CREATE VIEW Query_1 ( LGA_SK int KEY  SET("ui_mapping_text"='Query.LGA_SK') ,
 State_Region varchar(100) SET("ui_mapping_text"='E2E_Region_LGAs.Region') ,
 Local_Government_Authority varchar(100) SET("ui_mapping_text"='Query.Local_Government_Authority')  ) 
AS SELECT  Query.LGA_SK
 
 ,
 E2E_Region_LGAs.Region
 
 ,
 Query.Local_Government_Authority
 
 
	FROM Query, E2E_Region_LGAs
	WHERE Query.Local_Government_Authority = E2E_Region_LGAs.LGA
 
 SET (
"distinct_run_as_separate_process" = 'no',
"group_by_run_as_separate_process" = 'no',
"join_run_as_separate_process" = 'no',
"order_by_run_as_separate_process" = 'no',
"run_as_separate_process" = 'no');
ALGUICOMMENT( x = '522', y = '-731' , ui_display_name = '"Regions and LGAs.csv"(E2E_Region_LGAs)',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>334</CX><CY>-183</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Description', Input_2nd_Column_Name = 'Type', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = '' )
GUID::'c4a279d5-bdc4-4068-a13b-fc3d3ba7ac83' READ FILE E2E_Region_LGAs."Regions and LGAs.csv"  OUTPUT ( E2E_Region_LGAs ) SET (
"adaptable" = 'no',
"cache" = 'yes',
"connection_port" = 'no',
"file_location" = 'local',
"name" = 'E2E_Region_LGAs',
"reader_capture_data_conversion_errors" = 'no',
"reader_capture_row_format_errors" = 'yes',
"reader_filename_col" = 'DI_FILENAME',
"reader_filename_col_size" = '100',
"reader_filename_only" = 'no',
"reader_include_filename" = 'no',
"reader_log_data_conversion_warnings" = 'yes',
"reader_log_row_format_warnings" = 'yes',
"reader_maximum_warnings_to_log" = '-99',
"reader_write_error_rows_to_file" = 'no',
"root_dir" = 'C:\\Users\\josh.fletcher\\Desktop\\E2E SBO',
"table_weight" = '0',
"transfer_custom" = 'no');
ALGUICOMMENT( x = '1231', y = '-688' , ui_display_name = 'DIM_LGA(DEMO_E2E_SBO.DBO)',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>419</CX><CY>-183</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = '', UI_PASSTHRU_VSPLIT_PCT = '50' )
GUID::'2359e8d6-0afd-400a-9c90-3c6118d67454' LOAD TABLE DEMO_E2E_SBO.DBO.DIM_LGA  INPUT ( Query_1 ) SET (
"LDRLiveLoad" = 'no',
"Table_Type" = 'TABLE',
"connection_port" = 'no',
"ldr_configuration_enabled" = 'yes',
"ldr_configurations" = '<?xml version="1.0" encoding="UTF-8"?>
<LDRConfigurations>
<LDRConfiguration database_type="Microsoft_SQL_Server" database_version="Microsoft SQL Server 2008">
<auto_correct_using_merge>Yes</auto_correct_using_merge>
<bulk_ldr_all_rows></bulk_ldr_all_rows>
<bulk_ldr_max_errors></bulk_ldr_max_errors>
<bulk_ldr_rows_per_commit>1000</bulk_ldr_rows_per_commit>
<enable_partitioning>no</enable_partitioning>
<ignore_column_case>yes</ignore_column_case>
<ignore_columns_null>No</ignore_columns_null>
<ignore_columns_value></ignore_columns_value>
<loader_auto_correct>no</loader_auto_correct>
<loader_bulk_load></loader_bulk_load>
<loader_compare_column>compare_by_name</loader_compare_column>
<loader_delete_map></loader_delete_map>
<loader_drop_and_create_table>no</loader_drop_and_create_table>
<loader_insert_map></loader_insert_map>
<loader_load_choice>replace</loader_load_choice>
<loader_num_parallel_loaders>1</loader_num_parallel_loaders>
<loader_overflow_file>DEMO_E2E_SBO_DBO_DIM_LGA.txt</loader_overflow_file>
<loader_post_load1></loader_post_load1>
<loader_pre_load1></loader_pre_load1>
<loader_quote_names>0</loader_quote_names>
<loader_transactional>no</loader_transactional>
<loader_transactional_order>0</loader_transactional_order>
<loader_update_key_columns>no</loader_update_key_columns>
<loader_update_map></loader_update_map>
<loader_use_user_defined_keys>no</loader_use_user_defined_keys>
<loader_xact_size>1000</loader_xact_size>
<mssql_bulk_ldr_mode>append</mssql_bulk_ldr_mode>
<mssql_bulk_ldr_packet_size>0</mssql_bulk_ldr_packet_size>
<overflow_file_format>Write data</overflow_file_format>
<use_overflow_file>no</use_overflow_file>
<use_unicode_varchar>no</use_unicode_varchar>
<sql_text></sql_text>
</LDRConfiguration>
</LDRConfigurations>',
"loader_template_table" = 'no',
"name" = 'DEMO_E2E_SBO',
"use_unicode_varchar" = 'no');
END

SET("Cache_type" = 'pageable_cache',
"Parallelism_degree" = '0',
"allows_both_input_and_output" = 'yes',
"run_once" = 'no',
"use_dataflow_links" = 'no',
"use_datastore_links" = 'yes',
"validation_xform_exists" = 'no',
"validation_xform_stats" = 'no')
ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Mon Apr 12 16:56:22 2010' , "ActaName_3" = 'Rcolumn_mapping_calculated' , "ActaValue_3" = 'yes' , "ActaName_4" = 'RDate_modified' , "ActaValue_4" = 'Sun May 30 11:16:49 2010' )
CREATE DATAFLOW DF_E2E_Dim_Offence_Type::'1bd8c800-e9f7-4173-b658-0c44113291a5'

BEGIN 
ALGUICOMMENT( x = '134', y = '-116',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>394</CX><CY>-183</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name' )
GUID::'2ae64fa7-1013-4ef6-8248-1c6a8329eaea' READ TABLE DEMO_E2E_SBO.DBO.STG_SOURCE  OUTPUT ( STG_SOURCE ) SET (
"array_fetch_size" = '1000',
"cache" = 'yes',
"connection_port" = 'no',
"enable_partitioning" = 'no',
"name" = 'DEMO_E2E_SBO',
"package_size" = '0',
"reader_is_DB2CDC_table" = 'no',
"reader_overflow_file" = 'overflow_file',
"reader_template_table" = 'no',
"reader_use_overflow_file" = 'no',
"reader_use_trex_transaction" = 'no',
"table_weight" = '0');
ALGUICOMMENT( x = '466', y = '-350' , ui_acta_from_schema_0 = 'STG_SOURCE' ,UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>238</CX><CY>-164</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Output_Width_Name = '140', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name', UI_PASSTHRU_VSPLIT_PCT = '50' )
GUID::'ce47bf1c-e524-495f-9647-5bde5ecf237d' CREATE VIEW Query ( Offence_Type_SK int KEY  SET("ui_mapping_text"='gen_row_num()
') ,
 Offence_Category varchar(100) SET("ui_mapping_text"='STG_SOURCE."Offence category"') ,
 Offence_Subcategory varchar(100) SET("ui_mapping_text"='nvl(STG_SOURCE.SUBCATEGORY,STG_SOURCE."Offence category")')  ) 
AS SELECT  gen_row_num()
 
 ,
 STG_SOURCE."Offence category"
 
 ,
 nvl(STG_SOURCE.SUBCATEGORY,STG_SOURCE."Offence category")
 
 
	FROM STG_SOURCE GROUP BY  STG_SOURCE."Offence category",  STG_SOURCE.SUBCATEGORY SET (
"distinct_run_as_separate_process" = 'no',
"group_by_run_as_separate_process" = 'no',
"join_run_as_separate_process" = 'no',
"order_by_run_as_separate_process" = 'no',
"run_as_separate_process" = 'no');
ALGUICOMMENT( x = '875', y = '-534' , ui_display_name = 'DIM_OFFENCE_TYPE(DEMO_E2E_SBO.DBO)',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>410</CX><CY>-183</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = '', UI_PASSTHRU_VSPLIT_PCT = '50' )
GUID::'f2b91570-d01f-482e-87bb-78a556ca040e' LOAD TABLE DEMO_E2E_SBO.DBO.DIM_OFFENCE_TYPE  INPUT ( Query ) SET (
"LDRLiveLoad" = 'no',
"Table_Type" = 'TABLE',
"connection_port" = 'no',
"ldr_configuration_enabled" = 'yes',
"ldr_configurations" = '<?xml version="1.0" encoding="UTF-8"?>
<LDRConfigurations>
<LDRConfiguration database_type="Microsoft_SQL_Server" database_version="Microsoft SQL Server 2008">
<auto_correct_using_merge>Yes</auto_correct_using_merge>
<bulk_ldr_all_rows></bulk_ldr_all_rows>
<bulk_ldr_max_errors></bulk_ldr_max_errors>
<bulk_ldr_rows_per_commit>1000</bulk_ldr_rows_per_commit>
<enable_partitioning>no</enable_partitioning>
<ignore_column_case>yes</ignore_column_case>
<ignore_columns_null>No</ignore_columns_null>
<ignore_columns_value></ignore_columns_value>
<loader_auto_correct>no</loader_auto_correct>
<loader_bulk_load></loader_bulk_load>
<loader_compare_column>compare_by_name</loader_compare_column>
<loader_delete_map></loader_delete_map>
<loader_drop_and_create_table>no</loader_drop_and_create_table>
<loader_insert_map></loader_insert_map>
<loader_load_choice>replace</loader_load_choice>
<loader_num_parallel_loaders>1</loader_num_parallel_loaders>
<loader_overflow_file>DEMO_E2E_SBO_DBO_DIM_OFFENCE_TYPE.txt</loader_overflow_file>
<loader_post_load1></loader_post_load1>
<loader_pre_load1></loader_pre_load1>
<loader_quote_names>0</loader_quote_names>
<loader_transactional>no</loader_transactional>
<loader_transactional_order>0</loader_transactional_order>
<loader_update_key_columns>no</loader_update_key_columns>
<loader_update_map></loader_update_map>
<loader_use_user_defined_keys>no</loader_use_user_defined_keys>
<loader_xact_size>1000</loader_xact_size>
<mssql_bulk_ldr_mode>append</mssql_bulk_ldr_mode>
<mssql_bulk_ldr_packet_size>0</mssql_bulk_ldr_packet_size>
<overflow_file_format>Write data</overflow_file_format>
<use_overflow_file>no</use_overflow_file>
<use_unicode_varchar>no</use_unicode_varchar>
<sql_text></sql_text>
</LDRConfiguration>
</LDRConfigurations>',
"loader_template_table" = 'no',
"name" = 'DEMO_E2E_SBO',
"use_unicode_varchar" = 'no');
END

SET("Cache_type" = 'pageable_cache',
"Parallelism_degree" = '0',
"allows_both_input_and_output" = 'yes',
"run_once" = 'no',
"use_dataflow_links" = 'no',
"use_datastore_links" = 'yes',
"validation_xform_exists" = 'no',
"validation_xform_stats" = 'no')
ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Mon Apr 12 17:06:45 2010' , "ActaName_3" = 'Rcolumn_mapping_calculated' , "ActaValue_3" = 'yes' , "ActaName_4" = 'RDate_modified' , "ActaValue_4" = 'Tue Jun 01 05:05:50 2010' )
CREATE DATAFLOW DF_E2E_Fact_Crimes::'3153b63e-872a-47a1-babf-f5ec7aa7b28c'

BEGIN 
ALGUICOMMENT( x = '128', y = '-141',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>394</CX><CY>-183</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name' )
GUID::'e1370ecf-7221-4870-b889-9543af89a354' READ TABLE DEMO_E2E_SBO.DBO.STG_SOURCE  OUTPUT ( STG_SOURCE ) SET (
"array_fetch_size" = '1000',
"cache" = 'yes',
"connection_port" = 'no',
"enable_partitioning" = 'no',
"name" = 'DEMO_E2E_SBO',
"package_size" = '0',
"reader_is_DB2CDC_table" = 'no',
"reader_overflow_file" = 'overflow_file',
"reader_template_table" = 'no',
"reader_use_overflow_file" = 'no',
"reader_use_trex_transaction" = 'no',
"table_weight" = '0');
ALGUICOMMENT( x = '422', y = '-294',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>238</CX><CY>-164</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Output_Width_Name = '169', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '10', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = '' )
GUID::'d59af1c5-85f6-455a-9955-7ee1fb9af157' CALL TRANSFORM Pivot ( ) 
INPUT ( STG_SOURCE )
OUTPUT ( Pivot ( LGA varchar(50),
 "Offence category" varchar(75),
 SUBCATEGORY varchar(75),
 Seq_Number int,
 Month varchar(36),
 Number_of_Crimes int )  )
SET ("nonpivot_column1" = 'LGA',
"nonpivot_column2" = 'Offence category',
"nonpivot_column3" = 'SUBCATEGORY',
"pivot_column1_1" = 'Jan 1995',
"pivot_column1_10" = 'Oct 1995',
"pivot_column1_100" = 'Apr 2003',
"pivot_column1_101" = 'May 2003',
"pivot_column1_102" = 'Jun 2003',
"pivot_column1_103" = 'Jul 2003',
"pivot_column1_104" = 'Aug 2003',
"pivot_column1_105" = 'Sep 2003',
"pivot_column1_106" = 'Oct 2003',
"pivot_column1_107" = 'Nov 2003',
"pivot_column1_108" = 'Dec 2003',
"pivot_column1_109" = 'Jan 2004',
"pivot_column1_11" = 'Nov 1995',
"pivot_column1_110" = 'Feb 2004',
"pivot_column1_111" = 'Mar 2004',
"pivot_column1_112" = 'Apr 2004',
"pivot_column1_113" = 'May 2004',
"pivot_column1_114" = 'Jun 2004',
"pivot_column1_115" = 'Jul 2004',
"pivot_column1_116" = 'Aug 2004',
"pivot_column1_117" = 'Sep 2004',
"pivot_column1_118" = 'Oct 2004',
"pivot_column1_119" = 'Nov 2004',
"pivot_column1_12" = 'Dec 1995',
"pivot_column1_120" = 'Dec 2004',
"pivot_column1_121" = 'Jan 2005',
"pivot_column1_122" = 'Feb 2005',
"pivot_column1_123" = 'Mar 2005',
"pivot_column1_124" = 'Apr 2005',
"pivot_column1_125" = 'May 2005',
"pivot_column1_126" = 'Jun 2005',
"pivot_column1_127" = 'Jul 2005',
"pivot_column1_128" = 'Aug 2005',
"pivot_column1_129" = 'Sep 2005',
"pivot_column1_13" = 'Jan 1996',
"pivot_column1_130" = 'Oct 2005',
"pivot_column1_131" = 'Nov 2005',
"pivot_column1_132" = 'Dec 2005',
"pivot_column1_133" = 'Jan 2006',
"pivot_column1_134" = 'Feb 2006',
"pivot_column1_135" = 'Mar 2006',
"pivot_column1_136" = 'Apr 2006',
"pivot_column1_137" = 'May 2006',
"pivot_column1_138" = 'Jun 2006',
"pivot_column1_139" = 'Jul 2006',
"pivot_column1_14" = 'Feb 1996',
"pivot_column1_140" = 'Aug 2006',
"pivot_column1_141" = 'Sep 2006',
"pivot_column1_142" = 'Oct 2006',
"pivot_column1_143" = 'Nov 2006',
"pivot_column1_144" = 'Dec 2006',
"pivot_column1_145" = 'Jan 2007',
"pivot_column1_146" = 'Feb 2007',
"pivot_column1_147" = 'Mar 2007',
"pivot_column1_148" = 'Apr 2007',
"pivot_column1_149" = 'May 2007',
"pivot_column1_15" = 'Mar 1996',
"pivot_column1_150" = 'Jun 2007',
"pivot_column1_151" = 'Jul 2007',
"pivot_column1_152" = 'Aug 2007',
"pivot_column1_153" = 'Sep 2007',
"pivot_column1_154" = 'Oct 2007',
"pivot_column1_155" = 'Nov 2007',
"pivot_column1_156" = 'Dec 2007',
"pivot_column1_157" = 'Jan 2008',
"pivot_column1_158" = 'Feb 2008',
"pivot_column1_159" = 'Mar 2008',
"pivot_column1_16" = 'Apr 1996',
"pivot_column1_160" = 'Apr 2008',
"pivot_column1_161" = 'May 2008',
"pivot_column1_162" = 'Jun 2008',
"pivot_column1_163" = 'Jul 2008',
"pivot_column1_164" = 'Aug 2008',
"pivot_column1_165" = 'Sep 2008',
"pivot_column1_166" = 'Oct 2008',
"pivot_column1_167" = 'Nov 2008',
"pivot_column1_168" = 'Dec 2008',
"pivot_column1_17" = 'May 1996',
"pivot_column1_18" = 'Jun 1996',
"pivot_column1_19" = 'Jul 1996',
"pivot_column1_2" = 'Feb 1995',
"pivot_column1_20" = 'Aug 1996',
"pivot_column1_21" = 'Sep 1996',
"pivot_column1_22" = 'Oct 1996',
"pivot_column1_23" = 'Nov 1996',
"pivot_column1_24" = 'Dec 1996',
"pivot_column1_25" = 'Jan 1997',
"pivot_column1_26" = 'Feb 1997',
"pivot_column1_27" = 'Mar 1997',
"pivot_column1_28" = 'Apr 1997',
"pivot_column1_29" = 'May 1997',
"pivot_column1_3" = 'Mar 1995',
"pivot_column1_30" = 'Jun 1997',
"pivot_column1_31" = 'Jul 1997',
"pivot_column1_32" = 'Aug 1997',
"pivot_column1_33" = 'Sep 1997',
"pivot_column1_34" = 'Oct 1997',
"pivot_column1_35" = 'Nov 1997',
"pivot_column1_36" = 'Dec 1997',
"pivot_column1_37" = 'Jan 1998',
"pivot_column1_38" = 'Feb 1998',
"pivot_column1_39" = 'Mar 1998',
"pivot_column1_4" = 'Apr 1995',
"pivot_column1_40" = 'Apr 1998',
"pivot_column1_41" = 'May 1998',
"pivot_column1_42" = 'Jun 1998',
"pivot_column1_43" = 'Jul 1998',
"pivot_column1_44" = 'Aug 1998',
"pivot_column1_45" = 'Sep 1998',
"pivot_column1_46" = 'Oct 1998',
"pivot_column1_47" = 'Nov 1998',
"pivot_column1_48" = 'Dec 1998',
"pivot_column1_49" = 'Jan 1999',
"pivot_column1_5" = 'May 1995',
"pivot_column1_50" = 'Feb 1999',
"pivot_column1_51" = 'Mar 1999',
"pivot_column1_52" = 'Apr 1999',
"pivot_column1_53" = 'May 1999',
"pivot_column1_54" = 'Jun 1999',
"pivot_column1_55" = 'Jul 1999',
"pivot_column1_56" = 'Aug 1999',
"pivot_column1_57" = 'Sep 1999',
"pivot_column1_58" = 'Oct 1999',
"pivot_column1_59" = 'Nov 1999',
"pivot_column1_6" = 'Jun 1995',
"pivot_column1_60" = 'Dec 1999',
"pivot_column1_61" = 'Jan 2000',
"pivot_column1_62" = 'Feb 2000',
"pivot_column1_63" = 'Mar 2000',
"pivot_column1_64" = 'Apr 2000',
"pivot_column1_65" = 'May 2000',
"pivot_column1_66" = 'Jun 2000',
"pivot_column1_67" = 'Jul 2000',
"pivot_column1_68" = 'Aug 2000',
"pivot_column1_69" = 'Sep 2000',
"pivot_column1_7" = 'Jul 1995',
"pivot_column1_70" = 'Oct 2000',
"pivot_column1_71" = 'Nov 2000',
"pivot_column1_72" = 'Dec 2000',
"pivot_column1_73" = 'Jan 2001',
"pivot_column1_74" = 'Feb 2001',
"pivot_column1_75" = 'Mar 2001',
"pivot_column1_76" = 'Apr 2001',
"pivot_column1_77" = 'May 2001',
"pivot_column1_78" = 'Jun 2001',
"pivot_column1_79" = 'Jul 2001',
"pivot_column1_8" = 'Aug 1995',
"pivot_column1_80" = 'Aug 2001',
"pivot_column1_81" = 'Sep 2001',
"pivot_column1_82" = 'Oct 2001',
"pivot_column1_83" = 'Nov 2001',
"pivot_column1_84" = 'Dec 2001',
"pivot_column1_85" = 'Jan 2002',
"pivot_column1_86" = 'Feb 2002',
"pivot_column1_87" = 'Mar 2002',
"pivot_column1_88" = 'Apr 2002',
"pivot_column1_89" = 'May 2002',
"pivot_column1_9" = 'Sep 1995',
"pivot_column1_90" = 'Jun 2002',
"pivot_column1_91" = 'Jul 2002',
"pivot_column1_92" = 'Aug 2002',
"pivot_column1_93" = 'Sep 2002',
"pivot_column1_94" = 'Oct 2002',
"pivot_column1_95" = 'Nov 2002',
"pivot_column1_96" = 'Dec 2002',
"pivot_column1_97" = 'Jan 2003',
"pivot_column1_98" = 'Feb 2003',
"pivot_column1_99" = 'Mar 2003',
"pivot_data_field1" = 'Number_of_Crimes',
"pivot_header_name1" = 'Month',
"pivot_sequence_name" = 'Seq_Number',
"total_pivot_groups" = '1');
ALGUICOMMENT( x = '806', y = '-459' , ui_acta_from_schema_0 = 'Pivot' ,UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>238</CX><CY>-164</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '36', Output_Width_Name = '173', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = 'Business_Name', UI_PASSTHRU_VSPLIT_PCT = '50' )
GUID::'98ddb843-a270-4c6f-89ed-22b3621b03a7' CREATE VIEW Query ( Crime_SK int KEY  SET("ui_mapping_text"='gen_row_num( )') ,
 Date_SK int SET("ui_mapping_text"='julian(to_date(\'01 \' || Pivot.Month,\'DD MON YYYY\'))') ,
 LGA_SK int SET("ui_mapping_text"='lookup_ext([DEMO_E2E_SBO.DBO.DIM_LGA,\'PRE_LOAD_CACHE\',\'MAX\'], [LGA_SK],[NULL],[LOCAL_GOVERNMENT_AUTHORITY,\'=\',Pivot.LGA]) SET ("run_as_separate_process"=\'no\', "output_cols_info"=\'<?xml version="1.0" encoding="UTF-8"?><output_cols_info><col index="1" expression="no"/>
</output_cols_info>\' )') ,
 Offence_Type_SK int SET("ui_mapping_text"='lookup_ext([DEMO_E2E_SBO.DBO.DIM_OFFENCE_TYPE,\'PRE_LOAD_CACHE\',\'MAX\'], [OFFENCE_TYPE_SK],[NULL],[OFFENCE_CATEGORY,\'=\',Pivot."Offence category",OFFENCE_SUBCATEGORY,\'=\',Pivot.SUBCATEGORY]) SET ("run_as_separate_process"=\'no\', "output_cols_info"=\'<?xml version="1.0" encoding="UTF-8"?><output_cols_info><col index="1" expression="no"/>
</output_cols_info>\' )') ,
 Number_of_Crimes int SET("ui_mapping_text"='Pivot.Number_of_Crimes')  ) 
AS SELECT  gen_row_num( )
 
 ,
 julian(to_date('01 ' || Pivot.Month,'DD MON YYYY'))
 
 ,
 lookup_ext([DEMO_E2E_SBO.DBO.DIM_LGA,'PRE_LOAD_CACHE','MAX'], [LGA_SK],[NULL],[LOCAL_GOVERNMENT_AUTHORITY,'=',Pivot.LGA]) SET ("run_as_separate_process"='no', "output_cols_info"='<?xml version="1.0" encoding="UTF-8"?><output_cols_info><col index="1" expression="no"/>
</output_cols_info>' )
 
 ,
 lookup_ext([DEMO_E2E_SBO.DBO.DIM_OFFENCE_TYPE,'PRE_LOAD_CACHE','MAX'], [OFFENCE_TYPE_SK],[NULL],[OFFENCE_CATEGORY,'=',Pivot."Offence category",OFFENCE_SUBCATEGORY,'=',Pivot.SUBCATEGORY]) SET ("run_as_separate_process"='no', "output_cols_info"='<?xml version="1.0" encoding="UTF-8"?><output_cols_info><col index="1" expression="no"/>
</output_cols_info>' )
 
 ,
 Pivot.Number_of_Crimes
 
 
	FROM Pivot SET (
"distinct_run_as_separate_process" = 'no',
"group_by_run_as_separate_process" = 'no',
"join_run_as_separate_process" = 'no',
"order_by_run_as_separate_process" = 'no',
"run_as_separate_process" = 'no');
ALGUICOMMENT( x = '1234', y = '-622' , ui_display_name = 'FACT_CRIMES(DEMO_E2E_SBO.DBO)',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>422</CX><CY>-183</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-175</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>', UpperContainer_HeightProp = '50', InputSchema_WidthProp = '50', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '100', Output_Column_Width_4 = '100', Input_Column_Width_4 = '100', Output_Column_Width_5 = '100', Input_1st_Column_Name = 'Type', Input_2nd_Column_Name = 'Description', Input_Column_Name_3 = 'Content_Type', Input_Column_Name_4 = 'Business_Name', Output_1st_Column_Name = 'Type', Output_2nd_Column_Name = 'Mapping', Output_3rd_Column_Name = 'Description', Output_Column_Name_4 = 'Content_Type', Output_Column_Name_5 = '', UI_PASSTHRU_VSPLIT_PCT = '50' )
GUID::'016eab4d-12dd-42c3-9767-37ad05586105' LOAD TABLE DEMO_E2E_SBO.DBO.FACT_CRIMES  INPUT ( Query ) SET (
"LDRLiveLoad" = 'no',
"Table_Type" = 'TABLE',
"connection_port" = 'no',
"ldr_configuration_enabled" = 'yes',
"ldr_configurations" = '<?xml version="1.0" encoding="UTF-8"?>
<LDRConfigurations>
<LDRConfiguration database_type="Microsoft_SQL_Server" database_version="Microsoft SQL Server 2008">
<auto_correct_using_merge>Yes</auto_correct_using_merge>
<bulk_ldr_all_rows></bulk_ldr_all_rows>
<bulk_ldr_max_errors></bulk_ldr_max_errors>
<bulk_ldr_rows_per_commit>1000</bulk_ldr_rows_per_commit>
<enable_partitioning>no</enable_partitioning>
<ignore_column_case>yes</ignore_column_case>
<ignore_columns_null>No</ignore_columns_null>
<ignore_columns_value></ignore_columns_value>
<loader_auto_correct>no</loader_auto_correct>
<loader_bulk_load></loader_bulk_load>
<loader_compare_column>compare_by_name</loader_compare_column>
<loader_delete_map></loader_delete_map>
<loader_drop_and_create_table>no</loader_drop_and_create_table>
<loader_insert_map></loader_insert_map>
<loader_load_choice>replace</loader_load_choice>
<loader_num_parallel_loaders>1</loader_num_parallel_loaders>
<loader_overflow_file>DEMO_E2E_SBO_DBO_FACT_CRIMES.txt</loader_overflow_file>
<loader_post_load1></loader_post_load1>
<loader_pre_load1></loader_pre_load1>
<loader_quote_names>0</loader_quote_names>
<loader_transactional>no</loader_transactional>
<loader_transactional_order>0</loader_transactional_order>
<loader_update_key_columns>no</loader_update_key_columns>
<loader_update_map></loader_update_map>
<loader_use_user_defined_keys>no</loader_use_user_defined_keys>
<loader_xact_size>1000</loader_xact_size>
<mssql_bulk_ldr_mode>append</mssql_bulk_ldr_mode>
<mssql_bulk_ldr_packet_size>0</mssql_bulk_ldr_packet_size>
<overflow_file_format>Write data</overflow_file_format>
<use_overflow_file>no</use_overflow_file>
<use_unicode_varchar>no</use_unicode_varchar>
<sql_text></sql_text>
</LDRConfiguration>
</LDRConfigurations>',
"loader_template_table" = 'no',
"name" = 'DEMO_E2E_SBO',
"use_unicode_varchar" = 'no');
END

SET("Cache_type" = 'in_memory_cache',
"Parallelism_degree" = '2',
"allows_both_input_and_output" = 'yes',
"run_once" = 'no',
"use_dataflow_links" = 'no',
"use_datastore_links" = 'yes',
"validation_xform_exists" = 'no',
"validation_xform_stats" = 'no')