Unable to load into a Table from a dataset.............
Moderators: chulett, rschirm, roy
Unable to load into a Table from a dataset.............
Hi ,
I have a dataset with 4 lac reocrds.
i am loading to a oracle table.
there is no transforamtion....involved.
But.......i m unable to load a single record.
the table is also empty.
Awating ur reply.
Thanks in advance........
I have a dataset with 4 lac reocrds.
i am loading to a oracle table.
there is no transforamtion....involved.
But.......i m unable to load a single record.
the table is also empty.
Awating ur reply.
Thanks in advance........
Thanks,
Pavan
Pavan
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
unable to load........
us1aslam1us wrote:Need more information. what does the log suggest ? Also does the user have access to the table? Check any constraints on the table.
i m able to insert a row externally using a insert command.
When i m running the Datastage job.......its not loading.
There is no error in the log file.
Its taking a lot of time.
More than 4 hrs............
Thanks,
Pavan
Pavan
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
a) when you run the job, does it show that the correct number of rows were read from the dataset?
b) what method are you using in your Oracle stage?
c) Have you tried adding a reject link to your Oracle stage and analyzing the output?
b) what method are you using in your Oracle stage?
c) Have you tried adding a reject link to your Oracle stage and analyzing the output?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 27
- Joined: Mon Jul 09, 2007 1:06 am