DSXchange

Is it because we are uysing a lower version of Oracle. The datastage version is 7.5.1 and the oracle version is 8i.

I have tried the options you have mentioned here. There is not any index present in the table. Also I have tried with DIRECT= TRUE, PARALLEL=FALSE option.

The Oracle SQL Enterprise stage with LOAD option is working fine if I use the conventional PATH. But the same job is not working if I use the direct path. In the log file it is saying 'table or view does not exist'. In my case the ETL server and the Database server is different. Is than an issue? Pl...

I'm using Oracle Enterprise Stage with LOAD option hence uanble to use user defined queries. As I have said earlier, to test the job I have hardcoded the timestamp value in the transformer. StringToTimestamp("2007-10-10 10:10:10", "%yyyy-%mm-%dd %hh:%nn:%ss) The records are getting re...

I have already tried doing this. Also just to test, I have tried to change the input data and remove the microseconds from the date . All this didn't help in getting the data loaded.

The input value is ''2007-10-31 00:00:00.000". I'm reading this in Char [23] . The job layout looks like sequential file -> transformer -> Oracle Enterprise(with load option) All the warnings and errors are in the oracle enterprise stage. All the fields are nullable but there are not any null v...

Can somebody please help on this issue. We are not able to move forward with the development without resolving this problem.

The target column is timestamp. So I need to insert the time information along with the date. How do I use TO_DATE function while inserting. I'm using Oracle Eterprise Stage with LOAD option.

I have a timestamp value in a flat file which I need to insert into oracle table. The I/P value looks like '2007-10-31 00:00:00.000'. In thae transformer I'm using the following function to insert the value. StringToTimestamp(In_Trns_t1clod.ORIGINAL_OFF_START_DATE , "%yyyy-%mm-%dd %hh:%nn:%ss&q...