| <?xml version="1.0" encoding="UTF-8"?> |
| <!-- |
| |
| Licensed to the Apache Software Foundation (ASF) under one or more |
| contributor license agreements. See the NOTICE file distributed with |
| this work for additional information regarding copyright ownership. |
| The ASF licenses this file to You under the Apache License, Version 2.0 |
| (the "License"); you may not use this file except in compliance with |
| the License. You may obtain a copy of the License at |
| |
| http://www.apache.org/licenses/LICENSE-2.0 |
| |
| Unless required by applicable law or agreed to in writing, software |
| distributed under the License is distributed on an "AS IS" BASIS, |
| WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| See the License for the specific language governing permissions and |
| limitations under the License. |
| |
| --> |
| <pipeline> |
| <info> |
| <name>0014-insertupdate-parent</name> |
| <name_sync_with_filename>Y</name_sync_with_filename> |
| <description/> |
| <extended_description/> |
| <pipeline_version/> |
| <pipeline_type>Normal</pipeline_type> |
| <pipeline_status>0</pipeline_status> |
| <parameters> |
| <parameter> |
| <name>exportsFilePath</name> |
| <default_value>/Users/dcampen/exports/hop</default_value> |
| <description/> |
| </parameter> |
| <parameter> |
| <name>schema</name> |
| <default_value>dbo</default_value> |
| <description/> |
| </parameter> |
| <parameter> |
| <name>sqlObject</name> |
| <default_value>tenant</default_value> |
| <description/> |
| </parameter> |
| </parameters> |
| <capture_transform_performance>N</capture_transform_performance> |
| <transform_performance_capturing_delay>1000</transform_performance_capturing_delay> |
| <transform_performance_capturing_size_limit>100</transform_performance_capturing_size_limit> |
| <created_user>-</created_user> |
| <created_date>2021/10/04 08:31:32.273</created_date> |
| <modified_user>-</modified_user> |
| <modified_date>2021/10/04 08:31:32.273</modified_date> |
| <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> |
| <is_key_private>N</is_key_private> |
| </info> |
| <notepads> |
| </notepads> |
| <order> |
| <hop> |
| <from>Generate Rows</from> |
| <to>ETL Metadata Injection</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>Data grid</from> |
| <to>ETL Metadata Injection</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>ETL Metadata Injection</from> |
| <to>Dummy (do nothing)</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> |
| <set_empty_string>N</set_empty_string> |
| <length>-1</length> |
| <name>TableFieldName</name> |
| <precision>-1</precision> |
| <type>String</type> |
| </field> |
| <field> |
| <set_empty_string>N</set_empty_string> |
| <length>-1</length> |
| <name>StreamFieldName</name> |
| <precision>-1</precision> |
| <type>String</type> |
| </field> |
| <field> |
| <set_empty_string>N</set_empty_string> |
| <length>-1</length> |
| <name>UpdateFlag</name> |
| <precision>-1</precision> |
| <type>String</type> |
| </field> |
| </fields> |
| <data> |
| <line> |
| <item>id</item> |
| <item>keyInsertValue</item> |
| <item>N</item> |
| </line> |
| <line> |
| <item>uuid</item> |
| <item>valueInsert</item> |
| <item>Y</item> |
| </line> |
| </data> |
| <attributes/> |
| <GUI> |
| <xloc>288</xloc> |
| <yloc>304</yloc> |
| </GUI> |
| </transform> |
| <transform> |
| <name>ETL Metadata Injection</name> |
| <type>MetaInject</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <filename>${PROJECT_HOME}/0014-insertupdate-child.hpl</filename> |
| <source_transform/> |
| <source_output_fields> </source_output_fields> |
| <target_file/> |
| <no_execution>N</no_execution> |
| <stream_source_transform/> |
| <stream_target_transform>Dummy (do nothing)</stream_target_transform> |
| <mappings> |
| <mapping> |
| <target_transform_name>Insert new record</target_transform_name> |
| <target_attribute_key>UPDATE_LOOKUP</target_attribute_key> |
| <target_detail>Y</target_detail> |
| <source_transform>Data grid</source_transform> |
| <source_field>TableFieldName</source_field> |
| </mapping> |
| <mapping> |
| <target_transform_name>Update existing record</target_transform_name> |
| <target_attribute_key>UPDATE_LOOKUP</target_attribute_key> |
| <target_detail>Y</target_detail> |
| <source_transform>Generate Rows</source_transform> |
| <source_field>valueFieldName</source_field> |
| </mapping> |
| <mapping> |
| <target_transform_name>Update existing record</target_transform_name> |
| <target_attribute_key>KEY_CONDITION</target_attribute_key> |
| <target_detail>Y</target_detail> |
| <source_transform>Generate Rows</source_transform> |
| <source_field>keyComparator</source_field> |
| </mapping> |
| <mapping> |
| <target_transform_name>Update existing record</target_transform_name> |
| <target_attribute_key>UPDATE_STREAM</target_attribute_key> |
| <target_detail>Y</target_detail> |
| <source_transform>Generate Rows</source_transform> |
| <source_field>valueValue</source_field> |
| </mapping> |
| <mapping> |
| <target_transform_name>Insert new record</target_transform_name> |
| <target_attribute_key>KEY_STREAM</target_attribute_key> |
| <target_detail>Y</target_detail> |
| <source_transform>Generate Rows</source_transform> |
| <source_field>keyInsertValueField</source_field> |
| </mapping> |
| <mapping> |
| <target_transform_name>Update existing record</target_transform_name> |
| <target_attribute_key>KEY_STREAM</target_attribute_key> |
| <target_detail>Y</target_detail> |
| <source_transform>Generate Rows</source_transform> |
| <source_field>keyUpdateValueField</source_field> |
| </mapping> |
| <mapping> |
| <target_transform_name>Insert new record</target_transform_name> |
| <target_attribute_key>UPDATE_STREAM</target_attribute_key> |
| <target_detail>Y</target_detail> |
| <source_transform>Data grid</source_transform> |
| <source_field>StreamFieldName</source_field> |
| </mapping> |
| <mapping> |
| <target_transform_name>Insert new record</target_transform_name> |
| <target_attribute_key>KEY_CONDITION</target_attribute_key> |
| <target_detail>Y</target_detail> |
| <source_transform>Generate Rows</source_transform> |
| <source_field>keyComparator</source_field> |
| </mapping> |
| <mapping> |
| <target_transform_name>Update existing record</target_transform_name> |
| <target_attribute_key>TABLE_NAME</target_attribute_key> |
| <target_detail>N</target_detail> |
| <source_transform>Generate Rows</source_transform> |
| <source_field>tableName</source_field> |
| </mapping> |
| <mapping> |
| <target_transform_name>Update existing record</target_transform_name> |
| <target_attribute_key>UPDATE_FLAG</target_attribute_key> |
| <target_detail>Y</target_detail> |
| <source_transform>Generate Rows</source_transform> |
| <source_field>updateFlag</source_field> |
| </mapping> |
| <mapping> |
| <target_transform_name>Insert new record</target_transform_name> |
| <target_attribute_key>KEY_LOOKUP</target_attribute_key> |
| <target_detail>Y</target_detail> |
| <source_transform>Generate Rows</source_transform> |
| <source_field>keyFieldName</source_field> |
| </mapping> |
| <mapping> |
| <target_transform_name>Update existing record</target_transform_name> |
| <target_attribute_key>KEY_LOOKUP</target_attribute_key> |
| <target_detail>Y</target_detail> |
| <source_transform>Generate Rows</source_transform> |
| <source_field>keyFieldName</source_field> |
| </mapping> |
| <mapping> |
| <target_transform_name>Insert new record</target_transform_name> |
| <target_attribute_key>UPDATE_FLAG</target_attribute_key> |
| <target_detail>Y</target_detail> |
| <source_transform>Data grid</source_transform> |
| <source_field>UpdateFlag</source_field> |
| </mapping> |
| <mapping> |
| <target_transform_name>Insert new record</target_transform_name> |
| <target_attribute_key>TABLE_NAME</target_attribute_key> |
| <target_detail>N</target_detail> |
| <source_transform>Generate Rows</source_transform> |
| <source_field>tableName</source_field> |
| </mapping> |
| </mappings> |
| <attributes/> |
| <GUI> |
| <xloc>352</xloc> |
| <yloc>160</yloc> |
| </GUI> |
| </transform> |
| <transform> |
| <name>Generate Rows</name> |
| <type>RowGenerator</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <fields> |
| <field> |
| <length>-1</length> |
| <name>valueFieldName</name> |
| <precision>-1</precision> |
| <set_empty_string>N</set_empty_string> |
| <type>String</type> |
| <nullif>uuid</nullif> |
| </field> |
| <field> |
| <length>-1</length> |
| <name>valueValue</name> |
| <precision>-1</precision> |
| <set_empty_string>N</set_empty_string> |
| <type>String</type> |
| <nullif>valueUpdate</nullif> |
| </field> |
| <field> |
| <length>-1</length> |
| <name>keyComparator</name> |
| <precision>-1</precision> |
| <set_empty_string>N</set_empty_string> |
| <type>String</type> |
| <nullif>=</nullif> |
| </field> |
| <field> |
| <length>-1</length> |
| <name>updateFlag</name> |
| <precision>-1</precision> |
| <set_empty_string>N</set_empty_string> |
| <type>String</type> |
| <nullif>Y</nullif> |
| </field> |
| <field> |
| <length>-1</length> |
| <name>tableName</name> |
| <precision>-1</precision> |
| <set_empty_string>N</set_empty_string> |
| <type>String</type> |
| <nullif>dblu_uuid</nullif> |
| </field> |
| <field> |
| <length>-1</length> |
| <name>keyFieldName</name> |
| <precision>-1</precision> |
| <set_empty_string>N</set_empty_string> |
| <type>String</type> |
| <nullif>id</nullif> |
| </field> |
| <field> |
| <length>-1</length> |
| <name>keyUpdateValueField</name> |
| <precision>-1</precision> |
| <set_empty_string>N</set_empty_string> |
| <type>String</type> |
| <nullif>keyUpdateValue</nullif> |
| </field> |
| <field> |
| <length>-1</length> |
| <name>keyInsertValueField</name> |
| <precision>-1</precision> |
| <set_empty_string>N</set_empty_string> |
| <type>String</type> |
| <nullif>keyInsertValue</nullif> |
| </field> |
| </fields> |
| <interval_in_ms>5000</interval_in_ms> |
| <last_time_field>FiveSecondsAgo</last_time_field> |
| <never_ending>N</never_ending> |
| <limit>1</limit> |
| <row_time_field>now</row_time_field> |
| <attributes/> |
| <GUI> |
| <xloc>176</xloc> |
| <yloc>160</yloc> |
| </GUI> |
| </transform> |
| <transform> |
| <name>Dummy (do nothing)</name> |
| <type>Dummy</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <attributes/> |
| <GUI> |
| <xloc>560</xloc> |
| <yloc>160</yloc> |
| </GUI> |
| </transform> |
| <transform_error_handling> |
| </transform_error_handling> |
| <attributes/> |
| </pipeline> |