DSXchange

Use a TIME dimension and count the number of business days between two rows. Summing a "business day indicator" is a handy trick.

Hmmm, can you try a before telnet command and get a directory listing?

Same userid/password used in the job?

It looks like a user/permissions error. Double-check your userid on the FTP session.

Has anyone else ever imported metadata from this Unidata server? There's a long setup/configuration section under your Start menu --> Ascential documentation explicitly covering setting up Universe and Unidata. If you're not the first you should talk to a coworker who's done it before. If you are th...

What database, Plug-In or ODBC? Is this a new install? Is this a new database?

So is it ok in principle to have two inputs to the same hashed file? Two processes, both updating a hashed file simultaneously, in a server job? I thought hashed files weren't available in PX because they didn't support parallel access. They're not in PX because PX is a horse of a different color. ...

Is your project file system full? Usually this is a bad thing.

You've got a syntax error in one of your Transformer stages. It could a line with a trailing = sign, or a missing quote, or use of a reserved keyword.

There's probably a datatype issue (wrong datatype or NULL) happening in the Aggregator stage and the job is blowing up. The 100 rows is not an indication of which row has the issue, just the last time the job updated its link statistics. If I was you I would take the sequential file and try to run t...

If Colin says there's 2 Transformers, then it may the case that there is another Transformer that is directing rows down one path or the other. In either case this will work fine if all of the rows always come from one data stream or the other. If rows are flowing down two separate streams then you ...

Sorry, I was answering while you were adding more info. Did you check your $APT_ORACLE_LOAD_OPTIONS to see what your settings are? You'll want to set this according to your needs. It affects your Control file options and you can set custom values there.

Warning limits are set when a job is ran by whatever facility you are using. If it's Director, it's part of the dialog box where you press the Run button. If it's job control, it's part of the command line invocation. If you fail to specify via the job control, it then defaults to what is set as the...

It seems like a Join or a Merge would work, depending on how you want to handle matching/non-matching rows, followed by a Filter stage with your condition for retaining results.

You need to specify the expected row count and the destination of the results before we can give a best recommendation for your SPECIFIC example. If the result is going to load into a table within the same database instance and reduce from 1 billion rows to 1 million rows, then the argument would be...