blob: 980d5eaa92521018314bbf4b8a02ebad9eaebd92 [file] [log] [blame]
<?xml version="1.0" encoding="UTF-8"?>
<pipeline>
<info>
<name>Execute a transformation stored in a String</name>
<description/>
<extended_description/>
<trans_version/>
<trans_type>Normal</trans_type>
<trans_status>0</trans_status>
<directory>&#x2f;</directory>
<parameters>
</parameters>
<log>
<pipeline-log-table>
<connection/>
<schema/>
<table/>
<size_limit_lines/>
<interval/>
<timeout_days/>
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>N</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>TRANSNAME</id>
<enabled>Y</enabled>
<name>TRANSNAME</name>
</field>
<field>
<id>STATUS</id>
<enabled>Y</enabled>
<name>STATUS</name>
</field>
<field>
<id>LINES_READ</id>
<enabled>Y</enabled>
<name>LINES_READ</name>
<subject/>
</field>
<field>
<id>LINES_WRITTEN</id>
<enabled>Y</enabled>
<name>LINES_WRITTEN</name>
<subject/>
</field>
<field>
<id>LINES_UPDATED</id>
<enabled>Y</enabled>
<name>LINES_UPDATED</name>
<subject/>
</field>
<field>
<id>LINES_INPUT</id>
<enabled>Y</enabled>
<name>LINES_INPUT</name>
<subject/>
</field>
<field>
<id>LINES_OUTPUT</id>
<enabled>Y</enabled>
<name>LINES_OUTPUT</name>
<subject/>
</field>
<field>
<id>LINES_REJECTED</id>
<enabled>N</enabled>
<name>LINES_REJECTED</name>
<subject/>
</field>
<field>
<id>ERRORS</id>
<enabled>Y</enabled>
<name>ERRORS</name>
</field>
<field>
<id>STARTDATE</id>
<enabled>Y</enabled>
<name>STARTDATE</name>
</field>
<field>
<id>ENDDATE</id>
<enabled>Y</enabled>
<name>ENDDATE</name>
</field>
<field>
<id>LOGDATE</id>
<enabled>Y</enabled>
<name>LOGDATE</name>
</field>
<field>
<id>DEPDATE</id>
<enabled>Y</enabled>
<name>DEPDATE</name>
</field>
<field>
<id>REPLAYDATE</id>
<enabled>Y</enabled>
<name>REPLAYDATE</name>
</field>
<field>
<id>LOG_FIELD</id>
<enabled>N</enabled>
<name>LOG_FIELD</name>
</field>
<field>
<id>EXECUTING_SERVER</id>
<enabled>N</enabled>
<name>EXECUTING_SERVER</name>
</field>
<field>
<id>EXECUTING_USER</id>
<enabled>N</enabled>
<name>EXECUTING_USER</name>
</field>
<field>
<id>CLIENT</id>
<enabled>N</enabled>
<name>CLIENT</name>
</field>
</pipeline-log-table>
<perf-log-table>
<connection/>
<schema/>
<table/>
<interval/>
<timeout_days/>
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>SEQ_NR</id>
<enabled>Y</enabled>
<name>SEQ_NR</name>
</field>
<field>
<id>LOGDATE</id>
<enabled>Y</enabled>
<name>LOGDATE</name>
</field>
<field>
<id>TRANSNAME</id>
<enabled>Y</enabled>
<name>TRANSNAME</name>
</field>
<field>
<id>STEPNAME</id>
<enabled>Y</enabled>
<name>STEPNAME</name>
</field>
<field>
<id>STEP_COPY</id>
<enabled>Y</enabled>
<name>STEP_COPY</name>
</field>
<field>
<id>LINES_READ</id>
<enabled>Y</enabled>
<name>LINES_READ</name>
</field>
<field>
<id>LINES_WRITTEN</id>
<enabled>Y</enabled>
<name>LINES_WRITTEN</name>
</field>
<field>
<id>LINES_UPDATED</id>
<enabled>Y</enabled>
<name>LINES_UPDATED</name>
</field>
<field>
<id>LINES_INPUT</id>
<enabled>Y</enabled>
<name>LINES_INPUT</name>
</field>
<field>
<id>LINES_OUTPUT</id>
<enabled>Y</enabled>
<name>LINES_OUTPUT</name>
</field>
<field>
<id>LINES_REJECTED</id>
<enabled>Y</enabled>
<name>LINES_REJECTED</name>
</field>
<field>
<id>ERRORS</id>
<enabled>Y</enabled>
<name>ERRORS</name>
</field>
<field>
<id>INPUT_BUFFER_ROWS</id>
<enabled>Y</enabled>
<name>INPUT_BUFFER_ROWS</name>
</field>
<field>
<id>OUTPUT_BUFFER_ROWS</id>
<enabled>Y</enabled>
<name>OUTPUT_BUFFER_ROWS</name>
</field>
</perf-log-table>
<channel-log-table>
<connection/>
<schema/>
<table/>
<timeout_days/>
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>Y</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>LOG_DATE</id>
<enabled>Y</enabled>
<name>LOG_DATE</name>
</field>
<field>
<id>LOGGING_OBJECT_TYPE</id>
<enabled>Y</enabled>
<name>LOGGING_OBJECT_TYPE</name>
</field>
<field>
<id>OBJECT_NAME</id>
<enabled>Y</enabled>
<name>OBJECT_NAME</name>
</field>
<field>
<id>OBJECT_COPY</id>
<enabled>Y</enabled>
<name>OBJECT_COPY</name>
</field>
<field>
<id>REPOSITORY_DIRECTORY</id>
<enabled>Y</enabled>
<name>REPOSITORY_DIRECTORY</name>
</field>
<field>
<id>FILENAME</id>
<enabled>Y</enabled>
<name>FILENAME</name>
</field>
<field>
<id>OBJECT_ID</id>
<enabled>Y</enabled>
<name>OBJECT_ID</name>
</field>
<field>
<id>OBJECT_REVISION</id>
<enabled>Y</enabled>
<name>OBJECT_REVISION</name>
</field>
<field>
<id>PARENT_CHANNEL_ID</id>
<enabled>Y</enabled>
<name>PARENT_CHANNEL_ID</name>
</field>
<field>
<id>ROOT_CHANNEL_ID</id>
<enabled>Y</enabled>
<name>ROOT_CHANNEL_ID</name>
</field>
</channel-log-table>
<transform-log-table>
<connection/>
<schema/>
<table/>
<timeout_days/>
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>Y</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>LOG_DATE</id>
<enabled>Y</enabled>
<name>LOG_DATE</name>
</field>
<field>
<id>TRANSNAME</id>
<enabled>Y</enabled>
<name>TRANSNAME</name>
</field>
<field>
<id>STEPNAME</id>
<enabled>Y</enabled>
<name>STEPNAME</name>
</field>
<field>
<id>STEP_COPY</id>
<enabled>Y</enabled>
<name>STEP_COPY</name>
</field>
<field>
<id>LINES_READ</id>
<enabled>Y</enabled>
<name>LINES_READ</name>
</field>
<field>
<id>LINES_WRITTEN</id>
<enabled>Y</enabled>
<name>LINES_WRITTEN</name>
</field>
<field>
<id>LINES_UPDATED</id>
<enabled>Y</enabled>
<name>LINES_UPDATED</name>
</field>
<field>
<id>LINES_INPUT</id>
<enabled>Y</enabled>
<name>LINES_INPUT</name>
</field>
<field>
<id>LINES_OUTPUT</id>
<enabled>Y</enabled>
<name>LINES_OUTPUT</name>
</field>
<field>
<id>LINES_REJECTED</id>
<enabled>Y</enabled>
<name>LINES_REJECTED</name>
</field>
<field>
<id>ERRORS</id>
<enabled>Y</enabled>
<name>ERRORS</name>
</field>
<field>
<id>LOG_FIELD</id>
<enabled>N</enabled>
<name>LOG_FIELD</name>
</field>
</transform-log-table>
<metrics-log-table>
<connection/>
<schema/>
<table/>
<timeout_days/>
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>Y</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>LOG_DATE</id>
<enabled>Y</enabled>
<name>LOG_DATE</name>
</field>
<field>
<id>METRICS_DATE</id>
<enabled>Y</enabled>
<name>METRICS_DATE</name>
</field>
<field>
<id>METRICS_CODE</id>
<enabled>Y</enabled>
<name>METRICS_CODE</name>
</field>
<field>
<id>METRICS_DESCRIPTION</id>
<enabled>Y</enabled>
<name>METRICS_DESCRIPTION</name>
</field>
<field>
<id>METRICS_SUBJECT</id>
<enabled>Y</enabled>
<name>METRICS_SUBJECT</name>
</field>
<field>
<id>METRICS_TYPE</id>
<enabled>Y</enabled>
<name>METRICS_TYPE</name>
</field>
<field>
<id>METRICS_VALUE</id>
<enabled>Y</enabled>
<name>METRICS_VALUE</name>
</field>
</metrics-log-table>
</log>
<maxdate>
<connection/>
<table/>
<field/>
<offset>0.0</offset>
<maxdiff>0.0</maxdiff>
</maxdate>
<size_rowset>1000</size_rowset>
<sleep_time_empty>1</sleep_time_empty>
<sleep_time_full>1</sleep_time_full>
<unique_connections>N</unique_connections>
<feedback_shown>Y</feedback_shown>
<feedback_size>5000</feedback_size>
<using_thread_priorities>Y</using_thread_priorities>
<shared_objects_file/>
<capture_transform_performance>N</capture_transform_performance>
<transform_performance_capturing_delay>1000</transform_performance_capturing_delay>
<transform_performance_capturing_size_limit/>
<dependencies>
</dependencies>
<partitionschemas>
</partitionschemas>
<slaveservers>
<slaveserver>
<name>CARTE</name>
<hostname>&#x24;&#x7b;CARTE_HOSTNAME&#x7d;</hostname>
<port>&#x24;&#x7b;CARTE_PORT&#x7d;</port>
<webAppName/>
<username>&#x24;&#x7b;CARTE_USER&#x7d;</username>
<password>&#x24;&#x7b;CARTE_PWD&#x7d;</password> <proxy_hostname>&#x24;&#x7b;CARTE_PROXY_HOST&#x7d;</proxy_hostname>
<proxy_port>&#x24;&#x7b;CARTE_PROXY_PORT&#x7d;</proxy_port>
<non_proxy_hosts>&#x24;&#x7b;CARTE_NON_PROXY&#x7d;</non_proxy_hosts>
<master>Y</master>
<sslMode>N</sslMode> </slaveserver>
</slaveservers>
<clusterschemas>
</clusterschemas>
<created_user/>
<created_date>2010&#x2f;10&#x2f;08 15&#x3a;51&#x3a;58.308</created_date>
<modified_user/>
<modified_date>2007&#x2f;09&#x2f;11 21&#x3a;34&#x3a;50.919</modified_date>
<key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA&#x3d;</key_for_session_key>
<is_key_private>N</is_key_private>
</info>
<notepads>
<notepad>
<note>XML&#x2f;KTR Source</note>
<xloc>78</xloc>
<yloc>160</yloc>
<width>110</width>
<heigth>25</heigth>
<fontname>Arial</fontname>
<fontsize>10</fontsize>
<fontbold>N</fontbold>
<fontitalic>N</fontitalic>
<fontcolorred>0</fontcolorred>
<fontcolorgreen>0</fontcolorgreen>
<fontcolorblue>0</fontcolorblue>
<backgroundcolorred>255</backgroundcolorred>
<backgroundcolorgreen>165</backgroundcolorgreen>
<backgroundcolorblue>0</backgroundcolorblue>
<bordercolorred>100</bordercolorred>
<bordercolorgreen>100</bordercolorgreen>
<bordercolorblue>100</bordercolorblue>
<drawshadow>Y</drawshadow>
</notepad>
</notepads>
<order>
<hop>
<from>Data Grid</from>
<to>User Defined Java Class</to>
<enabled>Y</enabled>
</hop>
</order>
<transform>
<name>Data Grid</name>
<type>DataGrid</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<fields>
<field>
<name>xml</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<length>-1</length>
<precision>-1</precision>
<set_empty_string>N</set_empty_string>
</field>
</fields>
<data>
<line> <item>&#x3c;&#x3f;xml version&#x3d;&#x22;1.0&#x22; encoding&#x3d;&#x22;UTF-8&#x22;&#x3f;&#x3e;&#xa;&#x3c;transformation&#x3e;&#xa; &#x3c;info&#x3e;&#xa; &#x3c;name&#x2f;&#x3e;&#xa; &#x3c;directory&#x3e;&#x26;&#x23;47&#x3b;&#x3c;&#x2f;directory&#x3e;&#xa; &#x3c;log&#x3e;&#xa; &#x3c;read&#x2f;&#x3e;&#xa; &#x3c;write&#x2f;&#x3e;&#xa; &#x3c;input&#x2f;&#x3e;&#xa; &#x3c;output&#x2f;&#x3e;&#xa; &#x3c;update&#x2f;&#x3e;&#xa; &#x3c;connection&#x2f;&#x3e;&#xa; &#x3c;table&#x2f;&#x3e;&#xa; &#x3c;use_batchid&#x3e;Y&#x3c;&#x2f;use_batchid&#x3e;&#xa; &#x3c;use_logfield&#x3e;N&#x3c;&#x2f;use_logfield&#x3e;&#xa; &#x3c;&#x2f;log&#x3e;&#xa; &#x3c;maxdate&#x3e;&#xa; &#x3c;connection&#x2f;&#x3e;&#xa; &#x3c;table&#x2f;&#x3e;&#xa; &#x3c;field&#x2f;&#x3e;&#xa; &#x3c;offset&#x3e;0.0&#x3c;&#x2f;offset&#x3e;&#xa; &#x3c;maxdiff&#x3e;0.0&#x3c;&#x2f;maxdiff&#x3e;&#xa; &#x3c;&#x2f;maxdate&#x3e;&#xa; &#x3c;size_rowset&#x3e;1000&#x3c;&#x2f;size_rowset&#x3e;&#xa; &#x3c;sleep_time_empty&#x3e;1&#x3c;&#x2f;sleep_time_empty&#x3e;&#xa; &#x3c;sleep_time_full&#x3e;1&#x3c;&#x2f;sleep_time_full&#x3e;&#xa; &#x3c;unique_connections&#x3e;N&#x3c;&#x2f;unique_connections&#x3e;&#xa; &#x3c;feedback_shown&#x3e;Y&#x3c;&#x2f;feedback_shown&#x3e;&#xa; &#x3c;feedback_size&#x3e;5000&#x3c;&#x2f;feedback_size&#x3e;&#xa; &#x3c;dependencies&#x3e;&#xa; &#x3c;&#x2f;dependencies&#x3e;&#xa; &#x3c;partitionschemas&#x3e;&#xa; &#x3c;&#x2f;partitionschemas&#x3e;&#xa; &#x3c;modified_user&#x3e;-&#x3c;&#x2f;modified_user&#x3e;&#xa; &#x3c;modified_date&#x3e;2006&#x26;&#x23;47&#x3b;10&#x26;&#x23;47&#x3b;24 11&#x3a;39&#x3a;02.963&#x3c;&#x2f;modified_date&#x3e;&#xa; &#x3c;&#x2f;info&#x3e;&#xa; &#x3c;notepads&#x3e;&#xa; &#x3c;notepad&#x3e;&#xa; &#x3c;note&#x3e;If you do a preview on the Result transform you will note that the generated ID is unique.&#xa;If you specify another counter name in either of the sequence generator transforms, you will get duplicates.&#xa;&#xa;Step &#x26;quot&#x3b;Generate Rows&#x26;quot&#x3b; does not actually produce output. It creates 1000 empty lines and splits them evenly&#xa;before they reach the two &#x26;quot&#x3b;Generate ID&#x26;quot&#x3b; transforms &#x28;transform type &#x26;quot&#x3b;sequence generator&#x26;quot&#x3b;&#x29;. Both sequence generators&#xa;do have the same &#x26;quot&#x3b;Counter name&#x26;quot&#x3b; &#x28;double click to edit and see the &#x26;quot&#x3b;Counter name&#x26;quot&#x3b; value&#x29;. That makes the&#xa;generated ids unique, even though they are produced by two different sequence generators.&#x3c;&#x2f;note&#x3e;&#xa; &#x3c;xloc&#x3e;32&#x3c;&#x2f;xloc&#x3e;&#xa; &#x3c;yloc&#x3e;28&#x3c;&#x2f;yloc&#x3e;&#xa; &#x3c;width&#x3e;535&#x3c;&#x2f;width&#x3e;&#xa; &#x3c;heigth&#x3e;101&#x3c;&#x2f;heigth&#x3e;&#xa; &#x3c;&#x2f;notepad&#x3e;&#xa; &#x3c;notepad&#x3e;&#xa; &#x3c;note&#x3e;You basically get the same result if you have 2 row generators &#x28;both generating 20 lines, with no&#xa;actual output&#x29; that are linked to two ID sequence generators. Both ID sequence generators have got the&#xa;same &#x26;quot&#x3b;counter name&#x26;quot&#x3b; and thus the finally created IDs are unique. The difference to the example above is&#xa;that the generated IDs are in order &#x28;enumerated from 1..40&#x29;.&#x3c;&#x2f;note&#x3e;&#xa; &#x3c;xloc&#x3e;45&#x3c;&#x2f;xloc&#x3e;&#xa; &#x3c;yloc&#x3e;472&#x3c;&#x2f;yloc&#x3e;&#xa; &#x3c;width&#x3e;516&#x3c;&#x2f;width&#x3e;&#xa; &#x3c;heigth&#x3e;62&#x3c;&#x2f;heigth&#x3e;&#xa; &#x3c;&#x2f;notepad&#x3e;&#xa; &#x3c;&#x2f;notepads&#x3e;&#xa; &#x3c;order&#x3e;&#xa; &#x3c;hop&#x3e; &#x3c;from&#x3e;Generate Rows&#x3c;&#x2f;from&#x3e;&#x3c;to&#x3e;Generate ID&#x3c;&#x2f;to&#x3e;&#x3c;enabled&#x3e;Y&#x3c;&#x2f;enabled&#x3e; &#x3c;&#x2f;hop&#x3e; &#x3c;hop&#x3e; &#x3c;from&#x3e;Generate ID&#x3c;&#x2f;from&#x3e;&#x3c;to&#x3e;Result&#x3c;&#x2f;to&#x3e;&#x3c;enabled&#x3e;Y&#x3c;&#x2f;enabled&#x3e; &#x3c;&#x2f;hop&#x3e; &#x3c;hop&#x3e; &#x3c;from&#x3e;Generate ID &#x28;2&#x29;&#x3c;&#x2f;from&#x3e;&#x3c;to&#x3e;Result&#x3c;&#x2f;to&#x3e;&#x3c;enabled&#x3e;Y&#x3c;&#x2f;enabled&#x3e; &#x3c;&#x2f;hop&#x3e; &#x3c;hop&#x3e; &#x3c;from&#x3e;Generate Rows&#x3c;&#x2f;from&#x3e;&#x3c;to&#x3e;Generate ID &#x28;2&#x29;&#x3c;&#x2f;to&#x3e;&#x3c;enabled&#x3e;Y&#x3c;&#x2f;enabled&#x3e; &#x3c;&#x2f;hop&#x3e; &#x3c;hop&#x3e; &#x3c;from&#x3e;Row Gen &#x5b;1&#x5d;&#x3c;&#x2f;from&#x3e;&#x3c;to&#x3e;Gen ID &#x5b;1&#x5d;&#x3c;&#x2f;to&#x3e;&#x3c;enabled&#x3e;Y&#x3c;&#x2f;enabled&#x3e; &#x3c;&#x2f;hop&#x3e; &#x3c;hop&#x3e; &#x3c;from&#x3e;Row Gen &#x5b;2&#x5d;&#x3c;&#x2f;from&#x3e;&#x3c;to&#x3e;Gen ID &#x5b;2&#x5d;&#x3c;&#x2f;to&#x3e;&#x3c;enabled&#x3e;Y&#x3c;&#x2f;enabled&#x3e; &#x3c;&#x2f;hop&#x3e; &#x3c;hop&#x3e; &#x3c;from&#x3e;Gen ID &#x5b;1&#x5d;&#x3c;&#x2f;from&#x3e;&#x3c;to&#x3e;Result 2&#x3c;&#x2f;to&#x3e;&#x3c;enabled&#x3e;Y&#x3c;&#x2f;enabled&#x3e; &#x3c;&#x2f;hop&#x3e; &#x3c;hop&#x3e; &#x3c;from&#x3e;Gen ID &#x5b;2&#x5d;&#x3c;&#x2f;from&#x3e;&#x3c;to&#x3e;Result 2&#x3c;&#x2f;to&#x3e;&#x3c;enabled&#x3e;Y&#x3c;&#x2f;enabled&#x3e; &#x3c;&#x2f;hop&#x3e; &#x3c;&#x2f;order&#x3e;&#xa;&#xa; &#x3c;transform&#x3e;&#xa; &#x3c;name&#x3e;Generate ID&#x3c;&#x2f;name&#x3e;&#xa; &#x3c;type&#x3e;Sequence&#x3c;&#x2f;type&#x3e;&#xa; &#x3c;description&#x2f;&#x3e;&#xa; &#x3c;distribute&#x3e;Y&#x3c;&#x2f;distribute&#x3e;&#xa; &#x3c;copies&#x3e;1&#x3c;&#x2f;copies&#x3e;&#xa; &#x3c;partitioning&#x3e;&#xa; &#x3c;method&#x3e;none&#x3c;&#x2f;method&#x3e;&#xa; &#x3c;field_name&#x2f;&#x3e;&#xa; &#x3c;schema_name&#x2f;&#x3e;&#xa; &#x3c;&#x2f;partitioning&#x3e;&#xa; &#x3c;valuename&#x3e;ID&#x3c;&#x2f;valuename&#x3e;&#xa; &#x3c;use_database&#x3e;N&#x3c;&#x2f;use_database&#x3e;&#xa; &#x3c;connection&#x2f;&#x3e;&#xa; &#x3c;seqname&#x3e;SEQ_&#x3c;&#x2f;seqname&#x3e;&#xa; &#x3c;use_counter&#x3e;Y&#x3c;&#x2f;use_counter&#x3e;&#xa; &#x3c;counter_name&#x3e;id-counter&#x3c;&#x2f;counter_name&#x3e;&#xa; &#x3c;start_at&#x3e;1&#x3c;&#x2f;start_at&#x3e;&#xa; &#x3c;increment_by&#x3e;1&#x3c;&#x2f;increment_by&#x3e;&#xa; &#x3c;max_value&#x3e;9999999&#x3c;&#x2f;max_value&#x3e;&#xa; &#x3c;GUI&#x3e;&#xa; &#x3c;xloc&#x3e;355&#x3c;&#x2f;xloc&#x3e;&#xa; &#x3c;yloc&#x3e;179&#x3c;&#x2f;yloc&#x3e;&#xa; &#x3c;draw&#x3e;Y&#x3c;&#x2f;draw&#x3e;&#xa; &#x3c;&#x2f;GUI&#x3e;&#xa; &#x3c;&#x2f;transform&#x3e;&#xa;&#xa; &#x3c;transform&#x3e;&#xa; &#x3c;name&#x3e;Generate ID &#x28;2&#x29;&#x3c;&#x2f;name&#x3e;&#xa; &#x3c;type&#x3e;Sequence&#x3c;&#x2f;type&#x3e;&#xa; &#x3c;description&#x2f;&#x3e;&#xa; &#x3c;distribute&#x3e;Y&#x3c;&#x2f;distribute&#x3e;&#xa; &#x3c;copies&#x3e;1&#x3c;&#x2f;copies&#x3e;&#xa; &#x3c;partitioning&#x3e;&#xa; &#x3c;method&#x3e;none&#x3c;&#x2f;method&#x3e;&#xa; &#x3c;field_name&#x2f;&#x3e;&#xa; &#x3c;schema_name&#x2f;&#x3e;&#xa; &#x3c;&#x2f;partitioning&#x3e;&#xa; &#x3c;valuename&#x3e;ID&#x3c;&#x2f;valuename&#x3e;&#xa; &#x3c;use_database&#x3e;N&#x3c;&#x2f;use_database&#x3e;&#xa; &#x3c;connection&#x2f;&#x3e;&#xa; &#x3c;seqname&#x3e;SEQ_&#x3c;&#x2f;seqname&#x3e;&#xa; &#x3c;use_counter&#x3e;Y&#x3c;&#x2f;use_counter&#x3e;&#xa; &#x3c;counter_name&#x3e;id-counter&#x3c;&#x2f;counter_name&#x3e;&#xa; &#x3c;start_at&#x3e;1&#x3c;&#x2f;start_at&#x3e;&#xa; &#x3c;increment_by&#x3e;1&#x3c;&#x2f;increment_by&#x3e;&#xa; &#x3c;max_value&#x3e;9999999&#x3c;&#x2f;max_value&#x3e;&#xa; &#x3c;GUI&#x3e;&#xa; &#x3c;xloc&#x3e;360&#x3c;&#x2f;xloc&#x3e;&#xa; &#x3c;yloc&#x3e;361&#x3c;&#x2f;yloc&#x3e;&#xa; &#x3c;draw&#x3e;Y&#x3c;&#x2f;draw&#x3e;&#xa; &#x3c;&#x2f;GUI&#x3e;&#xa; &#x3c;&#x2f;transform&#x3e;&#xa;&#xa; &#x3c;transform&#x3e;&#xa; &#x3c;name&#x3e;Generate Rows&#x3c;&#x2f;name&#x3e;&#xa; &#x3c;type&#x3e;RowGenerator&#x3c;&#x2f;type&#x3e;&#xa; &#x3c;description&#x2f;&#x3e;&#xa; &#x3c;distribute&#x3e;Y&#x3c;&#x2f;distribute&#x3e;&#xa; &#x3c;copies&#x3e;1&#x3c;&#x2f;copies&#x3e;&#xa; &#x3c;partitioning&#x3e;&#xa; &#x3c;method&#x3e;none&#x3c;&#x2f;method&#x3e;&#xa; &#x3c;field_name&#x2f;&#x3e;&#xa; &#x3c;schema_name&#x2f;&#x3e;&#xa; &#x3c;&#x2f;partitioning&#x3e;&#xa; &#x3c;fields&#x3e;&#xa; &#x3c;&#x2f;fields&#x3e;&#xa; &#x3c;limit&#x3e;40&#x3c;&#x2f;limit&#x3e;&#xa; &#x3c;GUI&#x3e;&#xa; &#x3c;xloc&#x3e;188&#x3c;&#x2f;xloc&#x3e;&#xa; &#x3c;yloc&#x3e;267&#x3c;&#x2f;yloc&#x3e;&#xa; &#x3c;draw&#x3e;Y&#x3c;&#x2f;draw&#x3e;&#xa; &#x3c;&#x2f;GUI&#x3e;&#xa; &#x3c;&#x2f;transform&#x3e;&#xa;&#xa; &#x3c;transform&#x3e;&#xa; &#x3c;name&#x3e;Result&#x3c;&#x2f;name&#x3e;&#xa; &#x3c;type&#x3e;Dummy&#x3c;&#x2f;type&#x3e;&#xa; &#x3c;description&#x2f;&#x3e;&#xa; &#x3c;distribute&#x3e;Y&#x3c;&#x2f;distribute&#x3e;&#xa; &#x3c;copies&#x3e;1&#x3c;&#x2f;copies&#x3e;&#xa; &#x3c;partitioning&#x3e;&#xa; &#x3c;method&#x3e;none&#x3c;&#x2f;method&#x3e;&#xa; &#x3c;field_name&#x2f;&#x3e;&#xa; &#x3c;schema_name&#x2f;&#x3e;&#xa; &#x3c;&#x2f;partitioning&#x3e;&#xa; &#x3c;GUI&#x3e;&#xa; &#x3c;xloc&#x3e;563&#x3c;&#x2f;xloc&#x3e;&#xa; &#x3c;yloc&#x3e;251&#x3c;&#x2f;yloc&#x3e;&#xa; &#x3c;draw&#x3e;Y&#x3c;&#x2f;draw&#x3e;&#xa; &#x3c;&#x2f;GUI&#x3e;&#xa; &#x3c;&#x2f;transform&#x3e;&#xa;&#xa; &#x3c;transform&#x3e;&#xa; &#x3c;name&#x3e;Row Gen &#x5b;1&#x5d;&#x3c;&#x2f;name&#x3e;&#xa; &#x3c;type&#x3e;RowGenerator&#x3c;&#x2f;type&#x3e;&#xa; &#x3c;description&#x2f;&#x3e;&#xa; &#x3c;distribute&#x3e;Y&#x3c;&#x2f;distribute&#x3e;&#xa; &#x3c;copies&#x3e;1&#x3c;&#x2f;copies&#x3e;&#xa; &#x3c;partitioning&#x3e;&#xa; &#x3c;method&#x3e;none&#x3c;&#x2f;method&#x3e;&#xa; &#x3c;field_name&#x2f;&#x3e;&#xa; &#x3c;schema_name&#x2f;&#x3e;&#xa; &#x3c;&#x2f;partitioning&#x3e;&#xa; &#x3c;fields&#x3e;&#xa; &#x3c;&#x2f;fields&#x3e;&#xa; &#x3c;limit&#x3e;20&#x3c;&#x2f;limit&#x3e;&#xa; &#x3c;GUI&#x3e;&#xa; &#x3c;xloc&#x3e;158&#x3c;&#x2f;xloc&#x3e;&#xa; &#x3c;yloc&#x3e;631&#x3c;&#x2f;yloc&#x3e;&#xa; &#x3c;draw&#x3e;Y&#x3c;&#x2f;draw&#x3e;&#xa; &#x3c;&#x2f;GUI&#x3e;&#xa; &#x3c;&#x2f;transform&#x3e;&#xa;&#xa; &#x3c;transform&#x3e;&#xa; &#x3c;name&#x3e;Row Gen &#x5b;2&#x5d;&#x3c;&#x2f;name&#x3e;&#xa; &#x3c;type&#x3e;RowGenerator&#x3c;&#x2f;type&#x3e;&#xa; &#x3c;description&#x2f;&#x3e;&#xa; &#x3c;distribute&#x3e;Y&#x3c;&#x2f;distribute&#x3e;&#xa; &#x3c;copies&#x3e;1&#x3c;&#x2f;copies&#x3e;&#xa; &#x3c;partitioning&#x3e;&#xa; &#x3c;method&#x3e;none&#x3c;&#x2f;method&#x3e;&#xa; &#x3c;field_name&#x2f;&#x3e;&#xa; &#x3c;schema_name&#x2f;&#x3e;&#xa; &#x3c;&#x2f;partitioning&#x3e;&#xa; &#x3c;fields&#x3e;&#xa; &#x3c;&#x2f;fields&#x3e;&#xa; &#x3c;limit&#x3e;20&#x3c;&#x2f;limit&#x3e;&#xa; &#x3c;GUI&#x3e;&#xa; &#x3c;xloc&#x3e;157&#x3c;&#x2f;xloc&#x3e;&#xa; &#x3c;yloc&#x3e;698&#x3c;&#x2f;yloc&#x3e;&#xa; &#x3c;draw&#x3e;Y&#x3c;&#x2f;draw&#x3e;&#xa; &#x3c;&#x2f;GUI&#x3e;&#xa; &#x3c;&#x2f;transform&#x3e;&#xa;&#xa; &#x3c;transform&#x3e;&#xa; &#x3c;name&#x3e;Gen ID &#x5b;1&#x5d;&#x3c;&#x2f;name&#x3e;&#xa; &#x3c;type&#x3e;Sequence&#x3c;&#x2f;type&#x3e;&#xa; &#x3c;description&#x2f;&#x3e;&#xa; &#x3c;distribute&#x3e;Y&#x3c;&#x2f;distribute&#x3e;&#xa; &#x3c;copies&#x3e;1&#x3c;&#x2f;copies&#x3e;&#xa; &#x3c;partitioning&#x3e;&#xa; &#x3c;method&#x3e;none&#x3c;&#x2f;method&#x3e;&#xa; &#x3c;field_name&#x2f;&#x3e;&#xa; &#x3c;schema_name&#x2f;&#x3e;&#xa; &#x3c;&#x2f;partitioning&#x3e;&#xa; &#x3c;valuename&#x3e;AnotherID&#x3c;&#x2f;valuename&#x3e;&#xa; &#x3c;use_database&#x3e;N&#x3c;&#x2f;use_database&#x3e;&#xa; &#x3c;connection&#x2f;&#x3e;&#xa; &#x3c;seqname&#x3e;SEQ_&#x3c;&#x2f;seqname&#x3e;&#xa; &#x3c;use_counter&#x3e;Y&#x3c;&#x2f;use_counter&#x3e;&#xa; &#x3c;counter_name&#x3e;another-counter&#x3c;&#x2f;counter_name&#x3e;&#xa; &#x3c;start_at&#x3e;1&#x3c;&#x2f;start_at&#x3e;&#xa; &#x3c;increment_by&#x3e;1&#x3c;&#x2f;increment_by&#x3e;&#xa; &#x3c;max_value&#x3e;9999999&#x3c;&#x2f;max_value&#x3e;&#xa; &#x3c;GUI&#x3e;&#xa; &#x3c;xloc&#x3e;352&#x3c;&#x2f;xloc&#x3e;&#xa; &#x3c;yloc&#x3e;576&#x3c;&#x2f;yloc&#x3e;&#xa; &#x3c;draw&#x3e;Y&#x3c;&#x2f;draw&#x3e;&#xa; &#x3c;&#x2f;GUI&#x3e;&#xa; &#x3c;&#x2f;transform&#x3e;&#xa;&#xa; &#x3c;transform&#x3e;&#xa; &#x3c;name&#x3e;Gen ID &#x5b;2&#x5d;&#x3c;&#x2f;name&#x3e;&#xa; &#x3c;type&#x3e;Sequence&#x3c;&#x2f;type&#x3e;&#xa; &#x3c;description&#x2f;&#x3e;&#xa; &#x3c;distribute&#x3e;Y&#x3c;&#x2f;distribute&#x3e;&#xa; &#x3c;copies&#x3e;1&#x3c;&#x2f;copies&#x3e;&#xa; &#x3c;partitioning&#x3e;&#xa; &#x3c;method&#x3e;none&#x3c;&#x2f;method&#x3e;&#xa; &#x3c;field_name&#x2f;&#x3e;&#xa; &#x3c;schema_name&#x2f;&#x3e;&#xa; &#x3c;&#x2f;partitioning&#x3e;&#xa; &#x3c;valuename&#x3e;AnotherID&#x3c;&#x2f;valuename&#x3e;&#xa; &#x3c;use_database&#x3e;N&#x3c;&#x2f;use_database&#x3e;&#xa; &#x3c;connection&#x2f;&#x3e;&#xa; &#x3c;seqname&#x3e;SEQ_&#x3c;&#x2f;seqname&#x3e;&#xa; &#x3c;use_counter&#x3e;Y&#x3c;&#x2f;use_counter&#x3e;&#xa; &#x3c;counter_name&#x3e;another-counter&#x3c;&#x2f;counter_name&#x3e;&#xa; &#x3c;start_at&#x3e;1&#x3c;&#x2f;start_at&#x3e;&#xa; &#x3c;increment_by&#x3e;1&#x3c;&#x2f;increment_by&#x3e;&#xa; &#x3c;max_value&#x3e;9999999&#x3c;&#x2f;max_value&#x3e;&#xa; &#x3c;GUI&#x3e;&#xa; &#x3c;xloc&#x3e;351&#x3c;&#x2f;xloc&#x3e;&#xa; &#x3c;yloc&#x3e;736&#x3c;&#x2f;yloc&#x3e;&#xa; &#x3c;draw&#x3e;Y&#x3c;&#x2f;draw&#x3e;&#xa; &#x3c;&#x2f;GUI&#x3e;&#xa; &#x3c;&#x2f;transform&#x3e;&#xa;&#xa; &#x3c;transform&#x3e;&#xa; &#x3c;name&#x3e;Result 2&#x3c;&#x2f;name&#x3e;&#xa; &#x3c;type&#x3e;Dummy&#x3c;&#x2f;type&#x3e;&#xa; &#x3c;description&#x2f;&#x3e;&#xa; &#x3c;distribute&#x3e;Y&#x3c;&#x2f;distribute&#x3e;&#xa; &#x3c;copies&#x3e;1&#x3c;&#x2f;copies&#x3e;&#xa; &#x3c;partitioning&#x3e;&#xa; &#x3c;method&#x3e;none&#x3c;&#x2f;method&#x3e;&#xa; &#x3c;field_name&#x2f;&#x3e;&#xa; &#x3c;schema_name&#x2f;&#x3e;&#xa; &#x3c;&#x2f;partitioning&#x3e;&#xa; &#x3c;GUI&#x3e;&#xa; &#x3c;xloc&#x3e;568&#x3c;&#x2f;xloc&#x3e;&#xa; &#x3c;yloc&#x3e;655&#x3c;&#x2f;yloc&#x3e;&#xa; &#x3c;draw&#x3e;Y&#x3c;&#x2f;draw&#x3e;&#xa; &#x3c;&#x2f;GUI&#x3e;&#xa; &#x3c;&#x2f;transform&#x3e;&#xa;&#xa;&#x3c;&#x2f;transformation&#x3e;&#xa;</item> </line>
</data>
<cluster_schema/>
<input>
</input>
<output>
</output>
<GUI>
<xloc>110</xloc>
<yloc>95</yloc>
<draw>Y</draw>
</GUI>
</transform>
<transform>
<name>User Defined Java Class</name>
<type>UserDefinedJavaClass</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<definitions>
<definition>
<class_type>TRANSFORM_CLASS</class_type>
<class_name>Processor</class_name>
<class_source><![CDATA[import java.util.*;
import org.pentaho.di.core.xml.*;
import org.pentaho.di.pipeline.*;
import org.w3c.dom.*;
private int yearIndex;
private Calendar calendar;
public boolean processRow(StepMetaInterface smi, StepDataInterface sdi) throws KettleException
{
Object[] r=getRow();
if (r==null)
{
setOutputDone();
return false;
}
String ktr = getInputRowMeta().getString(r, "xml", null);
Document doc = XMLHandler.loadXMLString( ktr );
Node transNode = XMLHandler.getSubNode(doc, TransMeta.XML_TAG);
TransMeta pipelineMeta = new TransMeta(transNode, getTrans().getRepository());
Trans pipeline = new Trans(pipelineMeta, getTrans());
pipeline.execute( null );
// Just pass the input along
//
putRow(getInputRowMeta(), r);
return true;
}
]]></class_source>
</definition>
</definitions>
<fields>
</fields><clear_result_fields>N</clear_result_fields>
<info_transforms></info_transforms><target_transforms></target_transforms><usage_parameters></usage_parameters> <cluster_schema/>
<input>
</input>
<output>
</output>
<GUI>
<xloc>289</xloc>
<yloc>95</yloc>
<draw>Y</draw>
</GUI>
</transform>
<transform_error_handling>
</transform_error_handling>
<slave-transform-copy-partition-distribution>
</slave-transform-copy-partition-distribution>
<slave_transformation>N</slave_transformation>
</pipeline>