DSXchange

vivekgadwal wrote:Craig - Aside from this, I did not find a way inside aggregator to have both sum and count at once as you were mentioning. If you have that job, where you implemented this, could you please share the way you did that?

SUM(1) is COUNT

I disagree. That's how the null values got to be in the job in the first place. Because they were being interpreted from the source file.

There's a checkbox at the top of the page that allows just the error lines to be displayed. This can be very useful when there are thousands of informational messages.

The older compilers can still be downloaded.

Remember, too, that range lookups are compiled as transform operators (that's why the compiler became involved).

Is the file system where the project directory lives full? With 4700 jobs you have have also hit the operating system limit of the number of subdirectories in a directory.

Poovalingam wrote:When I use DSExecute to do delete, the command ReturnCode variable is showing Zero for both success and failure of the command.

My question was "how do you know when the command has succeeded and when the command has failed, if the exit status is always zero?"

Data are stored in a Lookup File Set in a pre-indexed format. Because of this the only access method is "read by key", which the data browser does not support. The benefit is that, when used with a Lookup stage, the LUT_CreateOp operator does not need to be executed because the index alrea...

There are at least two fields in your ODBC Connector for which you have not provided values. Open the stage editor and they should be marked with warning icons. Hover your mouse pointer over each warning icon to be advised what the problem is.

Is there a /O switch for dsexport?

There's nothing "always there". Prefixes don't have to be http: or https: - other possibilities include ftp: and file: - you will need to know what all the possibilities are to create a complete solution. Perhaps there's scope for someone to create a URL rule set for QualityStage?

That's the correct result in a twos-complement setting. A 32-bit signed negative integer is represented as 65536 + (value). In this case, 65536 + (-12) = 65534. Binary representation of 65534 is 11111111111111111111111111110100.

Positive signed integers range from 0 through 32767.

In server jobs it can also be the PRECISION setting. By default, arithmetic results are rounded to four decimal places (seven for I-descriptors). The PRECISION setting can increase this up to 14.

Runtime Column Propagation is not available in server jobs.

That's the totality of your presentation.

We use English here. English of a professional standard. Please try to do so as well, and desist from over-use of exclamation marks. If you want to work in tabloid journalism they may have a place. They don't in communicating professionally with peers and colleagues, and definitely not in documenta...

You get the raw numbers (as link row counts). The rest is arithmetic.

Edit: That's for all passes, of course.