August 15, 2023

Configuring the first subjob: creating a dynamic schema – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Configuring the first subjob: creating a dynamic schema – Docs for ESB 6.x

Configuring the first subjob: creating a dynamic schema

  1. Double-click the tFixedFlowInput
    component to show its Basic settings view
    and define its properties.

    use_case_tfileinputpos2-2.png

  2. Click the […] button next to Edit schema to open the [Schema] dialog box.

    use_case_tfileinputpos2-3.png

  3. Click the [+] button to add three
    columns: ColumnName, ColumnType, and ColumnLength, and set their types to String, String, and
    Integer respectively to define the
    minimum properties required for a positional file schema. Then, click
    OK to close the dialog box.
  4. Select the Use Inline Table option, click
    the [+] button three times to add three
    lines, give them a name in the ColumnName
    field, according to the actual columns of the input file to read: ID, Name,
    and City, set their types in the
    corresponding ColumnType field: id_Interger for column ID, and id_String for
    columns Name and City, and set the length values of the columns in the
    corresponding ColumnLength field. Note that
    the column names you give in this table will compose the header of the
    output file.
  5. Double-click the tSetDynamicSchema
    component to open its Basic settings view.

    use_case_tfileinputpos2-4.png

  6. Click Sync columns to ensure that the
    schema structure is properly retrieved from the preceding component.
  7. Under the Parameters table, click the
    [+] button to add three lines in the
    table.
  8. Click in the Property field for each
    line, and select ColumnName, Type, and Length
    respectively.
  9. Click in the Value field for each line,
    and select ColumnName, ColumnType, and ColumnLength respectively.

    Now, with the values set in the inline table of the tFixedFlowInput component retrieved, the following data
    structure is defined in the dynamic schema:
    Column Name Type Length
    ID Integer 6
    Name String 12
    City String 12
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