DSXchange

I need to run this job parallely (Allow Multiple Instance). If i use sequential file, i may get error , because sequential file cannot be accessed by multiple processes. And the other thing is, i have to update the flags in the Hashed file, based upon the keys. In Sequential file, i cannot achieve t...

Introduce, Sequential File or IPC before the Target Stage, That might solve the problem.

I am having an issue, even if the job aborts, the output link from a Hashed File Stage opens, and processing certain (100) rows. I dont want to process, if the Job aborts, because i am doing some business caluclations in that link. My job design , looks like DRS 1-------->IPC----------> TRANSFORMER1...

Excellent Ray, Cool and Superb Solution. Thanks a lot.

I have to add UpCase , for the source string also, then only i am getting the desired output.

No , the input might not be same format always, I just give that example for a better clarity.

Gurus, Is there any way to replace a set of characters, case INsensitively. For ex, My input can be Hash_CRC_TABLE1 HASH_crc_Table2 My output should be Hash_TST_TABLE1 HASH_TST_Table2 I can convert the input to uppercase or lower case , and replace the string, but I want to maintain the case for oth...

If you want to pass values from job1 to job2, then specify a job parameter in job2, and pass the value from job1. For passing the values, you can consider writing the value to userstatus in job1 or write it to a hashed file and retrive it in job2. For doing this, you might require to use sequence jo...

You can use @INROWNUM in your derivation directly, if you dont want to continue from the last used value.

And if you want to use from your last used value, consider writing the final value to a Hashed File, and pass the value as job parameter for the next run.

If you checked the OMIT option while logging in , uncheck it and login by giving userid and password.

I hope , if you reimport it will clear the old entries and create the jobs again.

I dont know any other ways, you need to get access from the author only.

Vincent Mc Burney has written a article on ittoolbox , please check whether it is useful.

And there was a another doc, but now it is password protected. Check with the author , whether you can have access.

This can be done by doing a select in DS_JOBOBJECTS, Kim Duke has posted the code already. Do a Search, alternatively you can open the jobcontrol of the Sequence, and look at the first part. If you have followed some naming conventions for your jobs, it would be easy to extract from there.

How we can schedule the exports from Manager? Can you refer to any documents?

Check in Kim Dukes website, he is having a batch utility to export all the projects in a server.

Could You please expalin, how you want your output? You can always do it by using Stage Variables. For ex, if the following is your requirement, i will order by salary in descending and do the calculations in the stage variables The following example uses the LEAD function to return the salary from ...