DSXchange

There are several theories, including that that was his daughter's birthday. I have never seen conclusive proof of any of them.

I have a client who (I have just learned) does ET using DataStage, but then uses Teradata utilities (MultiLoad and BTEQ) to load the DW/DM. These utilities are not run under control of DataStage; they are run from AutoSys. A separate script (again from AutoSys) populates a Teradata table with "...

Welcome aboard.

Dare we ask why?

I don't have a parallel routine. The logic is a simple insertion sort. Here it is as a server routine (language DataStage BASIC). FUNCTION SortStringChars(TheString) EQU MAX_CHARS TO 1000 DIM Chars(MAX_CHARS) If UnAssigned(TheString) Or IsNull(TheString) Then Ans = @NULL End Else Ans = "" ...

Resource Disk full!

uv is a compiled command indeed, but it does try to read a number of files, such as .uvconfig, VOC and others. And when the -admin option is used, there will be other files that it needs to read. If any one of them is missing, the command is likely to fail. As to why a non-standard PS1 value would ...

You are going to need a routine to sort the characters in a string.

That and Build stages.

So what? Make your match designer database large enough. This was not part of your original question.

Scroll to the right in the Columns grid in your Sequential File stage and set the "Contains Terminators" property for the field(s) in question.

Almost certainly, though you haven't really given enough information. There is a limit on the number of passes in a single match specification, which depends on the exact version of the product you're running, but version 8.x should have an adequate number of passes for your requirement (depending o...

As a Decimal data type, 0000450000.00 is the same as 450000.00. The value is actually stored one digit per nybble; the leading zeroes are added to prove that precision is being managed correctly. The number of digits following the decimal placeholder is determined by the scale setting. If you requir...

They are not environment variables, they are system variables @PARTITIONNUM and @NUMPARTITIONS. In the expression editor they can be selected from the drop-down list of expression operands under the system variables section.

With NLS enabled it should always be Unicode internally. With NLS not installed I understand it is ASCII internally.

How do you calculate productive time? How do you calculate idle time? Could this be different for different employee types? What other business rules have you neglected to mention? Does the organisation have a PHB?