Step 2: Configuring the Sequential File stage

Configure the Sequential File stage to read data from the source file. You must specify the source file name and define the column names and SQL properties.

Before you begin

In this example, Sequential File stage is used as output stage. You can use any other output stage for creating the output.

Procedure

  1. Double-click the Sequential File stage.
  2. On the Properties page, specify the file path to the Employee.txt file.
  3. On the Columns page, define the columns as shown in the below table.
    Column name Key SQL type Extended Length Scale Nullable Description
    EMP_NO   Integer       Yes  
    FIRST_NAME   VarChar       Yes  
    MIDINIT   VarChar       Yes  
    LAST_NAME   VarChar       Yes  
    HIRE_DATE   Date       Yes  
    JOB   VarChar       Yes  
    SEX   VarChar       Yes  
    SALARY   Integer       Yes  
    BONUS   Integer       Yes  
  4. Click OK.
Parent topic: Example: Writing data to existing Microsoft Excel files