DSXchange

Hi All, My source table is DB2 and my target table is Oracle 11g. My ID columns in source tables are BigInt and Target columns are number(38). When I do CDC, can you please let me know the best way to do the conversion and insert/update into the target table(Oracle) to number. Kindly let me know you...

Hi,

Now I am getting the below error message


The reported error is: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

Hi All, We have a remote Oracle DB for which we were trying to access using jdbc connector and use oracle thin client to connect to the database.we tried with the below URL: jdbc:oracle:thin@x.x.x.x:1521:SID AND URL: jdbc:oracle:thin@x.x.x.x:1521/SID We were able to find the instance as CD12,CD14 us...

Hi All, I am getting the following error as our production jobs (max 20 job) running in parallel. Error: DataStage jobs intermittently fail with the following combination of warning and fatal error messages: Message: APT_CombinedOperatorController(17),1: Adaptive job monitoring feature is disabled; ...

Hi All, Kindly let me know your thoughts on how to calculate the cumulative value based on the below scenario A B C Amt 1 1 1 10 1 1 2 10 1 1 3 10 1 1 4 10 1 1 4 10 From the above data i would like to calculate the cumulative as below A B C Amt 1 1 1 10 1 1 2 20 1 1 3 30 1 1 4 10 kindly let me know ...

Hi All, We could face a compilation issue in out production environment. The same job has been compiled successfully in our UAT environment. UAT: APT_COMPILEOPT=-O -fPIC -Wno-deprecated -c APT_LINKPOT=-shared -Wl,-Bsymbolic,--allow-shlib-undefined Production: APT_COMPILEOPT=-c -O -fPIC -Wno-deprecat...

Hi, When i try to insert records into Table A, by using oracle connector stage(Oracle 10g) with Drop unmatched fields option(Set an Yes) i could see a weird response. Using performance statistics / job monitor i could see the records were populated into the target DB table. When i see the table ther...

Thanks Craig and qt_ky. It worked:)

Appreciate your help!!!







Thanks,
Satheesh

Hi Chullet,

Yes..You are right. My source and destination tables dont have any precesion & scale. is there any workaround for this chullet..



Regards,
Satheesh

Hi All, Apologize for the confusion. My source Oracle 9i table column definition defined as Number and Target Oracle 12C is also same. When i try to extract data from DS9.1 and load into target i could see the error message. My ultimate aim is to load the whole data into my target.Kindly guide me. T...

Hi All, I am running the below query SELECT to_char(STUDY_DURATION) - Number as defined source table FROM TableName Result: 893.640636574074074074074074074074074074 TargetTable: STUDY_DURATION defined as number When i try to load the above data by using decimal in DS9.1 PX job the job is aborted. Er...

Hi Chullet,

My Bad, sorry for the confusion. Change capture stage return code.


Thanks,
Satheesh.R

Hi Chullet,

Yes. We do have a index for the key column for the update.

Note: Even tried to truncate the table and re-load by only inserting the records using cdc code. Still there we no performance improvement.

Thanks,
Satheesh.R

Hi All, We have a datastage project in version 9.1 and Oracle 12C as an target DB. When we ran the jobs it ran fine for few jobs, but some of the jobs really do underperformance like <10 rows/sec when they do update and then insert using Oracle Connector Stage. When i remove the stage and use Datase...

Hi All, I have newly installed Datastage9.1 version. Once it gets done, when i try to open oracle connector stage a pop-up window opens and say "Type mismatch" after couple of ok's it will open the connector stage, but can't able to see any property tab values and able to see the column me...