360lj_MemberdataETL/mem_Product_parent.ktr

<?xml version="1.0" encoding="UTF-8"?>
<transformation>
  <info>
    <name>mem_Product_parent</name>
    <description/>
    <extended_description/>
    <trans_version/>
    <trans_type>Normal</trans_type>
    <directory>/</directory>
    <parameters>
    </parameters>
    <log>
      <trans-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>Y</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>Y</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>Y</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>
      </trans-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>
      <step-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>
      </step-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>10000</size_rowset>
    <sleep_time_empty>50</sleep_time_empty>
    <sleep_time_full>50</sleep_time_full>
    <unique_connections>N</unique_connections>
    <feedback_shown>Y</feedback_shown>
    <feedback_size>50000</feedback_size>
    <using_thread_priorities>Y</using_thread_priorities>
    <shared_objects_file/>
    <capture_step_performance>N</capture_step_performance>
    <step_performance_capturing_delay>1000</step_performance_capturing_delay>
    <step_performance_capturing_size_limit>100</step_performance_capturing_size_limit>
    <dependencies>
    </dependencies>
    <partitionschemas>
    </partitionschemas>
    <slaveservers>
    </slaveservers>
    <clusterschemas>
    </clusterschemas>
    <created_user>-</created_user>
    <created_date>2019/05/16 17:49:47.596</created_date>
    <modified_user>-</modified_user>
    <modified_date>2019/05/16 17:49:47.596</modified_date>
    <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key>
    <is_key_private>N</is_key_private>
  </info>
  <notepads>
  </notepads>
  <connection>
    <name>testSqlserver</name>
    <server>192.168.20.122</server>
    <type>MSSQLNATIVE</type>
    <access>Native</access>
    <database>MemberData</database>
    <port>1433</port>
    <username>ljhyPortal2016</username>
    <password>Encrypted 746573746ed7f9c1af00ce938a8b5aef398cc2fe8c</password>
    <servername/>
    <data_tablespace/>
    <index_tablespace/>
    <attributes>
      <attribute>
        <code>FORCE_IDENTIFIERS_TO_LOWERCASE</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>FORCE_IDENTIFIERS_TO_UPPERCASE</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>INITIAL_POOL_SIZE</code>
        <attribute>100</attribute>
      </attribute>
      <attribute>
        <code>IS_CLUSTERED</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>MAXIMUM_POOL_SIZE</code>
        <attribute>300</attribute>
      </attribute>
      <attribute>
        <code>MSSQLUseIntegratedSecurity</code>
        <attribute>false</attribute>
      </attribute>
      <attribute>
        <code>MSSQL_DOUBLE_DECIMAL_SEPARATOR</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>PORT_NUMBER</code>
        <attribute>1433</attribute>
      </attribute>
      <attribute>
        <code>PRESERVE_RESERVED_WORD_CASE</code>
        <attribute>Y</attribute>
      </attribute>
      <attribute>
        <code>QUOTE_ALL_FIELDS</code>
        <attribute>N</attribute>
      </attribute>
      <attribute>
        <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
        <attribute>Y</attribute>
      </attribute>
      <attribute>
        <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
        <attribute>Y</attribute>
      </attribute>
      <attribute>
        <code>USE_POOLING</code>
        <attribute>Y</attribute>
      </attribute>
    </attributes>
  </connection>
  <order>
    <hop>
      <from>表输入 2</from>
      <to>Java 代码</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>Java 代码</from>
      <to>Elasticsearch bulk insert 2</to>
      <enabled>Y</enabled>
    </hop>
  </order>
  <step>
    <name>Elasticsearch bulk insert 2</name>
    <type>ElasticSearchBulk</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <general>
      <index>product_parent</index>
      <type>_doc</type>
      <batchSize>500</batchSize>
      <timeout>100</timeout>
      <timeoutUnit>SECONDS</timeoutUnit>
      <isJson>N</isJson>
      <idField>ProductCode</idField>
      <overwriteIfExists>Y</overwriteIfExists>
      <useOutput>N</useOutput>
      <stopOnError>Y</stopOnError>
    </general>
    <fields>
      <field>
        <columnName>Adverse</columnName>
        <targetName>Adverse</targetName>
      </field>
      <field>
        <columnName>AppreciationPrice</columnName>
        <targetName>AppreciationPrice</targetName>
      </field>
      <field>
        <columnName>ApprovalNumber</columnName>
        <targetName>ApprovalNumber</targetName>
      </field>
      <field>
        <columnName>BarCode</columnName>
        <targetName>BarCode</targetName>
      </field>
      <field>
        <columnName>BranchCode</columnName>
        <targetName>BranchCode</targetName>
      </field>
      <field>
        <columnName>BrandCode</columnName>
        <targetName>BrandCode</targetName>
      </field>
      <field>
        <columnName>BtManual</columnName>
        <targetName>BtManual</targetName>
      </field>
      <field>
        <columnName>BusinessIds</columnName>
        <targetName>BusinessIds</targetName>
      </field>
      <field>
        <columnName>CQuantity</columnName>
        <targetName>CQuantity</targetName>
      </field>
      <field>
        <columnName>CategoryType</columnName>
        <targetName>CategoryType</targetName>
      </field>
      <field>
        <columnName>Characters</columnName>
        <targetName>Characters</targetName>
      </field>
      <field>
        <columnName>CheckPendingPrice</columnName>
        <targetName>CheckPendingPrice</targetName>
      </field>
      <field>
        <columnName>ChemicalName</columnName>
        <targetName>ChemicalName</targetName>
      </field>
      <field>
        <columnName>Child</columnName>
        <targetName>Child</targetName>
      </field>
      <field>
        <columnName>ClassCode</columnName>
        <targetName>ClassCode</targetName>
      </field>
      <field>
        <columnName>Comment</columnName>
        <targetName>Comment</targetName>
      </field>
      <field>
        <columnName>CommonTitle</columnName>
        <targetName>CommonTitle</targetName>
      </field>
      <field>
        <columnName>CommonTitlePinyin</columnName>
        <targetName>CommonTitlePinyin</targetName>
      </field>
      <field>
        <columnName>Composition</columnName>
        <targetName>Composition</targetName>
      </field>
      <field>
        <columnName>ConsumeDays</columnName>
        <targetName>ConsumeDays</targetName>
      </field>
      <field>
        <columnName>ControlAreaRegion</columnName>
        <targetName>ControlAreaRegion</targetName>
      </field>
      <field>
        <columnName>ControlNumber</columnName>
        <targetName>ControlNumber</targetName>
      </field>
      <field>
        <columnName>CreationDate</columnName>
        <targetName>CreationDate</targetName>
      </field>
      <field>
        <columnName>Displaytab</columnName>
        <targetName>Displaytab</targetName>
      </field>
      <field>
        <columnName>DivisionCode</columnName>
        <targetName>DivisionCode</targetName>
      </field>
      <field>
        <columnName>Dosage</columnName>
        <targetName>Dosage</targetName>
      </field>
      <field>
        <columnName>DrugInteractions</columnName>
        <targetName>DrugInteractions</targetName>
      </field>
      <field>
        <columnName>EnglishName</columnName>
        <targetName>EnglishName</targetName>
      </field>
      <field>
        <columnName>ExternalID</columnName>
        <targetName>ExternalID</targetName>
      </field>
      <field>
        <columnName>FinancialType</columnName>
        <targetName>FinancialType</targetName>
      </field>
      <field>
        <columnName>Formula</columnName>
        <targetName>Formula</targetName>
      </field>
      <field>
        <columnName>Formulation</columnName>
        <targetName>Formulation</targetName>
      </field>
      <field>
        <columnName>FormulationCode</columnName>
        <targetName>FormulationCode</targetName>
      </field>
      <field>
        <columnName>GiftCategory</columnName>
        <targetName>GiftCategory</targetName>
      </field>
      <field>
        <columnName>GmpCertificateUrl</columnName>
        <targetName>GmpCertificateUrl</targetName>
      </field>
      <field>
        <columnName>GmpCode</columnName>
        <targetName>GmpCode</targetName>
      </field>
      <field>
        <columnName>HealthInsuranceType</columnName>
        <targetName>HealthInsuranceType</targetName>
      </field>
      <field>
        <columnName>Img100</columnName>
        <targetName>Img100</targetName>
      </field>
      <field>
        <columnName>Img180</columnName>
        <targetName>Img180</targetName>
      </field>
      <field>
        <columnName>Img320</columnName>
        <targetName>Img320</targetName>
      </field>
      <field>
        <columnName>Inspection</columnName>
        <targetName>Inspection</targetName>
      </field>
      <field>
        <columnName>Introduction</columnName>
        <targetName>Introduction</targetName>
      </field>
      <field>
        <columnName>IsControl</columnName>
        <targetName>IsControl</targetName>
      </field>
      <field>
        <columnName>IsDrugRecord</columnName>
        <targetName>IsDrugRecord</targetName>
      </field>
      <field>
        <columnName>IsGifts</columnName>
        <targetName>IsGifts</targetName>
      </field>
      <field>
        <columnName>IsLimitPrice</columnName>
        <targetName>IsLimitPrice</targetName>
      </field>
      <field>
        <columnName>IsRecommend</columnName>
        <targetName>IsRecommend</targetName>
      </field>
      <field>
        <columnName>IsSuit</columnName>
        <targetName>IsSuit</targetName>
      </field>
      <field>
        <columnName>IsVisible</columnName>
        <targetName>IsVisible</targetName>
      </field>
      <field>
        <columnName>LastModified</columnName>
        <targetName>LastModified</targetName>
      </field>
      <field>
        <columnName>Manual</columnName>
        <targetName>Manual</targetName>
      </field>
      <field>
        <columnName>Manufacturer</columnName>
        <targetName>Manufacturer</targetName>
      </field>
      <field>
        <columnName>ManufacturerCode</columnName>
        <targetName>ManufacturerCode</targetName>
      </field>
      <field>
        <columnName>MarketPrice</columnName>
        <targetName>MarketPrice</targetName>
      </field>
      <field>
        <columnName>MassDate</columnName>
        <targetName>MassDate</targetName>
      </field>
      <field>
        <columnName>MerchantManageCode</columnName>
        <targetName>MerchantManageCode</targetName>
      </field>
      <field>
        <columnName>MinMarketPrice</columnName>
        <targetName>MinMarketPrice</targetName>
      </field>
      <field>
        <columnName>MobilephoneUrl</columnName>
        <targetName>MobilephoneUrl</targetName>
      </field>
      <field>
        <columnName>Molecular</columnName>
        <targetName>Molecular</targetName>
      </field>
      <field>
        <columnName>OlderPatients</columnName>
        <targetName>OlderPatients</targetName>
      </field>
      <field>
        <columnName>OurPrice</columnName>
        <targetName>OurPrice</targetName>
      </field>
      <field>
        <columnName>OutOfStockRecommendCodes</columnName>
        <targetName>OutOfStockRecommendCodes</targetName>
      </field>
      <field>
        <columnName>Overdose</columnName>
        <targetName>Overdose</targetName>
      </field>
      <field>
        <columnName>Packing</columnName>
        <targetName>Packing</targetName>
      </field>
      <field>
        <columnName>PackingNumber</columnName>
        <targetName>PackingNumber</targetName>
      </field>
      <field>
        <columnName>PackingProduct</columnName>
        <targetName>PackingProduct</targetName>
      </field>
      <field>
        <columnName>Pharmaco</columnName>
        <targetName>Pharmaco</targetName>
      </field>
      <field>
        <columnName>Pharmacokinetics</columnName>
        <targetName>Pharmacokinetics</targetName>
      </field>
      <field>
        <columnName>PinyinCode</columnName>
        <targetName>PinyinCode</targetName>
      </field>
      <field>
        <columnName>PinyinFullCode</columnName>
        <targetName>PinyinFullCode</targetName>
      </field>
      <field>
        <columnName>PlaceCode</columnName>
        <targetName>PlaceCode</targetName>
      </field>
      <field>
        <columnName>PlureProductStatusType</columnName>
        <targetName>PlureProductStatusType</targetName>
      </field>
      <field>
        <columnName>PostageLogo</columnName>
        <targetName>PostageLogo</targetName>
      </field>
      <field>
        <columnName>Precautions</columnName>
        <targetName>Precautions</targetName>
      </field>
      <field>
        <columnName>PregnantWoman</columnName>
        <targetName>PregnantWoman</targetName>
      </field>
      <field>
        <columnName>PrescriptionType</columnName>
        <targetName>PrescriptionType</targetName>
      </field>
      <field>
        <columnName>PriceSectorPricing</columnName>
        <targetName>PriceSectorPricing</targetName>
      </field>
      <field>
        <columnName>ProductAttribute</columnName>
        <targetName>ProductAttribute</targetName>
      </field>
      <field>
        <columnName>ProductCode</columnName>
        <targetName>ProductCode</targetName>
      </field>
      <field>
        <columnName>ProductCodeForOutOfStock</columnName>
        <targetName>ProductCodeForOutOfStock</targetName>
      </field>
      <field>
        <columnName>ProductHotType</columnName>
        <targetName>ProductHotType</targetName>
      </field>
      <field>
        <columnName>ProductImageUrl</columnName>
        <targetName>ProductImageUrl</targetName>
      </field>
      <field>
        <columnName>ProductInventory</columnName>
        <targetName>ProductInventory</targetName>
      </field>
      <field>
        <columnName>ProductKey</columnName>
        <targetName>ProductKey</targetName>
      </field>
      <field>
        <columnName>ProductLine</columnName>
        <targetName>ProductLine</targetName>
      </field>
      <field>
        <columnName>ProductName</columnName>
        <targetName>ProductName</targetName>
      </field>
      <field>
        <columnName>ProductRecommend</columnName>
        <targetName>ProductRecommend</targetName>
      </field>
      <field>
        <columnName>ProductStatusType</columnName>
        <targetName>ProductStatusType</targetName>
      </field>
      <field>
        <columnName>ProductTag</columnName>
        <targetName>ProductTag</targetName>
      </field>
      <field>
        <columnName>ProductType</columnName>
        <targetName>ProductType</targetName>
      </field>
      <field>
        <columnName>Productmainmaterial</columnName>
        <targetName>Productmainmaterial</targetName>
      </field>
      <field>
        <columnName>Productusecrowd</columnName>
        <targetName>Productusecrowd</targetName>
      </field>
      <field>
        <columnName>ProductusecrowdCode</columnName>
        <targetName>ProductusecrowdCode</targetName>
      </field>
      <field>
        <columnName>ProfitLevel</columnName>
        <targetName>ProfitLevel</targetName>
      </field>
      <field>
        <columnName>ProudctDescription</columnName>
        <targetName>ProudctDescription</targetName>
      </field>
      <field>
        <columnName>PurchasePrice</columnName>
        <targetName>PurchasePrice</targetName>
      </field>
      <field>
        <columnName>PurchaseWhile</columnName>
        <targetName>PurchaseWhile</targetName>
      </field>
      <field>
        <columnName>QcClass</columnName>
        <targetName>QcClass</targetName>
      </field>
      <field>
        <columnName>Quantity</columnName>
        <targetName>Quantity</targetName>
      </field>
      <field>
        <columnName>Remark</columnName>
        <targetName>Remark</targetName>
      </field>
      <field>
        <columnName>SFDAApprovalValidDate</columnName>
        <targetName>SFDAApprovalValidDate</targetName>
      </field>
      <field>
        <columnName>SFDACode</columnName>
        <targetName>SFDACode</targetName>
      </field>
      <field>
        <columnName>SFDAGmpCertificateDate</columnName>
        <targetName>SFDAGmpCertificateDate</targetName>
      </field>
      <field>
        <columnName>SFDAStatus</columnName>
        <targetName>SFDAStatus</targetName>
      </field>
      <field>
        <columnName>ShowMall</columnName>
        <targetName>ShowMall</targetName>
      </field>
      <field>
        <columnName>StandardCode</columnName>
        <targetName>StandardCode</targetName>
      </field>
      <field>
        <columnName>Standards</columnName>
        <targetName>Standards</targetName>
      </field>
      <field>
        <columnName>Storage</columnName>
        <targetName>Storage</targetName>
      </field>
      <field>
        <columnName>Structure</columnName>
        <targetName>Structure</targetName>
      </field>
      <field>
        <columnName>SubProductLine</columnName>
        <targetName>SubProductLine</targetName>
      </field>
      <field>
        <columnName>SuitDescription</columnName>
        <targetName>SuitDescription</targetName>
      </field>
      <field>
        <columnName>SyncStatus</columnName>
        <targetName>SyncStatus</targetName>
      </field>
      <field>
        <columnName>Taboo</columnName>
        <targetName>Taboo</targetName>
      </field>
      <field>
        <columnName>ThumbnailUrl</columnName>
        <targetName>ThumbnailUrl</targetName>
      </field>
      <field>
        <columnName>ToErp</columnName>
        <targetName>ToErp</targetName>
      </field>
      <field>
        <columnName>Unit</columnName>
        <targetName>Unit</targetName>
      </field>
      <field>
        <columnName>UsageCode</columnName>
        <targetName>UsageCode</targetName>
      </field>
      <field>
        <columnName>UserName</columnName>
        <targetName>UserName</targetName>
      </field>
      <field>
        <columnName>Views</columnName>
        <targetName>Views</targetName>
      </field>
      <field>
        <columnName>WapManual</columnName>
        <targetName>WapManual</targetName>
      </field>
      <field>
        <columnName>Weight</columnName>
        <targetName>Weight</targetName>
      </field>
      <field>
        <columnName>XQuantity</columnName>
        <targetName>XQuantity</targetName>
      </field>
      <field>
        <columnName>product_join_field</columnName>
        <targetName>product_join_field</targetName>
      </field>
      <field>
        <columnName>recordState</columnName>
        <targetName>recordState</targetName>
      </field>
    </fields>
    <servers>
      <server>
        <address>192.168.50.32</address>
        <port>9300</port>
      </server>
    </servers>
    <settings>
      <setting>
        <name>cluster.name</name>
        <value>es</value>
      </setting>
      <setting>
        <name>custom.aliase.source</name>
        <value>mem_product</value>
      </setting>
      <setting>
        <name>custom.fields.Adverse</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.Characters</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.ChemicalName</name>
        <value>{"type":"text"}</value>
      </setting>
      <setting>
        <name>custom.fields.Child</name>
        <value>{"type":"text"}</value>
      </setting>
      <setting>
        <name>custom.fields.CreationDate</name>
        <value>{"type":"date","format":"yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||strict_date_optional_time||epoch_millis"}</value>
      </setting>
      <setting>
        <name>custom.fields.Dosage</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.DrugInteractions</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.EnglishName</name>
        <value>{"type":"text"}</value>
      </setting>
      <setting>
        <name>custom.fields.Introduction</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":5000}</value>
      </setting>
      <setting>
        <name>custom.fields.LastModified</name>
        <value>{"type":"date","format":"yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||strict_date_optional_time||epoch_millis"}</value>
      </setting>
      <setting>
        <name>custom.fields.Manual</name>
        <value>{"type":"text"}</value>
      </setting>
      <setting>
        <name>custom.fields.Manufacturer</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.OlderPatients</name>
        <value>{"type":"text"}</value>
      </setting>
      <setting>
        <name>custom.fields.Overdose</name>
        <value>{"type":"text"}</value>
      </setting>
      <setting>
        <name>custom.fields.PackingProduct</name>
        <value>{"type":"text"}</value>
      </setting>
      <setting>
        <name>custom.fields.Pharmaco</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.Pharmacokinetics</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.Precautions</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.PregnantWoman</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.ProductName</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.ProductTag</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","index":true}</value>
      </setting>
      <setting>
        <name>custom.fields.ProudctDescription</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.ProudctMainMaterial</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.ProudctName</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.Proudctusercrowd</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.SFDAApprovalValidDate</name>
        <value>{"type":"date","format":"yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||strict_date_optional_time||epoch_millis"}</value>
      </setting>
      <setting>
        <name>custom.fields.SFDAGmpCertificateDate</name>
        <value>{"type":"date","format":"yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||strict_date_optional_time||epoch_millis"}</value>
      </setting>
      <setting>
        <name>custom.fields.Standards</name>
        <value>{"type":"text"}</value>
      </setting>
      <setting>
        <name>custom.fields.Storage</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.Taboo</name>
        <value>{"type":"text","analyzer": "ik_max_word",
"search_analyzer":"ik_smart","ignore_above":300}</value>
      </setting>
      <setting>
        <name>custom.fields.product_join_field</name>
        <value>{ "type": "join",
			"relations": {
				"Product": "Order" 
        }}</value>
      </setting>
      <setting>
        <name>custom.index.number_of_replicas</name>
        <value>1</value>
      </setting>
      <setting>
        <name>custom.index.number_of_shards</name>
        <value>1</value>
      </setting>
    </settings>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>368</xloc>
      <yloc>176</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>Java 代码</name>
    <type>UserDefinedJavaClass</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>10</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <definitions>
      <definition>
        <class_type>TRANSFORM_CLASS</class_type>
        <class_name>Processor</class_name>
        <class_source>import java.sql.*;
