DSXchange

I have used OPEN/CLOSE option it throws me the below error,

TEST,0: Oracle call failed; sqlcode = -911; message: ORA-00911: invalid character

TEST,0: ExecuteImmediate failed for:
TRUNCATE TABLE TEMP;
INSERT INTO TEMP SELECT * FROM TEMP1;

Hi, We are migrating the DB2 Objects to Oracle Objects and during migration One of the PX job which is developed using DB2 object as target is having before and after jobs been defined using Sql statments.The same we are trying to replicate using Oracle Job, but we are not able to find this option. ...

We have done the same still it's not working.

Sanjay,

We have already set this option at the project level.

Rgds

Below are the cases which i tried, My Table Structure is as below for Source, EMP_SRC EMPNO_SRC ENAME_SRC My Table Structure is as below for Target, EMP_TGT EMPNO_TGT ENAME_TGT Source/Target is Oracle Case 1 : Target Option is set to Load Used PX tranformer Created a PX job This is one to one mappin...

We have created the Parallel job using Advanced Transformer and we were not able to use any of the Transformation functions in the job. Later we changed PX transformer with Basic Transformer and used functions and it worked out. But in Basic transformer we cannot use Type conversion functions which ...

We have created the Parallel job using Advanced Transformer and we were not able to use any of the Transformation functions in the job. Later we changed PX transformer with Basic Transformer and used functions and it worked out. But in Basic transformer we cannot use Type conversion functions which ...

Yes the columns are available in DB. Below is the log from DB SQL> desc emp_tgt Name Null? Type ----------------------------------------- -------- ---------------------------- EMPNO_TGT NUMBER(10) ENAME_TGT VARCHAR2(10) SQL> desc emp_src Name Null? Type ----------------------------------------- ----...

My Table Structure is a below for Source, EMP_SRC EMPNO_SRC ENAME_SRC My Table Structure is a below for Target, EMP_TGT EMPNO_TGT ENAME_TGT I done a simple tranformation using the trim option in the columns while loading the data from EMP_SRC to EMP_TGT. EMP_SRC trim(EMPNO_SRC) trim(ENAME_SRC) It sh...

The data is getting loaded after removing the APT_ORA_WRITE_FILES which is set as /dsetlsoft/Ascential/DataStage/Scratch/250607/sample.log Now i tried using the trim option in the columns while loading the data from EMP_SRC to EMP_TGT. EMP_SRC trim(EMPNO_SRC) trim(ENAME_SRC) It shows the below error...

I have set the APT_ORA_WRITE_FILES the log is as shown below. my observation is after the sqlldr completes its job it was suppose to remove the INFILE's ora.164096.852937.fifo.0.out ora.164096.852937.fifo.1.out ora.164096.852937.fifo.2.out which is not happening and PARFILE is not getting created. I...

Sanjay,

I had unchecked the same, but still the data is not getting loaded to target.

Rgds,

Ray, I was able to resolve the error by importing the metadata for the Source/Target tables. I was able to compile and execute. But still the data is not loading to the target tables even it shows in the Job as it selected 14 records from the source and inserted 14 records in the target. Below is th...

Arnd,

I have selected automatic load option.

Rgds,

Hi i hope the following line helps you to get your required output Ereplace("2005-05-18 ","-","") Thanks -Mspanda Hi All, I want to remove the leading "." i.e dot in the decimal value. Example: Input is date(10) = 2005-05-18 after coverting the date to decimal...