DSXchange

lets say you have source records with 2 columns - a number datatype called "customer_key" & a varchar column called "name". Modulus -- lets say you want 7 partitions. which partition the record will fall into will depend on the result of mod (customer_key, 7) .. i.e. partitio...

Prashant, Go to Chapt 2 (Optimizing Performance in Server Jobs) of the Server Job Developer Guide and look for an example in the section "CPU Limited Jobs - Multi-processor Systems" This example partitions (using Link partitioner) the rows so that it can be worked upon (using a transformer...

A hash file has 2 basic building parameters: 1) modulus [how many groups/bins to create - 1 ? 100 ? N (unknown)?] and 2) separation (how large is a group/bin- 2000 bytes ? 4000 bytes ?). - What is the difference between this two types. In dynamic hash files, you let the engine decide how many bins (...

Bobby,

Roy wanted you to try this

IF DSLink59.CHANNEL_TYPE= DS THEN "B" ELSE IF DSLink59.CHANNEL_TYPE=D2D THEN "C" ELSE "X"

-Bibhu

here are a few papers explaining hash files
http://www.fitzlong.com/Technical%20Papers.htm

- Bibhu