#__AW_Repository_Version '11.7.0.0000';
#__AW_Product_Version '11.7.2.3';
#__AW_ATL_Locale 'zho_cn.utf-8';
ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Sun Jul 06 18:08:05 2008' , "ActaName_3" = 'RDate_modified' , "ActaValue_3" = 'Sun Jul 06 17:30:57 2008' )
CREATE DATABASE DATASTORE DS_VZW1840_ORACLE::'6e8952ea-fba4-43c6-a771-f43fa189bee4' 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',
"data_federator_version" = 'Data Federator 11.x',
"database_type" = 'Oracle',
"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="GBK" ?>
<DSConfigurations>
<DSConfiguration default="true" name="Configuration1">
<case_sensitive>no</case_sensitive>
<database_type>Oracle</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>
<oracle_host_string>TNS_VZW1840_ORADB10G</oracle_host_string>
<oracle_version>Oracle 10g</oracle_version>
<password>;8541B5F20DD0E0A88C204A5B08A8BB675239068495C27BAF08ECF2AEBBF6ECBD</password>
<user>zw1840</user>
</DSConfiguration>
</DSConfigurations>
',
"enable_data_transfer" = 'yes',
"ftp_passwd" = ';7EE32A1808100B07B595DCFA14CD548335BE796283FAB99984571FC3D0F59FDB',
"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" = '<default>',
"locale_language" = '<default>',
"locale_territory" = '<default>',
"mssql_windows_authentication" = 'no',
"mysql_version" = 'MySQL 5.0',
"name" = 'DS_VZW1840_ORACLE',
"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_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_nvl_func_support" = 'odbc_automatic',
"odbc_outer_join_support" = 'odbc_automatic',
"oracle_host_string" = 'TNS_VZW1840_ORADB10G',
"oracle_version" = 'Oracle 10g',
"password" = ';8541B5F20DD0E0A88C204A5B08A8BB675239068495C27BAF08ECF2AEBBF6ECBD',
"rem_repo_passwd" = 'no',
"runtime_in_utf16" = '1',
"sap_language" = 'E - English',
"sap_system_number" = '00',
"secure_repo" = 'no',
"sql_server_version" = 'Microsoft SQL Server 7.0',
"sybase_iq_version" = 'Sybase IQ 12.5',
"sybase_version" = 'Sybase ASE 11.x',
"teradata_version" = 'Teradata 2.5',
"transfer_password" = ';7EE32A1808100B07B595DCFA14CD548335BE796283FAB99984571FC3D0F59FDB',
"unknown_type_size" = '255',
"use_named_pipe" = 'no',
"user" = 'zw1840');

 AlGUIComment (ActaName_1 = 'RTable_Type',ActaValue_1 = 'TABLE' , 
ActaName_2 = 'RDescription',ActaValue_2 = 'SCD2 Demo 数据源表, 员工信息' , 
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 Oct 30 21:06:08 2008' , 
ActaName_7 = 'RDate_last_loaded',ActaValue_7 = 'NotYetLoaded' )
CREATE TABLE DS_VZW1840_ORACLE.ZW1840.SCD2_DS_EMP(EMP_ID DECIMAL(20, 0)  KEY  NOT NULL  SET("Description" = '主键, 序列'), 
EMP_CODE VARCHAR(1024)  NOT NULL  SET("Description" = '员工编号, 自然键'), 
EMP_NAME VARCHAR(1024)  NOT NULL  SET("Description" = '员工姓名'), 
REGION VARCHAR(1024)  NOT NULL  SET("Description" = '员工所属地区'), 
BIRTHDAY DATETIME  NOT NULL  SET("Description" = '员工生日'), 
UPD_TIMESTAMP DATETIME  NULL  SET("Description" = '员工信息最后更新时间')) 
PRIMARY KEY (EMP_ID) 
CREATE_INDEX PK_SCD2_DS_EMP ON (EMP_ID) PRIMARY 
SET("db_alias_name" = 'ZW1840')
;

 AlGUIComment (ActaName_1 = 'RTable_Type',ActaValue_1 = 'TABLE' , 
ActaName_2 = 'RDescription',ActaValue_2 = 'SCD2 Demo 数据目标表, 员工信息' , 
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 Oct 30 21:06:15 2008' , 
ActaName_7 = 'RDate_last_loaded',ActaValue_7 = 'Thu Oct 30 22:47:38 2008' , 
ActaName_8 = 'RTotal_Number_Of_Rows_Processed',ActaValue_8 = '2' , 
ActaName_9 = 'RNumber_Of_Rows_Rejected',ActaValue_9 = '0' , 
ActaName_10 = 'RNumber_Of_Inserts',ActaValue_10 = '1' , 
ActaName_11 = 'RNumber_Of_Updates',ActaValue_11 = '1' , 
ActaName_12 = 'RNumber_Of_Deletes',ActaValue_12 = '0' , 
ActaName_13 = 'RElapsed_Time_For_Load',ActaValue_13 = '0 Seconds' )
CREATE TABLE DS_VZW1840_ORACLE.ZW1840.SCD2_DT_EMP(EMP_SID DECIMAL(20, 0)  KEY  NOT NULL  SET("Description" = '代理主键'), 
EMP_CODE VARCHAR(1024)  NOT NULL  SET("Description" = '员工编号，唯一键'), 
EMP_NAME VARCHAR(1024)  NOT NULL  SET("Description" = '员工姓名'), 
REGION VARCHAR(1024)  NOT NULL  SET("Description" = '员工所属地区'), 
BIRTHDAY DATETIME  NOT NULL  SET("Description" = '员工生日'), 
DATE_EFFECT DATETIME  NULL  SET("Description" = '信息生效日期'), 
DATE_EXPIRE DATETIME  NULL  SET("Description" = '信息过期日期'), 
FLAG_CURRENT VARCHAR(1024)  NULL  SET("Description" = '当前有效信息标志')) 
PRIMARY KEY (EMP_SID) 
CREATE_INDEX PK_SCD2_DT_EMP ON (EMP_SID) PRIMARY 
SET("db_alias_name" = 'ZW1840')
;
ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Thu Oct 30 14:17:47 2008' , "ActaName_3" = 'RDate_modified' , "ActaValue_3" = 'Tue Nov 18 14:07:26 2008' )
CREATE SESSION JOB_SCD2_EMP::'f439c545-1573-4713-a569-94577699d21d'( )
DECLARE
     GLOBAL $GV_ETL_MODE varchar(3);
