DSXchange

Hi All, We have moved our code (Parallel Jobs) to our UAT environment. The jobs get aborted with the following error in the log 44 STARTED Mon Apr 7 13:31:25 2008 Job EDQS_CUSTID aborted. 45 INFO Mon Apr 7 13:46:28 2008 From previous run (...) 46 STARTED Mon Apr 7 13:46:28 2008 Resetting Job EDQS_CU...

Am I doing right?

[quote="ray.wurlod"]That would depend entirely on what the routine does, so there's no ready answer to what is at best a hypothetical question. Having said that, it does not matter that there are "gaps" in sequences o ...[/quote] Thanks Ray for your reply. I tried writing the fol...

Could anyone help me on this post.

Hi,

There are many posts with this issue do a search for the message you will get.

Also check for the column names if you are renaming the column names before the left or right links.

Bye
Devi

Hi All, I have a requirement of combining 18 datasets into one. Each of these dataset have the same metadata and the target dataset would also need to be same. I am aware of a command orchadmin cp <src_ds> <trg_ds> Does this command support wild card option example: orchadmin cp <*_src_ds> <trg_ds> ...

Thanks Ray for your reply. I am following Joshy approach to generate a surrogate key where in he mentioned we will need a parallel routine in the transformer stage to update the last maximum number generated in the surrogate key. http://blogs.ittoolbox.com/dw/soa/archives/surrogate-key-generation-in...

Hi All, I have a requirement of updating the environment parameter defined at project level. I need to build a parallel routine of the same so that it can be used in a parallel job. I have referred the advanced PX manul for the same and know how to create a parallel routine. But does any one have a ...

Hi All, While I was going through the Advanced guide of DataStage I had this query: Page 2-8: Using Sequential File stage I did not understand the point number 2. It says: If writing fixed width columns which are Varchar we set field width property and pad char property in Edit Column Metadata dialo...

You could refer the Advanced guide to get information on BuildOp stage or wrapper stages. Basically a good knowledge of C++ is needed to write the logic you are looking for. Also DataStage is not difficult but fun and exciting to learn and work on. Do try your hands on it you will find its not diffi...

Opps...Sorry...
How do I move the post to parallel forum?

Hi All, While I was going through the Advanced guide of DataStage I had this query: Page 2-8: Using Sequential File stage I did not understand the point number 2. It says: If writing fixed width columns which are Varchar we set field width property and pad char property in Edit Column Metadata dialo...

Thank you.

Thank you.
What is the orchadmin command?

Hi All,

Is there a way I can check the columns in a dataset. It has RCP enabled in it. I need to know what are the columns in the dataset.

Thanks
Devi