Source has data but not populating in Oracle

vinnz · Post by **vinnz** » Wed Sep 30, 2009 3:40 pm

Any warnings logged?
Are there any constraints on that column in Oracle?
What are the actual values you are trying to load - does it have any special characters or encoding ?

ArndW · Post by **ArndW** » Thu Oct 01, 2009 1:36 am

I bet your PX job has the datatype "VarChar" for this column. Declare the type as numeric in your job and perform an explicit conversion in PX.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 01, 2009 1:53 am

Are you using an Oracle Enterprise stage? Are you capturing the rejected rows using a reject link? If so, push these rows into some structure (maybe a text file) that you can review with a hex editor.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 01, 2009 1:55 am

Akumar1 wrote:I have an urgent issue.

DSXchange is an all-volunteer site whose members post as and when they can. We don't do "urgent".

If you need urgent answers, sign up with your official support provider for premium service. Learn the true cost of "urgent".

Akumar1 · Post by **Akumar1** » Thu Oct 01, 2009 6:31 am

ray.wurlod wrote:
Akumar1 wrote:I have an urgent issue.
DSXchange is an all-volunteer site whose members post as and when they can. We don't do "urgent".

If you need urgent answers, sign up with your official support provider for premium service. Learn the true cost of "urgent".

Point taken..

om.ranjan · Post by **om.ranjan** » Thu Oct 01, 2009 7:28 am

ray.wurlod wrote:Are you using an Oracle Enterprise stage? Are you capturing the rejected rows using a reject link? If so, push these rows into some structure (maybe a text file) that you can review with a hex edito ...

Yes, Oracle Enterprise stage, I do have reject link in transformer not in Oracle Enterprise stage as I have used Load and Append mode.

when I changed the data type from decimal(11,3) to varchar (11,3) I'm able to insert the records

but this not a solution...

please suggest

Thanks,

om.ranjan · Post by **om.ranjan** » Thu Oct 01, 2009 7:29 am

ArndW wrote:I bet your PX job has the datatype "VarChar" for this column. Declare the type as numeric in your job and perform an explicit conversion in PX. ...

It is decimal (11,3) NULLABLE

om.ranjan · Post by **om.ranjan** » Thu Oct 01, 2009 12:07 pm

om.ranjan wrote:
ArndW wrote:I bet your PX job has the datatype "VarChar" for this column. Declare the type as numeric in your job and perform an explicit conversion in PX. ...
It is decimal (11,3) NULLABLE

Hi All,

Any update on this issue will be appreciated.

Thanks,
Rnajna

nagarjuna · Post by **nagarjuna** » Thu Oct 01, 2009 12:10 pm

I hope you are using oracle load method . can you try with upsert oprion if possible and let us knw the result ?

kduke · Post by **kduke** » Thu Oct 01, 2009 12:19 pm

Do you have a reject link?

nagarjuna · Post by **nagarjuna** » Thu Oct 01, 2009 12:34 pm

Hi Kim ,

I think they have mentioned "load" as an option . I believe there is no reject for it .

om.ranjan · Post by **om.ranjan** » Mon Oct 05, 2009 6:27 pm

nagarjuna wrote:Hi Kim ,

I think they have mentioned "load" as an option . I believe there is no reject for it .

Hi Kim,

Nag is correct, there is no reject link.

Thanks,
Ranjan

DSXchange

Source has data but not populating in Oracle

Re: Source has data but not populating in Oracle

Re: Source has data but not populating in Oracle

Re: Source has data but not populating in Oracle