Page 1 of 1
Re: Source has data but not populating in Oracle
Posted: Wed Sep 30, 2009 3:40 pm
by vinnz
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 ?
Posted: Thu Oct 01, 2009 1:36 am
by ArndW
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.
Posted: Thu Oct 01, 2009 1:53 am
by ray.wurlod
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.
Re: Source has data but not populating in Oracle
Posted: Thu Oct 01, 2009 1:55 am
by ray.wurlod
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".
Re: Source has data but not populating in Oracle
Posted: Thu Oct 01, 2009 6:31 am
by Akumar1
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..
Posted: Thu Oct 01, 2009 7:28 am
by om.ranjan
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,
Posted: Thu Oct 01, 2009 7:29 am
by om.ranjan
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
Posted: Thu Oct 01, 2009 12:07 pm
by om.ranjan
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
Posted: Thu Oct 01, 2009 12:10 pm
by nagarjuna
I hope you are using oracle load method . can you try with upsert oprion if possible and let us knw the result ?
Posted: Thu Oct 01, 2009 12:19 pm
by kduke
Do you have a reject link?
Posted: Thu Oct 01, 2009 12:34 pm
by nagarjuna
Hi Kim ,
I think they have mentioned "load" as an option . I believe there is no reject for it .
Posted: Mon Oct 05, 2009 6:27 pm
by om.ranjan
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