DSXchange

We are using OCI Stage in server job. We are planning to migrate to 11.5 after importing the job ORACLE OCI stage its showing in grey color as this stage was Deprecated. Please advise how to migrate server job with ORACLE OCI to 11.5 version without re-designing.
Thanks,
Krisna

Used regexp_replace oracle function in source query to avoid unprintable characters.

Thanks everyone for the answers. How do i remove all unprintable characters before writing to a file.

Every one of my team.

Thanks

All,

When XML input stage or output stage is placed on designer canvas getting the below error.

40906 unable to create the new object.

Please advise

Thanks in Advance

Hi All,

Need to extract images from oracle and load to DB2. Please advise how can we achieve this.

In Source image column datatype is BLOB.

Thanks in advance.....

Hi All,

upto 2 days back the job was running (extracting data) from DB. But now it's not extracting and i don't see any progress. But when i executed that query in oracle client it shows the result. Please Advise.

Thanks in Advance.......

It's not a fixed width file. We are using version 7. We have indexes on tables.

Hi, We are loading data from a sequential file to oracle and volume is 650 millions of records. It took 45 hours to load 318 million records, performance wise it's very poor. Job design is like this sequential file --> transformer --> oracle enterprise stage | V oracle enterprise stage in transforme...

it's latter part got from director log.

Below error we are getting when we run the job. The provided insert statement did not prepare correctly; please verify that your statement is correct; statement: INSERT INTO STG.LDM_DWR_CPS_REJECTS (SOURCE_ID, EXTR_BTCH_ID, SUBJECT_AREA, JOB_NAME, ERROR_TXT, ERROR_DT_TIMSTM) VALUES ( :SOURCE_ID, :EX...

Thanks jwiles

i made a mistake that using of trim with DecimalToString() function. After removing that it worked fine.

for example from source table x and y columns had values like 234.5 and -145.64 then in file it should display as 0000000000000234.5000-0000000000000145.6400 (if it is positive number it should have a leading space so that the total width will be 22 characters.) (if it is negative number with sign i...

Hi All, My target is a file which contains amount columns of 22 width. 16 for integer part, 1 for decimal point, 4 for decimal digit. 1 for sign. for example : 0000000000000000.0000, if we have -ve sign it should be -0000000000000000.0000. My question is if it is a +ve number it should have leading ...