Incorrect values retrieved from Oracle

agrvikrant · Post by **agrvikrant** » Thu Mar 22, 2007 8:19 am

Hello,

We have developed a PX job that retrieves around 2 million records from a Oracle Table. We find that when we run this query some fields defined as BigInt are not retrieving proper values. For eg a field with value 9 in Oracle is shown as 9130. This is happening for some records and not all the records. If we put additional filters to restrict the number of rows to a smaller value, we get proper data. It would be of great help if someone can help me in solving this problem.

Some of the fields are defined as decimal (10) in Oracle. The metadata imported in DataStage shows them as BigInt. Can this be cause of problem.

Thanks in advance.

Regards,
Vikrant

DSguru2B · Post by **DSguru2B** » Thu Mar 22, 2007 9:12 am

Welcome Aboard
What stage are you using to pull the data? How did you import the table definition? If you do a select * from your favourite sql tool (TOAD or oracle developer) do you see the same behaviour?

agrvikrant · Post by **agrvikrant** » Thu Mar 22, 2007 10:08 am

Hi,

We are using Oracle Enterprise Stage to pull the data. Metadata was imported using Orchestrate. Whenwe viewed this data from TOAD it was completely fine.

Thanks,
Vikrant

DSguru2B · Post by **DSguru2B** » Thu Mar 22, 2007 10:16 am

What if you change the BIGINT to integer within Oracle Enterprise stage. Does that fix your problem?

agrvikrant · Post by **agrvikrant** » Thu Mar 22, 2007 10:52 am

Yes we have tried it. It doesnt help, gave same result.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 22, 2007 7:19 pm

Try importing the table definition using Orchestrate orchdbutil facility, which is known to be more accurate.

_chamak · Post by **_chamak** » Tue Mar 20, 2012 1:29 pm

ray.wurlod wrote:Try importing the table definition using Orchestrate orchdbutil facility, which is known to be more accurate.

Hi, I am also facing the same error. I have straight forward job

Dataset ------> Copy---------->Oracle Table.

I am using Oracle Connector stage. My source is Bigint and the target is Integer.

For few records like example 4183 is in the source and in the target I am seeing 418333.

Did you find any resolution for this.
I am using DS 8.1

Thanks in Advance

qt_ky · Post by **qt_ky** » Tue Mar 20, 2012 7:24 pm

If you try to put a 64-bit integer into a 32-bit field, you can expect to run into some problems. Start a new topic if you need to...

pnpmarques · Post by **pnpmarques** » Thu Jul 11, 2013 3:43 am

Maybe this is the situation:
http://www-01.ibm.com/support/docview.w ... wg1JR37562