Creating the Prejob - 7.3

ELT Teradata

author
Talend Documentation Team
EnrichVersion
Cloud
7.3
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > ELT components > ELT Teradata components
Data Quality and Preparation > Third-party systems > ELT components > ELT Teradata components
Design and Development > Third-party systems > ELT components > ELT Teradata components
EnrichPlatform
Talend Studio

Create the Prejob that contains the data that you wish to load to the Oracle table.

See the Prejob design image in The Standard Job and the Prejob design section.

Procedure

  1. Create a Standard Job.
  2. Add the following components:
    • Prejob
    • two tFixedFlowInput components
    • two tOracleOutput components
    • two tOracleInput components
    • one tCreateTable component
    • two tLogRow components
  3. Configure the first tFixedFlowInput component:
    1. Select the tFixedFlowInput component to display the Basic settings view.
    2. Select Use Inline Content(delimited file) from the Mode options.
    3. Add the following data to the Content field:
      1;Amanda;art;Amanda prefers art.
      2;Ford;science;Ford prefers science.
      3;Kate;art;Kate prefers art.
    4. Click ... next to the Edit Schema field to open the Schema Editor.
    5. Add four columns with the following names and corresponding parameters:
  4. Configure the second tFixedFlowInput component:
    1. Repeat steps 3a and 3b.
    2. Add the following data to the Content field:
      1;Amanda;science;math;85;science score
      2;Amanda;science;physics;75;science score
      3;Amanda;science;chemistry;80;science score
      4;Amanda;art;chinese;85;art score
      5;Amanda;art;history;95;art score
      6;Amanda;art;geography;80;art score
      7;Ford;science;math;95;science score
      8;Ford;science;physics;85;science score
      9;Ford;science;chemistry;80;science score
      10;Ford;art;chinese;75;art score
      11;Ford;art;history;80;art score
      12;Ford;art;geography;85;art score
      13;Kate;science;math;65;science score
      14;Kate;science;physics;75;science score
      15;Kate;science;chemistry;80;science score
      16;Kate;art;chinese;85;art score
      17;Kate;art;history;80;art score
      18;Kate;art;geography;95;art score
    3. Click ... next to the Edit Schema field to open the Schema Editor.
    4. Add six columns with the following names and corresponding parameters:
  5. Select the first tOracleOutput component to open the Basic settings view.
    1. Select Repository from the Property Type drop-down list.
    2. Specify the Oracle database connection the you have previously added by clicking .... This automatically populates the database information in the fields provided.
    Repeat step 6 and steps 6a-6b to configure the second tOracleOutput component.
  6. Select the tCreateTable component to open the Basic settings view.
    1. Select Oracle from the Database Type drop-down list.
    2. Select Repository from the Property Type drop-down list.
    3. Specify the Oracle database connection that you have previously added by clicking .... This automatically populates the database information in the fields provided.
    4. Enter TotalScoreOfPreferredSubject in the Table Name field.
    5. Select Drop table if exists and create from the Table Action drop-down list.
    6. Click ... next to the Edit schema field to open the Schema editor.
    7. Add four columns with the following corresponding names and parameters: