#__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')