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
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 ?
Yes, TPT can do this.
Check out the documentation for the use of the "CASE" syntax.