Source has data but not populating in Oracle
Moderators: chulett, rschirm, roy
Re: Source has data but not populating in Oracle
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 ?
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 ?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Source has data but not populating in Oracle
DSXchange is an all-volunteer site whose members post as and when they can. We don't do "urgent".Akumar1 wrote:I have an urgent issue.
If you need urgent answers, sign up with your official support provider for premium service. Learn the true cost of "urgent".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Source has data but not populating in Oracle
ray.wurlod wrote:DSXchange is an all-volunteer site whose members post as and when they can. We don't do "urgent".Akumar1 wrote:I have an urgent issue.
If you need urgent answers, sign up with your official support provider for premium service. Learn the true cost of "urgent".
Point taken..
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
![Question :?:](./images/smilies/icon_question.gif)
please suggest
Thanks,
RANJAN