Search found 169 matches

by raju_chvr
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...
by raju_chvr
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

Hello Kenneth, Where can I get a copy of this program mentioned in this topic for download.

thanks in advance
by raju_chvr
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

Appreciate your input Kenneth.
by raju_chvr
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..
by raju_chvr
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
by raju_chvr
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
by raju_chvr
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 ...
by raju_chvr
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...
by raju_chvr
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....
by raju_chvr
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.
by raju_chvr
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...
by raju_chvr
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..
by raju_chvr
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...
by raju_chvr
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...
by raju_chvr
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.