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.

In this section

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 – let us know how we can improve!

Leave your feedback here