Search found 24 matches

by Raghumreddy
Mon Nov 28, 2005 11:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle rejects
Replies: 2
Views: 1064

Re: Oracle rejects

1. Check your Condition again for the Rejects.
2. Check the datasage Log in Director what it says.
3. Check the condition in Insert Link also.


HTH
Raghu
by Raghumreddy
Wed Nov 16, 2005 11:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Load Problem
Replies: 9
Views: 4088

Re: Load Problem

Hi Solutions 1. You can delete the records loaed from the target and reruns the job again 2. put one more hash file to store the record count and use that as refeence when you are loading the data in second Run. (Ex: if you load 50000 then the hash file data will be 50000 as number and when you reru...
by Raghumreddy
Tue Nov 15, 2005 3:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: moving jobs
Replies: 8
Views: 1924

You can drag drop the jobs in Designer from one category to another.
HTH
Raghu
by Raghumreddy
Mon Nov 14, 2005 6:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Exception raised in GCI subroutine
Replies: 10
Views: 7658

Re: Exception raised in GCI subroutine

Check the user id and password that you are working with.
It look like Access Violation.

Please check with the DBA

HTH
Thanks
Raghu
by Raghumreddy
Mon Nov 14, 2005 4:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence thinks job is not runnable
Replies: 9
Views: 4385

Re: Sequence thinks job is not runnable

hi I guess the solution in the case of Yamini is specific to the server capabilities and other factors. The problem sounds me like you dont have a control on the number of jobs that you are running. So you are running out of either number of files to be opened or number of processes used. Incresing ...
by Raghumreddy
Mon Nov 14, 2005 3:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash Files
Replies: 2
Views: 1041

Re: Hash Files

Datastage Uses its own hasing algorithams

Hash files stores the data by using the hasing algo's.

The data written by the hashfile is not in plain text.

Please see the Ascential docs for further on Hash files.

Thanks
Raghu
by Raghumreddy
Mon Nov 14, 2005 12:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert Decimal
Replies: 3
Views: 1391

Re: Insert Decimal

Divide the number by 1000 Ans = Arg1/1000 Hope this helps. Raghu Hi, I've data from source file coming as 05500 04500 I need to insert the decimal place as 05.500 Iwas thinking of splitting the column as Arg1[1,2]:'.':Arg1[3,3] is there is any built in or better way of doing it, I tried selecting sc...
by Raghumreddy
Thu Nov 10, 2005 12:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Buffer size and Timeout
Replies: 1
Views: 713

You need to do the source stage "Read Only". So that you can eliminate the locks. Buffters depends on your system memory capacity. Please ask your Ds admin how much memory is used at the peak and and what are the % of memory used. You can use multiples of 128's as the buffer sizes. Most of...
by Raghumreddy
Thu Nov 10, 2005 12:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How do you make the job in runnable state after aborts
Replies: 7
Views: 1547

Scheduled through windows scheduler ?

Write a batch file to read the job from command prompt and add the .bat file to scheduler

As others discussed you can reset a job and Run with DSJOB command.
reddy wrote:It's a Scheduled job.