Search found 169 matches
- Fri Dec 12, 2003 12:28 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to tranfer tables from SQLServer to Oracle
- Replies: 6
- Views: 2841
Re: How to tranfer tables from SQLServer to Oracle
I think you can also do this with MetaRecon. To the best of my knowledge I do remember that MetaRecon can analyse any DS connected throught ODBC. So in your case if you have MetaRecon, just take SQL server as your input and you can select Oracle as an target database. MetaRecon also created basic jo...
- Mon Dec 01, 2003 9:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using an array as a job handler
- Replies: 30
- Views: 14798
- Wed Nov 26, 2003 3:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Testing methodologies for DS jobs
- Replies: 7
- Views: 3048
- Wed Nov 26, 2003 10:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Repository tool bar
- Replies: 5
- Views: 1257
Re: Repository tool bar
Did u try closing and opening the DS Designer or Click on the 'Open Job' icon to reset the connection with ur DS Server.
hope this helps..
hope this helps..
- Wed Nov 26, 2003 10:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Testing methodologies for DS jobs
- Replies: 7
- Views: 3048
Testing methodologies for DS jobs
I would like to know if any of you have ever come accross or come up with testing methodologies for DS jobs. I am sure Kim, Kenneth, Ray and Teej may have their own ways of testing DS before exporting/moving them to Testing or Production boxes.
Care to share them here..
Thanks
Care to share them here..
Thanks
- Wed Nov 26, 2003 10:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Testing methodologies DS jobs
- Replies: 0
- Views: 291
Testing methodologies DS jobs
testing methodologies
- Wed Nov 26, 2003 9:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Testing methodologies for DS jobs
- Replies: 0
- Views: 277
Testing methodologies for DS jobs
I would like to know if any of you has come across or come up with Testing methodologies for DS jobs. I am sure Teej, Ray, Kim, Kenneth and many others have their own ways of testing the DS jobs before they export them to Testing or Production boxes. Care to share them here... I am not sure if this ...
- Wed Nov 26, 2003 9:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Testing Methodology for DS jobs
- Replies: 0
- Views: 273
Testing Methodology for DS jobs
I would like to know if any of you has come across or come up with Testing methodologies for testing the DS jobs. I am sure Teej, Ray, Kim, Kenneth and many others have their own ways of testing the DS jobs before they export them to Testing or Production boxes. Care to share them here... I am not s...
- Wed Nov 26, 2003 9:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Testing Methodologies for DS jobs
- Replies: 0
- Views: 391
Testing Methodologies for DS jobs
I want to know if any of you have ever come across or come up with any testing methodolgies for Testing the DS jobs. I am sure Ray, Kim, Kenneth, Teej and many others must have some sought of way or methodology to test the jobs written before thay actually export them from Development to Production....
- Tue Nov 04, 2003 3:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash file Overwrite or Append by Default ?
- Replies: 5
- Views: 1010
Aborted How many rows will be committed ?
I wanted to know how many rows will be committed to the DB when the job aborts. I know this is the multiple of Transaction Number in my target OCI/ODBC stage.
I want to clarify this before I come to my own conclusion.
I am sure this is duplicate posting. Please excuse me for this.
I want to clarify this before I come to my own conclusion.
I am sure this is duplicate posting. Please excuse me for this.
- Tue Nov 04, 2003 3:47 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash file Overwrite or Append by Default ?
- Replies: 5
- Views: 1010
Aborted How many rows will be committed ?
I have hash-files all over in my jobs. *) I want to know by default whether these hash files are overwritten or appended everytime those jobs are exectued. *) also is there any harm in checking the box - 'Clear file before writing' ? in the Input tab for Hash File? *) and also why is the option 'Cr...
- Tue Nov 04, 2003 10:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash file Overwrite or Append by Default ?
- Replies: 5
- Views: 1010
Re: Hash file Overwrite or Append by Default ?
Kenneth,
That was a wonderfull explaination of the Hash File usage.
NEVER MIND I FOUND THE ANSWER !!
Thanks for your help ANYWAYS..
That was a wonderfull explaination of the Hash File usage.
NEVER MIND I FOUND THE ANSWER !!
Thanks for your help ANYWAYS..
- Tue Nov 04, 2003 9:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash file Overwrite or Append by Default ?
- Replies: 5
- Views: 1010
Hash file Overwrite or Append by Default ?
I have hash-files all over in my jobs. *) I want to know by default whether these hash files are overwritten or appended everytime those jobs are exectued. *) also is there any harm in checking the box - 'Clear file before writing' ? in the Input tab for Hash File? *) and also why is the option 'Cre...
- Tue Nov 04, 2003 9:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash File - Does it append or Overwrite?
- Replies: 0
- Views: 407
Hash File - Does it append or Overwrite?
I have hash files in my jobs. I want to know whether those hashfiles are appended or overwritten everytime whenever those jobs are executed. Also if the hash file doesn't exist .. will it create it.. I know it does .. but please tell me why is the option 'Create file' checkbox in the Hashfile 'Input...
- Mon Nov 03, 2003 1:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: BASIC routine is not cataloged
- Replies: 5
- Views: 9893
BASIC routine is not cataloged
ILArchives..JobControl (@FAILED2): Controller problem: BASIC routine is not cataloged: DSU.ForceFail
The above is the error DS throwing when I tried to execute a Sequencer with an routine embedded to kill the sequencer in case of any error.
Any help on this is appreciated.
The above is the error DS throwing when I tried to execute a Sequencer with an routine embedded to kill the sequencer in case of any error.
Any help on this is appreciated.