Search found 2 matches
- Mon May 22, 2006 3:12 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Clearing ORA target table for subsequent use in bulk loading
- Replies: 1
- Views: 1084
Clearing ORA target table for subsequent use in bulk loading
Hi, I need to do a daily full load for a particular oracle target table, and am using the ORA OCI Load Stage (ie the bulk loader) with Direct Path load. Now, for this to work properly, it seems the target table must already be empty, since the bulk loader stage does not give the option of clearing a...
- Wed Oct 19, 2005 10:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Access DB and spaces in column names
- Replies: 9
- Views: 14675
Thats the problem. That was th efirst thing that came in to my mind but it doesnot work. I ran into the same problem as Deepak today, and I simply did what ray and crouse suggested. SELECT `Table 1`.FirstColumn, `Table 1`.`Second Column` FROM `Table 1`; It worked without any problems. Are you sure ...