DSXchange

We don't have conservative approach. As per our knowledge, Datastage version 8 also is planned in 2006, so we were in the mode of discussion to upgrade directly to 8 instead of 7.5.

So if it is not going to improve upon on performance then does it make sense to upgrade to 7.5.

We are not very keen on upgrading because of the reasons which are mentioned in the upgrade pdf document related to Job Sequencer etc.

Pls suggest.

By Performance I mean, if 1 of my Job is taking 2 Hours in 7.1, then how much time it will take in 7.5 without redesigning the Job.

Elapsed time of the Job will be reduced without changing the design or it will be almost the same.

Hi, 1. I want to know Datastage 7.5 is based on 32 bit Architecture or 64 bit Architecture. 2. We are planning to upgrade from 7.1 to 7.5. Is it really advisable to upgrade. 3. Please let me know the technical differences between these 2 versions which will effect the performance. I have already see...

What do u mean by aborting a Job. There needs some logical reason for stopping the Job.

Pls describe the requirement ....

We have also deployed 5.2 and 7.1 Version of the client on the same machine when we were upgrading the version to 7.1.

There is no issues as far as co-existance of both the version is concerned. You need to have a client switcher.

Thanks all for the Expert advice, Issue is resolved.

I want to start the Sequence Number from 1 in each case.

I have different Jobs ( J1 and J2)

And in each of the Jobs i want surrogate keys starting from 1 and getting incremented.

Hi All, I am planning to use KeyMgtGetNextValue for generation of Surrogate Key in multiple Jobs simultaneously. I want every Job to start the sequence number from 1 and then keep on incrementing. Can it be done using KeyMgtGetNextValue. What is the best possible way to generate surrogate key in Ser...

Checking continuosly means checking the connection regularly with some interval. that interval can be of 5/10 minutes also as we need to check the availabilty for about 5 Hours.

The sleep in the routine is of 10 seconds for testing purpose only.

But i want it to check it every 10 minutes. Can it be done with the Job ?

Hi, We need to check the database availabilty and then run the Jobs. The requriment is to check the database availability continuosly with 10 mins gap and as and when the database is up, run the subsequent Jobs. We have written a routine in which we are using tnsping but unfortunately the Job callin...

Hi, The way to find out the 1st date of this quater is not a problem Oconv(QUARTER.FIRST(Oconv(date(), "D4Y"):"Q":Oconv(date(), "DQ")) ,"D-YMD[4,2,2]") But the problem now is when using this code in server job it is absolutly working fine. But when i use this ...

Hi, I need some advice on date function in parallel extender. I want to have data for only the current quater from dataset. My job would be Full_Data_dataset ---> transformer/Filter_thisQuaterData ----> ThisQuaterData Please let me know what is the solution. I can do it using server routine but then...