#__AW_Repository_Version '11.5.1.5'; #__AW_Product_Version '11.5.1.5'; #__AW_ATL_Locale 'eng_gb.cp1252'; ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Thu Jul 06 14:33:20 2006' ) CREATE DATABASE DATASTORE DS_BODI_Test_Source::'e799d818-ba04-40a9-89cb-bdb55625a420' SET ("DB2_version" = 'DB2 UDB 6.1', "DBLiveLoad" = 'no', "DB_connection_retry_count" = '3', "DB_retry_interval" = '10000', "abap_execution_mode" = 'generate_and_execute', "abap_job_class" = 'C', "application_type" = 'Custom', "attunity_workspace" = 'Navigator', "case_sensitive" = 'no', "cdc_enabled" = 'no', "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" = ' no Microsoft_SQL_Server 1000 <default> <default> <default> no 6F0E492C422B6E BODI_Test_Source JBARNES-L03VM Microsoft SQL Server 2000 sa ', "ftp_passwd" = '5D38563F7A', "import_unknown_type" = 'no', "informix_version" = 'Informix IDS 7.3', "js_db_on_same_machine" = 'no', "loader_file_location" = 'shared_directory', "loader_xact_size" = '1000', "locale_codepage" = '', "locale_language" = '', "locale_territory" = '', "mssql_windows_authentication" = 'no', "name" = 'DS_BODI_Test_Source', "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_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_ltrim_blanks" = 'odbc_automatic', "odbc_func_max" = 'odbc_automatic', "odbc_func_min" = 'odbc_automatic', "odbc_func_month" = 'odbc_automatic', "odbc_func_quarter" = 'odbc_automatic', "odbc_func_round" = 'odbc_automatic', "odbc_func_rtrim_blanks" = '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_nvl_func_support" = 'odbc_automatic', "odbc_outer_join_support" = 'odbc_automatic', "oracle_version" = 'Oracle 8.0', "password" = '6F0E492C422B6E', "rem_repo_passwd" = 'no', "sap_language" = 'E - English', "sap_system_number" = '00', "secure_repo" = 'no', "sql_server_database" = 'BODI_Test_Source', "sql_server_dataserver" = 'JBARNES-L03VM', "sql_server_version" = 'Microsoft SQL Server 2000', "sybase_iq_version" = 'Sybase IQ 12.5', "sybase_version" = 'Sybase ASE 11.x', "teradata_version" = 'Teradata 2.5', "transfer_password" = ';E6ED175A9EA8CF281B93DC4CE91EE6CEABBA37651575CA0037C3D47B641446B2', "unknown_type_size" = '255', "use_named_pipe" = 'no', "user" = 'sa'); AlGUIComment (ActaName_1 = 'RTable_Type',ActaValue_1 = 'TABLE' , ActaName_2 = 'RDescription',ActaValue_2 = '' , ActaName_3 = 'REstimated_Row_Count',ActaValue_3 = '50000' , ActaName_4 = 'RSavedAfterCheckOut',ActaValue_4 = 'YES' , ActaName_5 = 'RLoader_Is_Template_Table',ActaValue_5 = 'no' , ActaName_6 = 'RDate_created',ActaValue_6 = 'Thu Jul 06 14:34:17 2006' , ActaName_7 = 'RDate_last_loaded',ActaValue_7 = 'NotYetLoaded' ) CREATE TABLE DS_BODI_Test_Source.dbo.INPUT_DATA(COL1 INT NOT NULL ) SET("db_alias_name" = 'DBO') ; ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Thu Jul 06 14:34:05 2006' ) CREATE DATABASE DATASTORE DS_BODI_Test_Target::'0da9a2d2-234f-45ba-82f5-84df2014149c' SET ("DB2_version" = 'DB2 UDB 6.1', "DBLiveLoad" = 'no', "DB_connection_retry_count" = '3', "DB_retry_interval" = '10000', "abap_execution_mode" = 'generate_and_execute', "abap_job_class" = 'C', "application_type" = 'Custom', "attunity_workspace" = 'Navigator', "case_sensitive" = 'no', "cdc_enabled" = 'no', "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" = ' no Microsoft_SQL_Server 1000 <default> <default> <default> no 6F0E492C422B6E BODI_Test_Target JBARNES-L03VM Microsoft SQL Server 2000 sa ', "ftp_passwd" = '5D38563F7A', "import_unknown_type" = 'no', "informix_version" = 'Informix IDS 7.3', "js_db_on_same_machine" = 'no', "loader_file_location" = 'shared_directory', "loader_xact_size" = '1000', "locale_codepage" = '', "locale_language" = '', "locale_territory" = '', "mssql_windows_authentication" = 'no', "name" = 'DS_BODI_Test_Target', "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_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_ltrim_blanks" = 'odbc_automatic', "odbc_func_max" = 'odbc_automatic', "odbc_func_min" = 'odbc_automatic', "odbc_func_month" = 'odbc_automatic', "odbc_func_quarter" = 'odbc_automatic', "odbc_func_round" = 'odbc_automatic', "odbc_func_rtrim_blanks" = '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_nvl_func_support" = 'odbc_automatic', "odbc_outer_join_support" = 'odbc_automatic', "oracle_version" = 'Oracle 8.0', "password" = '6F0E492C422B6E', "rem_repo_passwd" = 'no', "sap_language" = 'E - English', "sap_system_number" = '00', "secure_repo" = 'no', "sql_server_database" = 'BODI_Test_Target', "sql_server_dataserver" = 'JBARNES-L03VM', "sql_server_version" = 'Microsoft SQL Server 2000', "sybase_iq_version" = 'Sybase IQ 12.5', "sybase_version" = 'Sybase ASE 11.x', "teradata_version" = 'Teradata 2.5', "transfer_password" = ';8D571EDF646A6520C988438667EDF067F5F56B01CA227581C819C92FCA2477C5', "unknown_type_size" = '255', "use_named_pipe" = 'no', "user" = 'sa'); AlGUIComment (ActaName_1 = 'RTable_Type',ActaValue_1 = 'TABLE' , ActaName_2 = 'RDescription',ActaValue_2 = '' , ActaName_3 = 'REstimated_Row_Count',ActaValue_3 = '50000' , ActaName_4 = 'RSavedAfterCheckOut',ActaValue_4 = 'YES' , ActaName_5 = 'RLoader_Is_Template_Table',ActaValue_5 = 'no' , ActaName_6 = 'RDate_created',ActaValue_6 = 'Thu Jul 06 14:34:25 2006' , ActaName_7 = 'RDate_last_loaded',ActaValue_7 = 'NotYetLoaded' ) CREATE TABLE DS_BODI_Test_Target.dbo.OUTPUT_DATA1(PK_COL1 INT KEY NOT NULL ) PRIMARY KEY (PK_COL1) CREATE_INDEX PK__OUTPUT_DATA1__76CBA758 ON (PK_COL1) PRIMARY 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 = 'RSavedAfterCheckOut',ActaValue_4 = 'YES' , ActaName_5 = 'RLoader_Is_Template_Table',ActaValue_5 = 'no' , ActaName_6 = 'RDate_created',ActaValue_6 = 'Thu Jul 06 14:34:25 2006' , ActaName_7 = 'RDate_last_loaded',ActaValue_7 = 'NotYetLoaded' ) CREATE TABLE DS_BODI_Test_Target.dbo.OUTPUT_DATA2(PK_COL1 INT KEY NOT NULL ) PRIMARY KEY (PK_COL1) CREATE_INDEX PK__OUTPUT_DATA2__78B3EFCA ON (PK_COL1) PRIMARY SET("db_alias_name" = 'DBO') ; ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Thu Jul 06 14:31:35 2006' ) CREATE SESSION JOB_Test_Dual_Update::'5cc5ba2d-5525-4e32-a8f2-bed2788af126'( ) BEGIN ALGUICOMMENT( x = '391', y = '-278',UI_DATA_XML='00388-1790-1902002000' ) CALL DATAFLOW DF_Test_Dual_Update::'bfdc7207-9821-4861-b946-d169685e2995'(); END SET("database_type" = 'Microsoft_SQL_Server', "job_checkpoint_enabled" = 'no', "job_enable_audit" = 'yes', "job_enable_dataquality" = 'yes', "job_export_repo" = 'no', "job_guid" = '5cc5ba2d-5525-4e32-a8f2-bed2788af126', "job_isrecoverable" = 'no', "job_mode" = 'Multi-Process', "job_monitor_sample_rate" = '1000', "job_name" = 'JOB_Test_Dual_Update', "job_print_version" = 'no', "job_testmode_enabled" = 'no', "job_trace_abapquery" = 'no', "job_trace_all" = 'no', "job_trace_ascomm" = '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', "locale_codepage" = '', "locale_language" = '', "locale_territory" = '', "oracle_host_string" = 'jbarnes-l03vm', "password" = '652A6E277510600F7C295A3F4D0A6F01682D', "sql_server_database" = 'BODIRepos', "sql_server_dataserver" = 'jbarnes-l03vm', "user" = 'BODIReposUser') ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Thu Jul 06 14:35:41 2006' , "ActaName_3" = 'Rcolumn_mapping_calculated' , "ActaValue_3" = 'yes' ) CREATE DATAFLOW DF_Test_Dual_Update::'bfdc7207-9821-4861-b946-d169685e2995' BEGIN ALGUICOMMENT( x = '184', y = '-497',UI_DATA_XML='00378-1820-1742002000', UpperContainer_HeightProp = '31', InputSchema_WidthProp = '44', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '85', Output_Column_Width_4 = '80' ) GUID::'8e6dd84b-96c2-4495-bc52-085c81e855bf' READ TABLE DS_BODI_Test_Source.DBO.INPUT_DATA OUTPUT ( INPUT_DATA ) SET ( "array_fetch_size" = '1000', "cache" = 'yes', "connection_port" = 'no', "enable_partitioning" = 'no', "name" = 'DS_BODI_Test_Source', "package_size" = '0', "reader_is_DB2CDC_table" = 'no', "reader_overflow_file" = 'overflow_file', "reader_template_table" = 'no', "reader_use_overflow_file" = 'no', "table_weight" = '0'); ALGUICOMMENT( x = '1144', y = '-444',UI_DATA_XML='00432-1820-1742002000', UpperContainer_HeightProp = '31', InputSchema_WidthProp = '44', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '85', Output_Column_Width_4 = '80' ) GUID::'3f536c50-c8a8-417b-9310-694a8cd286c0' LOAD TABLE DS_BODI_Test_Target.DBO.OUTPUT_DATA1 INPUT ( Query ) SET ( "LDRLiveLoad" = 'no', "Table_Type" = 'TABLE', "connection_port" = 'no', "ldr_configuration_enabled" = 'yes', "ldr_configurations" = ' 1000 no yes no no compare_by_name no append 1 overflow_file 0 yes 1 no no 1000 append 0 write_data no ', "loader_template_table" = 'no', "name" = 'DS_BODI_Test_Target'); ALGUICOMMENT( x = '1153', y = '-712',UI_DATA_XML='00432-1820-1742002000', UpperContainer_HeightProp = '31', InputSchema_WidthProp = '44', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '85', Output_Column_Width_4 = '80' ) GUID::'7fb9a7b2-2a9b-4b88-996c-46f7f2488aa8' LOAD TABLE DS_BODI_Test_Target.DBO.OUTPUT_DATA2 INPUT ( Query ) SET ( "LDRLiveLoad" = 'no', "Table_Type" = 'TABLE', "connection_port" = 'no', "ldr_configuration_enabled" = 'yes', "ldr_configurations" = ' 1000 no yes no no compare_by_name no append 1 overflow_file 0 yes 2 no no 1000 append 0 write_data no ', "loader_template_table" = 'no', "name" = 'DS_BODI_Test_Target'); ALGUICOMMENT( x = '684', y = '-534' , ui_acta_from_schema_0 = 'INPUT_DATA' ,UI_DATA_XML='00238-1630-1742002000', UpperContainer_HeightProp = '31', InputSchema_WidthProp = '44', Input_Width_Description = '130', Output_Width_Decsription = '130', Input_Width_Type = '85', Output_Width_Type = '80', Output_Width_Mapping = '85', Input_Column_Width_3 = '85', Output_Column_Width_4 = '80', Input_1st_Column_Name = 'Description', Input_2nd_Column_Name = 'Type', Input_Column_Name_3 = 'Business_Name', Output_1st_Column_Name = 'Description', Output_2nd_Column_Name = 'Type', Output_3rd_Column_Name = 'Mapping', Ouput_Column_Name_4 = 'Business_Name' ) GUID::'3431972a-10a0-41f8-80d1-2ba76cde2bb6' CREATE VIEW Query ( PK_COL1 int KEY ) AS SELECT INPUT_DATA.COL1 FROM INPUT_DATA; END SET("Parallelism_degree" = '0', "run_once" = 'no', "use_datastore_links" = 'yes', "validation_xform_exists" = 'no', "validation_xform_stats" = 'no')