DSXchange

oracle EE stage doesnot support LONG.
use Dynamic RDBMS stage .

currently the tables are left outer joined with master table, and inserted into a temporay table, then join this temporary table to another table and load another temporary table, then join this second temporary table to another table and load into third temporary table, .................like wise.....

I have to join five large tables (8 millions and about 4-5 GB data in each), and then insert records into another table. currently we are doing it using procedures and the procedures takes almost 1 day for processing; so now wanted to do it in Datastage. i am new to server job. can't find any stage ...

how many nodes you have in configuration file?

check the job monitor is up and running?
try restarting the job monitor and then run the job.

use a sort stage,
sort on MISDN and DATE ASC.
remove duplicate on MISDN and keep the first record.

any DML

you need to unlock this job , before you recompile the job
there should be a process lock with name BIW_Dimen_Vehicle_Vehicle_01_SIT1.fifo

unlock this process and unlock the userno

UNLOCK USER <nnnn> ALL

search for orchoracle.o
it will surely help you

see this viewtopic.php?t=120269

you said ID is a column in the oracle table, then why don't you have that in your job to populate?

we have ORACLE RAC with 4 failover servers and successfully running with only one tns name in tnsnames.ora file, for all the four failover database instances

did you try searching "compilation error"
there can be many reasons?

have you installed the data stage server in your local PC system?

datastage uses scratch disk a kind of RAM
and resource disk as hard disk.

get all multiple rows from the reference, then use a sort stage to sort the data on first two column (1 NAP) and then in a transformer stage, concatnate for all column3 values for same key (1 NAP)

are you able to connect MTVETLPRD2 node from head node?