DSXchange

Try adding the trailing semi-colon.

Take a look at the generated OSH or score for a job where a Transformer stage is used. This will show you exactly how the transform operator can be used.

The first argument of date_from_string must be the name of a column on the input link to the Modify stage. It cannot be a constant as you are trying to do.

Use an upstream Column Generator stage to generate the constant. Use a cycle with exactly one value.

The Remove Duplicates stage requires that data be sorted on the "key" column(s).

It is also possible that there is a non-printing character in one of the "rogue" values. Or even a non-visible character, such as a space.

CurrentTimestamp() is going to generate a binary timestamp. Format only comes into the picture when you want to convert that to a string. The View Data utility necessarily has to convert to string so we humans can see the value. The easy options are to specify a format string with TimestampToString(...

Descriptor files are not "in node1 node2". There is only one descriptor file per Data Set; the descriptor file has a name with a ".ds" suffix. The data files in the directories nominated as resource disk in the configuration file are known as "segment files". So please ...

Another way to do what Andy proposed (and I'm guessing he does it this way too, as often as not) is

Write out your derivation logic in English or whatever your natural language is. You will likely find that this helps to focus your mind on algorithms that might produce the desired result.

It's called writing a specification, and there's far too little of it done these days!

It would be of great help to me if you could uncheck the premium content. That's just not going to happen. Premium content is the mechanism by which DSXchange is funded. Were it not for the premium content fees, DSXchange could not exist. Premium membership is not expensive - less than 30c (Rs12 ap...

Not me.

Information Server Manager gives you the ability to interact with a source code control system. A deployment package can also include "external folders" (e.g. scripts, controls, etc.) that are sub-directories in the project, which DSX exports don't. Packages also include values files for p...

What does SUBSTR with only one argument do? Are you forcing implicit CASTs in the IN list? What are a, b, c and d? Is ACCT_TYPE indexed?

31-FEB-2013 is a bit more of a worry.

Sometimes the View Data utility is the problem. Can you try looking at the file using some other utility such as a UNIX command?

You have to ask yourself whether these billions of rows are the correct answer. If not, tighten your blocking or matching criteria. As a general rule, blocking in the first pass should eliminate as much as possible from each block of "matchable" records.

Use a correct username/password.

Make sure that the username/password has not expired.