Search found 3 matches
- Tue Apr 20, 2004 2:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Moving data from an Oracle database to a SQL Server database
- Replies: 2
- Views: 1096
Moving data from an Oracle database to a SQL Server database
I need to speed up data transfer from an Oracle database to a SQL Server database using an ODBC connection. I wanted to use 2 jobs where the first job transfers the Oracle data to a sequential file. This job is very fast. The problem I am having is getting the sequential file transferred to the SQL ...
- Mon Apr 12, 2004 7:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: SQL exec before/after routine to truncate SQL Server table
- Replies: 4
- Views: 1739
- Thu Apr 08, 2004 10:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: SQL exec before/after routine to truncate SQL Server table
- Replies: 4
- Views: 1739
SQL exec before/after routine to truncate SQL Server table
I am running a job that transfers data from an Oracle 9i database to a SQL Server database using an ODBC stage. This is really slow because there is no option for truncating the SQL table. I would like to run a before/after routine to truncate the SQL table. Thanks