BEGIN
ALGUICOMMENT( x = '931', y = '-606',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>307</CX><CY>-182</CY></SIZE></MAINICON><DESCRIPTION><LOCATION><X>0</X><Y>-191</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>' )
CALL DATAFLOW DF_SCD2_EMP::'6065d5ff-11bb-4e1a-9c46-7e2110911b54'();
END

SET("database_type" = 'Microsoft_SQL_Server',
"job_checkpoint_enabled" = 'no',
"job_collect_statistics" = 'no',
"job_collect_statistics_monitor" = 'no',
"job_enable_audit" = 'yes',
"job_enable_dataquality" = 'yes',
"job_export_repo" = 'no',
"job_guid" = 'f439c545-1573-4713-a569-94577699d21d',
"job_isrecoverable" = 'no',
"job_mode" = 'Multi-Process',
"job_monitor_sample_rate" = '1000',
"job_name" = 'JOB_SCD2_EMP',
"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',
"job_use_statistics" = 'yes',
"locale_codepage" = '<default>',
"locale_language" = '<default>',
"locale_territory" = '<default>',
"oracle_host_string" = 'DOPE',
"password" = ';684AB2A3DC027828F44C751083E4D871A9CCA817A18D95FF60A196323DE5F981',
"sql_server_database" = 'REP_BODI',
"sql_server_dataserver" = 'DOPE',
"user" = 'sa')
ALGUICOMMENT( x = '-1', y = '-1' , "ActaName_1" = 'RSavedAfterCheckOut' , "ActaValue_1" = 'YES' , "ActaName_2" = 'RDate_created' , "ActaValue_2" = 'Wed Oct 29 12:31:22 2008' , "ActaName_3" = 'Rcolumn_mapping_calculated' , "ActaValue_3" = 'no' , "ActaName_4" = 'RDate_modified' , "ActaValue_4" = 'Wed Nov 19 11:17:39 2008' )
CREATE DATAFLOW DF_SCD2_EMP::'6065d5ff-11bb-4e1a-9c46-7e2110911b54'

BEGIN 
ALGUICOMMENT( x = '285', y = '-169',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>831</CX><CY>-185</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 = '52', InputSchema_WidthProp = '30', 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::'d91553f3-c7ff-44a2-9924-52a6486a596e' READ TABLE DS_VZW1840_ORACLE.ZW1840.SCD2_DS_EMP  OUTPUT ( SCD2_DS_EMP ) SET (
"array_fetch_size" = '1000',
"cache" = 'yes',
"connection_port" = 'no',
"enable_partitioning" = 'no',
"name" = 'DS_VZW1840_ORACLE',
"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 = '530', y = '-432' , ui_acta_from_schema_0 = 'SCD2_DS_EMP' ,UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>238</CX><CY>-166</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 = '52', InputSchema_WidthProp = '30', 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', Output_Column_Name_4 = 'Business_Name' )
GUID::'a5c4ecca-ccf7-415a-b1f5-e2f0a2be4ffd' CREATE VIEW Query ( EMP_CODE varchar(1024) SET("Description"='员工编号，唯一键', "ui_mapping_text"='SCD2_DS_EMP.EMP_CODE') ,
 EMP_NAME varchar(1024) SET("Description"='员工姓名', "ui_mapping_text"='SCD2_DS_EMP.EMP_NAME') ,
 REGION varchar(1024) SET("Description"='员工所属地区', "ui_mapping_text"='SCD2_DS_EMP.REGION') ,
 BIRTHDAY datetime SET("Description"='员工生日', "ui_mapping_text"='SCD2_DS_EMP.BIRTHDAY') ,
 DATE_EFFECT datetime SET("Description"='员工信息最后更新时间', "ui_mapping_text"='ifthenelse(
  $GV_ETL_MODE = \'INI\',
  to_date(\'19000101\',\'yyyymmdd\'),
  to_date(to_char(SCD2_DS_EMP.UPD_TIMESTAMP,\'yyyymmdd\'),\'yyyymmdd\')
)')  ) 
AS SELECT  SCD2_DS_EMP.EMP_CODE
 
 ,
 SCD2_DS_EMP.EMP_NAME
 
 ,
 SCD2_DS_EMP.REGION
 
 ,
 SCD2_DS_EMP.BIRTHDAY
 
 ,
 ifthenelse(
  $GV_ETL_MODE = 'INI',
  to_date('19000101','yyyymmdd'),
  to_date(to_char(SCD2_DS_EMP.UPD_TIMESTAMP,'yyyymmdd'),'yyyymmdd')
)
 
 
	FROM SCD2_DS_EMP 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 = '683', y = '-671',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>416</CX><CY>-166</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 = '34', InputSchema_WidthProp = '27', Output_Width_Name = '146', Input_Width_Description = '130', Output_Width_Decsription = '97', Input_Width_Type = '85', Output_Width_Type = '99', Output_Width_Mapping = '85', Input_Column_Width_3 = '85', Output_Column_Width_4 = '115' )
GUID::'497b582f-0565-44d9-9a71-4b648b694802' CALL TRANSFORM Table_Comparison ( ) 
INPUT ( Query )
OUTPUT ( SCD2_DT_EMP ( EMP_SID decimal(20,0) KEY ,
 EMP_CODE varchar(1024),
 EMP_NAME varchar(1024),
 REGION varchar(1024),
 BIRTHDAY datetime,
 DATE_EFFECT datetime,
 DATE_EXPIRE datetime,
 FLAG_CURRENT varchar(1024) )  )
SET ("cache_comparison_table" = 'no',
"compare_column1" = 'EMP_NAME',
"compare_column2" = 'REGION',
"compare_column3" = 'BIRTHDAY',
"database_datastore" = 'DS_VZW1840_ORACLE',
"detect_all_dup_deletes" = 'no',
"detect_delete" = 'yes',
"generated_key_column" = 'EMP_SID',
"primary_key_column1" = 'EMP_CODE',
"run_as_separate_process" = 'no',
"source_is_sorted" = 'no',
"table_name" = 'SCD2_DT_EMP',
"table_owner" = 'ZW1840',
"update_cache" = 'no');
ALGUICOMMENT( x = '834', y = '-925',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>460</CX><CY>-166</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 = '40', InputSchema_WidthProp = '39', Input_Width_Name = '181', Output_Width_Name = '189', Input_Width_Description = '130', Output_Width_Decsription = '82', Input_Width_Type = '85', Output_Width_Type = '97', Output_Width_Mapping = '85', Input_Column_Width_3 = '85', Output_Column_Width_4 = '80' )
GUID::'9d107aec-cd09-4938-8668-a42624400875' CALL TRANSFORM History_Preserving ( ) 
INPUT ( SCD2_DT_EMP )
OUTPUT ( History_Preserving ( EMP_SID decimal(20,0) KEY ,
 EMP_CODE varchar(1024),
 EMP_NAME varchar(1024),
 REGION varchar(1024),
 BIRTHDAY datetime,
 DATE_EFFECT datetime,
 DATE_EXPIRE datetime,
 FLAG_CURRENT varchar(1024) )  )
SET ("compare_column1" = 'EMP_NAME',
"compare_column2" = 'REGION',
"compare_column3" = 'BIRTHDAY',
"current_flag_column" = 'FLAG_CURRENT',
"current_flag_reset_value" = '\'NO\'',
"current_flag_set_value" = '\'YES\'',
"detect_delete" = 'yes',
"valid_from_column" = 'DATE_EFFECT',
"valid_from_delta_column" = '0',
"valid_to_column" = 'DATE_EXPIRE',
"valid_to_date_value" = '2099.12.31');
ALGUICOMMENT( x = '987', y = '-1180',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>372</CX><CY>-166</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 = '60', InputSchema_WidthProp = '30', 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::'1f56102a-19d6-4ede-a52b-e22887e2215c' CALL TRANSFORM Key_Generation ( ) 
INPUT ( History_Preserving )
OUTPUT ( Key_Generation ( EMP_SID decimal(20,0) KEY ,
 EMP_CODE varchar(1024),
 EMP_NAME varchar(1024),
 REGION varchar(1024),
 BIRTHDAY datetime,
 DATE_EFFECT datetime,
 DATE_EXPIRE datetime,
 FLAG_CURRENT varchar(1024) )  )
SET ("database_datastore" = 'DS_VZW1840_ORACLE',
"generated_key_column" = 'EMP_SID',
"increment_value" = '1',
"table_name" = 'SCD2_DT_EMP',
"table_owner" = 'ZW1840');
ALGUICOMMENT( x = '1274', y = '-1495',UI_DATA_XML='<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>875</CX><CY>-185</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 = '38', InputSchema_WidthProp = '30', Input_Width_Name = '139', Output_Width_Name = '281', Input_Width_Description = '130', Output_Width_Decsription = '177', Input_Width_Type = '85', Output_Width_Type = '177', Output_Width_Mapping = '85', Input_Column_Width_3 = '85', Output_Column_Width_4 = '177' )
GUID::'aa7bfab5-2c90-44e3-b8da-b951a3ca5143' LOAD TABLE DS_VZW1840_ORACLE.ZW1840.SCD2_DT_EMP  INPUT ( Key_Generation ) 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="Oracle" database_version="Oracle 10g">
<bulk_col_delimiter>/127</bulk_col_delimiter>
<bulk_ldr_cleanup>yes</bulk_ldr_cleanup>
<bulk_ldr_control_file_name></bulk_ldr_control_file_name>
<bulk_ldr_direct></bulk_ldr_direct>
<bulk_ldr_direct_api>no</bulk_ldr_direct_api>
<bulk_ldr_generate_files_only></bulk_ldr_generate_files_only>
<bulk_ldr_max_bind_array>100000</bulk_ldr_max_bind_array>
<bulk_ldr_max_discards>10</bulk_ldr_max_discards>
<bulk_ldr_mode>append</bulk_ldr_mode>
<bulk_ldr_recoverable></bulk_ldr_recoverable>
<bulk_ldr_rows_per_commit>1000</bulk_ldr_rows_per_commit>
<bulk_ldr_trailing_nullcols></bulk_ldr_trailing_nullcols>
<bulk_ldr_use_control_file></bulk_ldr_use_control_file>
<column_delimiter>,</column_delimiter>
<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_insert_select_commit_size>yes</loader_insert_select_commit_size>
<loader_load_choice>append</loader_load_choice>
<loader_num_parallel_loaders>1</loader_num_parallel_loaders>
<loader_overflow_file>overflow_file</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>
<oracle_auto_correct_using_merge>yes</oracle_auto_correct_using_merge>
<oracle_bulk_ldr_all_method>None</oracle_bulk_ldr_all_method>
<oracle_bulk_ldr_file_method>None</oracle_bulk_ldr_file_method>
<oracle_bulk_ldr_method>None</oracle_bulk_ldr_method>
<oracle_bulk_ldr_method_api>API</oracle_bulk_ldr_method_api>
<oracle_bulk_ldr_method_file>File</oracle_bulk_ldr_method_file>
<oracle_bulk_ldr_method_none>None</oracle_bulk_ldr_method_none>
<oracle_bulk_ldr_mode_api>append</oracle_bulk_ldr_mode_api>
<oracle_sqlldr_version></oracle_sqlldr_version>
<overflow_file_format>write_data</overflow_file_format>
<text_delimiter></text_delimiter>
<use_overflow_file>no</use_overflow_file>
<sql_text></sql_text>
</LDRConfiguration>
</LDRConfigurations>',
"loader_template_table" = 'no',
"name" = 'DS_VZW1840_ORACLE');
END

SET("Cache_type" = 'pageable_cache',
"Parallelism_degree" = '0',
"run_once" = 'no',
"use_dataflow_links" = 'no',
"use_datastore_links" = 'yes',
"validation_xform_exists" = 'no',
"validation_xform_stats" = 'no')