DSXchange

Hi All,

I have a job where I have used hash files for look up. The source for the hash file is from a table.. Will there be a problem if the data from the source table will be huge? Some space related issues?

How can we increase the maximum allowed length of the folder stage?

Hi Forum, I have used Folder stage in a job to read a set of files. But the files may contain more than 999,999,999 characters (which is the maximum length that i could specify as the length). Is it possible to increase this length. Also, it seems that our production server has some memory problems ...

Thank you guys.

Hi forum, I have a job which extracts about 7 million data, performs a look up using a hashed file, does some transformations and loads into two different tables. At the current rate, it takes around 3 hours for completion. Can anyone advice me as to how to improve the performance..... Is the look u...

Thanks ArndW. Hey can I know whats' the actual name of yours? Just out of curiosity :D . I ve seen a lot of answers from you, so useful to me.

Hi All,
I wanted to know how to upgrade to premium user? Also how much is the subscription for the same and the payment is to be made? Am sorry if this type of ques is asked for a n number of times .

Thanks in advance

Hi All,

I got a doubt in the RTI stage (DATASTAGE WEBSPHERE). Where should i post regarding this?


Thanks

Hi All,

How to make the loop activity to be indefinite?

Am using the loop activity stage in 7.5, what cndn is to be given to make the loop indefinite?

Hi, I am too facing a similar problem. The fact is that; the jobs inside the sequence aborts, which is like successfully executed the sequence. Therefore it returns with the return status 1 and starts executing the next sequence. So to abort it, then instead of using a sequencer better write a job c...

Hi priyaraj,

Y don you try a much simpler solution....

There is no need to use stage variables for this functionality.
Instead check condition in the constraint for the link.

Use this constraint:
not(isnull(required link) )

Thanks

"Log warnings after activities that finish with status other than OK" and/or "Automatically handle activities that fail" "




But then where to find these options? Am using datastage 7.0.

Hi All, I have a job control which attaches a job sequence, the job sequence calls two more sequences. All the triggers are set to OK Condn. But still if a job inside the sequence aborts, the next job within that sequence aborts: but the calling sequence executes till the last job and gives a finish...

Thnx 4 de help chulett. The suggestion really worked.
I used it in the job control at the end of all process.