August 15, 2023

Configuring the key generation for the second pass – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Configuring the key generation for the second pass – Docs for ESB 6.x

Configuring the key generation for the second pass

  1. Double-click the second tGenKey to open
    the Component view.

    use_case-multi_pass_tmatchgroup4.png

  2. In the Algorithm table, define the column
    you want to use to partition data, account_num in this
    component. Select the first N characters of the
    string     algorithm and set the value to 1
    in the Value column.

    Each of the two tGenKey components will
    generate a read_only T_GEN_KEY column in
    the output schema. You must rename one of theT_GEN_KEY columns to stop them from overwriting each
    other.
  3. Double-click the tMap component to open
    its editor.

    use_case-multi_pass_tmatchgroup8.png

  4. In the Schema editor, copy the columns
    from the first table onto the second table and rename T_GEN_KEY to T_GEN_KEY1, for example.
  5. In the top part of the editor, drop all columns from the input table to
    the output table.
  6. Click Ok to save data transformation and
    close the editor.
  7. In the tGenKey basic settings, click the

    dotbutton.png

    button to verify that the two generated keys are named
    differently in the output schema.

    use_case-multi_pass_tmatchgroup5.png

Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x