Search found 214 matches
- Mon Nov 03, 2014 9:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Maintain table column order in output file - RCP
- Replies: 1
- Views: 2221
Maintain table column order in output file - RCP
Hi, We have a job which extracts data from Oracle DB. We have enabled RCP and pass around 70 tables to this job. The problem we face is that the output column order in extract file is not matching the columnorder of table definition in Oracle. Is there anyway we can enforce this column order on the ...
- Wed Oct 22, 2014 10:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: One generic job to extract data from all tables
- Replies: 4
- Views: 3961
- Mon Oct 20, 2014 8:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: One generic job to extract data from all tables
- Replies: 4
- Views: 3961
One generic job to extract data from all tables
Hi, I'm getting back to DataStage after a couple of years, so I apologize first in case the question below has been answered earlier. I tried searching but did not get the answer. I have 130 Tables in my ODS schema. Data from all these tables needs to be extracted everyday by using last_update_dt co...
- Wed Jul 31, 2013 11:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage Server vs SSIS
- Replies: 12
- Views: 20417
- Thu Jul 25, 2013 8:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage Server vs SSIS
- Replies: 12
- Views: 20417
- Wed Jul 24, 2013 11:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage Server vs SSIS
- Replies: 12
- Views: 20417
Datastage Server vs SSIS
Hi, Currently we are planning to move 800 plus server jobs from Datastage Server to SSIS. We are trying to see if there is any functionality which is currently present in Datastage Server which would be difficult to replicate in SSIS. SQL Server is our primary DB, with a few connections to Sybase DB...
- Fri Apr 26, 2013 12:33 pm
- Forum: General
- Topic: dsjob issues
- Replies: 1
- Views: 1709
- Fri Apr 26, 2013 10:08 am
- Forum: General
- Topic: dsjob issues
- Replies: 1
- Views: 1709
dsjob issues
Hi, My jobs are not getting trigerred when I use dsjob. It was all working fine and then no job isgetting triggered. Now this is what I get :/apps/Ascential/Server/DSEngine/bin>dsjob :/apps/Ascential/Server/DSEngine/bin> PREVIOUSLY uadsgd31:/apps/Ascential/Server/DSEngine/bin>dsjob Command Syntax: d...
- Tue Apr 23, 2013 11:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Slow performance after migration to SQL Server 2008
- Replies: 7
- Views: 5045
- Mon Apr 22, 2013 9:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Slow performance after migration to SQL Server 2008
- Replies: 7
- Views: 5045
- Mon Apr 22, 2013 9:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Slow performance after migration to SQL Server 2008
- Replies: 7
- Views: 5045
- Mon Apr 22, 2013 8:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Slow performance after migration to SQL Server 2008
- Replies: 7
- Views: 5045
Slow performance after migration to SQL Server 2008
Hi, We migrated our database from SQL Server 2000 to SQL Server 2008. We have noticed a steep drop in performance, the inserts are almost taking double the time. The only change we made was to point .odbc.ini file to new server. Does anything else need to eb modified e.g: ODBC drivers? See a sample ...
- Thu Jan 24, 2013 12:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Filename column for multiple file read
- Replies: 7
- Views: 4452
- Thu Jan 24, 2013 12:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex coding in Datastage
- Replies: 6
- Views: 3390
- Thu Jan 24, 2013 11:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Filename column for multiple file read
- Replies: 7
- Views: 4452