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.11
Published
Octubre de 2021
Language
Español
Last Update
2021-11-08
dita:mapPath
es-ES/cai1626458602965.ditamap
dita:ditavalPath
es-ES/mpm1591127278842.ditaval
dita:id
B035-4101
Product Category
Analytical Ecosystem

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>