import org.pentaho.di.core.database.*;




public boolean processRow(StepMetaInterface smi, StepDataInterface sdi) throws KettleException
{
    Object[] r = getRow();
    if (r == null) {
        setOutputDone();
        return false;
    }



    r = createOutputRow(r, data.outputRowMeta.size());
//获取数据库名和表名
    String dbName = "testSqlServer";//getInputRowMeta().getString(r, "conname", null );
    String tablename = "DataImport_product";//getInputRowMeta().getString(r, "tablename", null );
    String idname = "ProductKey";//getInputRowMeta().getString(r, "idname", null );
    String sourceidname = "ProductCode";//getInputRowMeta().getString(r, "sourceidname", null );
    String sourcetablename = "product";//getInputRowMeta().getString(r, "sourcetablename", null );
    if (dbName==null||tablename==null) {
      throw new KettleException("Unable to find field with name "+tablename+" in the input row.");
    }
    //logBasic("table---"+tablename);



//数据库连接
    Database database=null;
    DatabaseMeta databaseMeta=null;
    try  {
          databaseMeta = getTransMeta().findDatabase(dbName);
         if (databaseMeta==null) {
         logError("A connection with name "+dbName+" could not be found!");
         setErrors(1);
         return false;
    }
      database = new Database(getTrans(), databaseMeta);
      database.connect();
       //logBasic("success!");
    } catch(Exception e) {
      logError("Connecting to database "+dbName+" failed.", e);
      setErrors(1);
      return false;
    }


//查询表数据
     ResultSet resultSet;
     try {
      RowMetaInterface idxRowMeta =data.outputRowMeta;
 
      int i=0;

          r = createOutputRow(r, data.outputRowMeta.size());
		  
          //int index = getInputRowMeta().size();
          

        // Add the index name
        //
        String Id = idxRowMeta.getString(r, idname, null);

        // Add the column name
        
        String DataId = idxRowMeta.getString(r, sourceidname, null);
        
   
        String sqlSelect = "select Id from "+tablename + " where DataId = '"+ DataId +"'";
		resultSet = database.openQuery(sqlSelect);
        Object[] idxRow = database.getRow(resultSet);
        if(idxRow!=null){
    		return true;
	 	}
     
     //logBasic("idxRow--Id"+Id);
     //logBasic("idxRow--sourcetablename"+sourcetablename);
     //logBasic("idxRow--DataId"+DataId);
        
		//3.获得预处理对象
        String sql=" insert into "+tablename+" values (?,?,?)";
     //logBasic("idxRow--database"+ database);

		PreparedStatement stat = database.prepareSQL(sql);
	  //logBasic("idxRow--database"+ stat);
        //stat.addBatch(sql);
		//4.SQL语句占位符设置实际参数
		stat.setString(1, Id);//索引参数1代表着sql中的第一个？号，也就是我需要将条件sid所对应的sname数据更新为“儿童玩具测试”
		stat.setString(2, sourcetablename);//索引参数2代表着sql中的第二个？号，也就是条件是sid为3
		stat.setString(3, DataId);//索引参数2代表着sql中的第二个？号，也就是条件是sid为3
		//5.执行SQL语句
		boolean line = stat.execute();
		//int[] line = stat.executeBatch();
		System.out.println("更新记录数"+ line);
		//6.释放资源

		stat.close();



     //logBasic("idxRow--length"+i);
    
     }
   catch(Exception e) {
     throw new KettleException(e);
   } 
//释放连接
   if (database!=null) {
      database.disconnect();
    }

  // Send the row on to the next step.

  putRow(data.outputRowMeta, r);

    return true;
}</class_source>
      </definition>
    </definitions>
    <fields>
    </fields>
    <clear_result_fields>N</clear_result_fields>
    <info_steps/>
    <target_steps/>
    <usage_parameters/>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>497</xloc>
      <yloc>58</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step>
    <name>表输入 2</name>
    <type>TableInput</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <connection>testSqlserver</connection>
    <sql>SELECT 
		row_number() over (order by productCode asc ) as ProductKey
		,[ProductCode]
      ,convert(varchar(19),[CreationDate],120) as [CreationDate]
      ,convert(varchar(19),[LastModified],120) as [LastModified]
      ,[ProductName]
      ,ltrim(rtrim([ClassCode])) as ClassCode
      ,[CommonTitle]
      ,[Introduction]
      ,[Unit]
      ,[Manufacturer]
      ,[Packing]
      ,[ProductStatusType]
      ,[IsVisible]
      ,[PurchasePrice]
      ,[MarketPrice]
      ,[OurPrice]
      ,[AppreciationPrice]
      ,[ProfitLevel]
      ,[Manual]
      ,[WapManual]
      ,[Views]
      ,[PriceSectorPricing]
      ,[BrandCode]
      ,[ProductType]
      ,[Inspection]
      ,[Composition]
      ,[Weight]
      ,[GmpCode]
      ,[GmpCertificateUrl]
      ,[ProductImageUrl]
      ,[ThumbnailUrl]
      ,[Img100]
      ,[Img180]
      ,[Img320]
      ,[StandardCode]
      ,[BarCode]
      ,[ApprovalNumber]
      ,[ProductAttribute]
      ,[Formulation]
      ,[PrescriptionType]
      ,[PurchaseWhile]
      ,[HealthInsuranceType]
      ,[ConsumeDays]
      ,[ProductTag]
      ,[IsGifts]
      ,[Standards]
      ,[Dosage]
      ,[MassDate]
      ,[Storage]
      ,[IsControl]
      ,[ControlNumber]
      ,[PackingNumber]
      ,[PinyinCode]
      ,[PinyinFullCode]
      ,[ProductLine]
      ,[SubProductLine]
      ,[IsRecommend]
      ,[SFDACode]
      ,convert(varchar(19),[SFDAApprovalValidDate],120) as [SFDAApprovalValidDate]
      ,convert(varchar(19),[SFDAGmpCertificateDate],120) as [SFDAGmpCertificateDate]
      ,[SFDAStatus]
      ,[QcClass]
      ,[SyncStatus]
      ,[recordState]
      ,[IsSuit]
      ,[SuitDescription]
      ,[FinancialType]
      ,[ProudctDescription]
      ,[PlureProductStatusType]
      ,[Productmainmaterial]
      ,[Productusecrowd]
      ,[Displaytab]
      ,[EnglishName]
      ,[ChemicalName]
      ,[Structure]
      ,[Formula]
      ,[Molecular]
      ,[Characters]
      ,[Adverse]
      ,[Taboo]
      ,[Precautions]
      ,[Child]
      ,[OlderPatients]
      ,[PregnantWoman]
      ,[DrugInteractions]
      ,[Overdose]
      ,[Pharmaco]
      ,[Pharmacokinetics]
      ,[PackingProduct]
      ,[ExternalID]
      ,[Remark]
      ,[ProductHotType]
      ,[MobilephoneUrl]
      ,[BtManual]
      ,[ProductRecommend]
      ,[ToErp]
      ,[ProductusecrowdCode]
      ,[PlaceCode]
      ,[FormulationCode]
      ,[UsageCode]
      ,[ManufacturerCode]
      ,[ShowMall]
      ,[DivisionCode]
      ,[BranchCode]
      ,[MerchantManageCode]
      ,[MinMarketPrice]
      ,[CheckPendingPrice]
      ,[ControlAreaRegion]
      ,[ProductCodeForOutOfStock]
      ,[IsLimitPrice]
      ,[CommonTitlePinyin]
      ,[ProductInventory]
      ,[PostageLogo]
      ,[Quantity]
      ,[IsDrugRecord]
      ,[OutOfStockRecommendCodes]
      ,[GiftCategory]
      ,[BusinessIds]
      ,[CategoryType]
      ,[XQuantity]
      ,[UserName]
      ,[Comment]
      ,[CQuantity]
	  ,'Product' as product_join_field	
  FROM [MemberData].[dbo].[mem_Product]</sql>
    <limit>0</limit>
    <lookup/>
    <execute_each_row>N</execute_each_row>
    <variables_active>N</variables_active>
    <lazy_conversion_active>N</lazy_conversion_active>
    <attributes/>
    <cluster_schema/>
    <remotesteps>
      <input>
      </input>
      <output>
      </output>
    </remotesteps>
    <GUI>
      <xloc>288</xloc>
      <yloc>32</yloc>
      <draw>Y</draw>
    </GUI>
  </step>
  <step_error_handling>
  </step_error_handling>
  <slave-step-copy-partition-distribution>
  </slave-step-copy-partition-distribution>
  <slave_transformation>N</slave_transformation>
  <attributes/>
</transformation>