Skip to main content Skip to complementary content

Read data from a text file and insert the data into Oracle's PERSON table

Before you begin

  • You have created a text file, called person_table.txt, containing the following information.
    Shong;30;CN
    Ross;34;US
    Patrick;27;FR
    Pedro;28;CN

Procedure

  1. Drop the following components from the Palette to the design workspace: tFileInputDelimited and tOracleOutput.
  2. Link the two components using a Row > Main connection.

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!