Search found 288 matches
- Thu May 28, 2015 2:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Table action as truncate Vs truncate statement in before SQL
- Replies: 9
- Views: 6607
Table action as truncate Vs truncate statement in before SQL
Hi, We have to truncate around 30 tables before loading them individually in differnt DataStage load jobs. So, wondering which one is the best among the below options in terms of faster truncation and loading (time together). 1. Write a stored procedure to truncate all the tables before we trigger t...
- Mon Nov 03, 2014 7:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Framework for creating a generic job
- Replies: 4
- Views: 3027
There could be more than 10 databases/applications and each would consist around 20 to 30 tables. Can the .dsx file do any wonders here? I mean using Unix scripts to pass the table names/keys etc.. to the .dsx of a precreated datastage job and then import it back. This is just a thought and not sure...
- Mon Nov 03, 2014 12:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Framework for creating a generic job
- Replies: 4
- Views: 3027
Framework for creating a generic job
Hello all, Prior to posting a question here, I searched the entire repository to find a solution to my question but no luck!! (may be my poor searching skills :oops: ) Question: We are trying to build a framework where a single job has to be build which should pick up the fields from the table dynam...
- Wed Jul 04, 2012 3:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading data from datasets to text file
- Replies: 3
- Views: 2410
Loading data from datasets to text file
Hello, We have a requirement to load the dataset into a text file, archive the text file and delete the datasets due to the space constraints. We thought of loading the data from dataset to a text file through orchadmin utilities. So, can anyone suggest if this is a good approach to use the orchadmi...
- Thu Sep 22, 2011 3:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: new line charecter in btwn double quotes in sequential file
- Replies: 10
- Views: 6794
- Thu Sep 22, 2011 2:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: scenario
- Replies: 3
- Views: 2965
- Tue Sep 21, 2010 3:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Does DSJ server 8.0 support 64 bit OS???
- Replies: 16
- Views: 10020
- Tue May 04, 2010 6:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Find/List number of Jobs ran on a Particular Day
- Replies: 7
- Views: 4233
- Sun May 02, 2010 11:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal Conversion error
- Replies: 8
- Views: 10620
- Fri Apr 30, 2010 2:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ERRO--Could not find input
- Replies: 4
- Views: 3121
- Fri Apr 30, 2010 2:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal Conversion error
- Replies: 8
- Views: 10620
- Fri Apr 30, 2010 2:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue in Change capture stage
- Replies: 2
- Views: 3796
- Sun Nov 08, 2009 12:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change capture stage insert issue
- Replies: 2
- Views: 2196
Change capture stage insert issue
Hi, I came across a scenario while doing the delta between previous data and current data. In previous data, i just have one record and in my current data, i have an updated record and a copy of the record which is already there is previous data. When, i do a delta, i should get only one update. But...
- Mon Jun 15, 2009 8:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Exporting jobs
- Replies: 6
- Views: 3597
- Mon Jun 15, 2009 8:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Exporting jobs
- Replies: 6
- Views: 3597
Exporting jobs
Hi, We are in a process of exporting our jobs in production. Our project is a shared one and we just want to export only our jobs into a single .dsx file. I have searched some old posts and many gurus suggested to use some scripts. So, i just wanted you to confirm below 2 questions. :roll: 1. We can...