17.10 - Archivo XML de creación de trabajo de ejemplo - Teradata Data Mover

Teradata® Data Mover Guía del usuario

Product
Teradata Data Mover
Release Number
17.10
Release Date
Junio de 2021
Content Type
Guía del usuario
Publication ID
B035-4101-061K-ESN
Language
Español (España)

El siguiente XML de ejemplo muestra el orden correcto de todos los elementos posibles que están disponibles para un archivo XML de creación de trabajo.

Consulte este XML de ejemplo antes de crear un trabajo.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dmCreate xmlns="http://schemas.teradata.com/dataMover/v2009" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.teradata.com/unity/datamover.xsd">
    <job_name>datamovertest</job_name>
    <source_tdpid>dmdev</source_tdpid>
    <source_user>dmguest</source_user>
    <source_password>please</source_password>
    <source_password_encrypted></source_password_encrypted>
    <source_logon_mechanism></source_logon_mechanism>
    <source_logon_mechanism_data></source_logon_mechanism_data>
    <source_account_id></source_account_id>
    <source_session_charset></source_session_charset>
    <target_tdpid>dmsmp2</target_tdpid>
    <target_user>dmguest</target_user>
    <target_password>please</target_password>
    <target_password_encrypted></target_password_encrypted>
    <target_logon_mechanism></target_logon_mechanism>
    <target_logon_mechanism_data></target_logon_mechanism_data>
    <target_account_id></target_account_id>
    <target_session_charset></target_session_charset>
    <use_userid_pool>false</use_userid_pool>
    <data_streams>1</data_streams>
    <source_sessions>1</source_sessions>
    <target_sessions>1</target_sessions>
    <max_agents_per_task>1</max_agents_per_task>
    <response_timeout>100</response_timeout>
    <sync>true</sync>
    <overwrite_existing_objects>true</overwrite_existing_objects>
    <freeze_job_steps>false</freeze_job_steps>
    <force_utility>tptapi</force_utility>
    <staging_database>
        <name>dmguest</name>
    </staging_database>
    <staging_database_for_table>
        <name>dmguest</name>
    </staging_database_for_table>
    <target_database>
        <name>dmguest</name>
    </target_database>
    <log_level>0</log_level>
    <online_archive>false</online_archive>
    <log_to_event_table>tmsmevent</log_to_event_table>
    <database selection="unselected" replaceDatabase="true">
        <name>dmguest</name>
        <staging_database>
          <name>dmguest</name>
        </staging_database>
        <staging_database_for_table>
          <name>dmguest</name>
        </staging_database_for_table>
        <target_database>
          <name>dmguest</name>
        </target_database>
        <compare_ddl>TRUE</compare_ddl>     
        <table selection="included" copyStats="false">
            <name>ppiorders</name>
            <staging_database>
               <name>dmguest</name>
            </staging_database>
              <staging_database_for_table>
                <name>dmguest</name>
              </staging_database_for_table>
              <force_target_staging_table>false</force_target_staging_table>
              <target_database>
                <name>dmguest</name>
              </target_database>
              <target_name>table8_clone</target_name>
              <validate_row_count>all</validate_row_count> 
              <override_lock_access>false</override_lock_access>
              <export_without_spool>true</export_without_spool>
              <compare_ddl>TRUE</compare_ddl>              
              <sql_where_clause><![CDATA[ WHERE ORDERDATE > '2003-01-23' ]]></sql_where_clause>
              <key_columns>
                <key_column>ORDERDATE</key_column>
              </key_columns> 
              <staging_to_target>insert_only</staging_to_target>
        </table>
        <table selection="included" copyStats="false">
            <name>employee</name>
            <compare_ddl>true</compare_ddl>
        </table>
    </database>
    <triggers>
    <trigger selection="included">
       <database>dmguest</database>
       <subject_table_database>dmguest</subject_table_database>
       <table>employee</table>
       <name>TestTrigger</name>
       <action_time enabled="NO">BEFORE</action_time>
    </trigger>
    </triggers>
    <indices>
        <index selection="included" copyStats="false">
            <name>Orders_HI</name>
            <target_name>orders_HI_new</target_name>
            <index_database>dmguest</index_database>
            <index_type>HASH_INDEX</index_type>
        </index>
    </indices>
    <views>
        <view selection="included" copyData="true">
          <name>testview</name>
	      <database>dmguest</database>
	      <view_data_table>
	          <target_table>TargetTable</target_table>
	          <target_database>dmguest</target_database>
	      </view_data_table>
          <staging_database>
	          <name>dmguest</name>
	      </staging_database>
          <staging_database_for_table>
              <name>dmguest</name>
          </staging_database_for_table>
          <force_target_staging_table>false</force_target_staging_table>
          <validate_row_count>all</validate_row_count>
          <compare_ddl>true</compare_ddl>
          <sql_where_clause><![CDATA[  WHERE "test2"."C1" > 500 ]]></sql_where_clause>
          <key_columns>
   		   <key_column>C1</key_column>
          </key_columns>
        </view>
    </views>
    <foreign_servers>
       <foreign_server selection="included" >
           <name>FSObj</name>
           <map>map1</map>
           <colocate>col1</colocate>
        </foreign_server>
    </foreign_servers>
    <function_aliases>
        <function_alias selection="included" >
            <name>dmguest</name>
            <database>faObj</database>
        </function_alias>
    </function_aliases>
    <macros>
	<macro selection="included"> 
		<name>macro_employee</name>  
		<database>dmguest</database> 
	</macro> 
    </macros>
    <stored_procedures>
	<stored_procedure selection="included"> 
		<name>getEmpInfo</name>  
		<database>dmguest</database> 
	</stored_procedure> 
    </stored_procedures>
    <uowid>test</uowid>
    <query_band>AppName=B;</query_band>
</dmCreate>