August 15, 2023

Retrieving the data insertion updates from the SCD dimension table – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Retrieving the data insertion updates from the SCD dimension table – Docs for ESB 6.x

Retrieving the data insertion updates from the SCD dimension table

  1. Double-click the first tJDBCInput component to open its
    Basic settings view.
  2. Select the Use an existing connection check box and from
    the Component List drop-down list displayed, select the
    connection component to reuse the connection created by it,
    tJDBCConnection_1 in this example.
  3. Click the […] button next to Edit
    schema     and in the pop-up dialog box, define the schema by adding
    nine columns: sk and id of Integer
    type as the primary key, name and
    role of String type, salary of
    Double type, start_date and
    end_date of Date type with the Date Pattern
    yyyy-MM-dd, and active_status
    and version of Integer type. When done, click
    OK to save the changes and close the dialog
    box.

    The schema of the first tJDBCInput component is the
    same as the schema of the tJDBCSCDELT component, you
    can just copy and paste it.

  4. In the Query field, enter the SQL command used to
    retrieve data from the SCD dimension table, select * from
    employee_scd     in this example.
  5. Double-click the first tLogRow component and in the
    Mode area on its Basic
    settings     view, select Table to display
    the retrieved data in a table.
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