how to load the multiple tables from single file uisng TPT ..

Tools

how to load the multiple tables from single file uisng TPT ..

can we load the  multiple tables from the single file based on value in the file

this is the oracle structure (sql laoder) for loadiing multiple tables from a file

LOAD DATA

INFILE /u01/app/oracle/load.dat

REPLACE

INTO TABLE emp

   WHEN empno != ' '

   ( empno POSITION(1:4) INTEGER EXTERNAL,

     ename POSITION(6:15) CHAR

)

INTO TABLE proj

WHEN projno != ' '

   ( projno POSITION(25:27) INTEGER EXTERNAL,

     empno POSITION(1:4) INTEGER EXTERNAL

)

can we do the same uisng TPT ?

1 REPLY
Teradata Employee

Re: how to load the multiple tables from single file uisng TPT ..

Yes, TPT can do this.

Check out the documentation for the use of the "CASE" syntax.

-- SteveF