DSXchange

Is this MappsMDI205ProjectsExtractJob your job which got aborted or this a job which is called by the aborted Sequence or batch.
If so what is the actual error log of the job MappsMDI205ProjectsExtractJob?
By the time when this happen, is that the only job been called?

Or just type dsjob and hit enter, from unix command prompt. You will get list of all options avaialbe to run dsjob command.

Do you face this error repeatedly even after reconecting to server?

If your 2 keys both are dummy? I mean are they a constant single value?
If so your data wont be partitioned at all, all the data will be processed only in one node.

Hi, It will be better if we have a seperate thread related to each video tech tip So that all its resective doubts and clarification can be discussed in that. The one like ... On the chapter of output, when the job is executed, the the link color chages to indicate the completion. But the link in be...

##W TFPA 000012 20:05:49(000) <main_program> Warning: the PWD environment variable is not defined. Remote process startup may be unsuccessful as a result.If your ORCHESTRATE job does not start up correctly, please set your PWD variable to a value that will work on all nodes of your system. Check ou...

You do have it. Use the Expression Editor in a Transformer stage. It will appear in among the available Functions. ... thanks for ur reply,,i found timestamptodate function and when i am trying to use it it gives timestamp qoute,,can you pls help me wat to enter in that Sorry, could you be clear on...

In you given example 0.00053, length = 6 and scale = 5.

If you are talking about removing duplicates then you can search for this. There are lots of posts on removing duplicates. You can do it using a hash file or land your data in a staging table and then select distinct. Kim has mentioned the option available in both Server and PX. You still left out ...

ok, I tried to find by generated OSH or by DUMP SCORE, but before going it stirked. There is nothing to do with the partition type. It all depends on how the data is flowing from the join stage. Say for example, if you have left outer join and the left record set is hash partiton on a key and right ...

If bin/uv give this warning bin/dssh will also do the same, as for as I have faced (facing..).

Make sure you give the full path where the batch file reside.

In the above table, a uniqe index is already present. If your data set have duplicat data based on the key, you are violating the constraints. Or by any chance if you are running twice the same job with same input in insert type, you will get this error.

Hi dsdesigner , The same has been discussed many times earliar. Explicit sort is always recomended as for as performance is concern. The main reason, would be the buffereing. If the sort need to be done by the link option on any stage like join, the whole two files need to be buffered inorder to get...

Yes, the strongest point of restartability was hidden in my previous go thorugh.