Skip to main content Skip to complementary content

Creating the Prejob

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:

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here