DSXchange

Where can I find documentation to help me determine the different data types size allocations in a Has file. For example I have a hash file with the following row structure: field1 decimal 10 field 2 varchar 2 field 3 numeric 4 I need to find a document that will help me determine how much space eac...

Thnaks for the replies!

I've tested using the unox sort command and it works well.

Is there a Unix command/utility to help derive distinct rows from a sequential text file?

I'm experienced with PX jobs but I'm new to server jobs.

Is there a sort function within server jobs? Or is it better (faster) to sort the data externally from the DS job?

tks

eostic wrote: Imagine a job that does a lookup near the source, and if that lookup fails, a flag is set, and then 10 stages later, towards the end of the job, a row is inserted into the original lookup table.
Ernie

Using the job design you describe , would that not occur in a PX job stream due to pipelining?

Is there a benefit to running multi instance jobs processing dynamically partitioned data without IPC enabled versus running a single job with IPC enabled and using link partioning?

This scenario is similar to a current project I am workign on.

Will using link partioning obtain the same, worse or better results than a separate job instance?

What is the benefit of one method over the other?

tks

So with 8 dual node cpus, there are 16 processes available?

Will the server dynamically adjust the number of processes when the second job is submitted or will test1 keep all the processes until it is finished?

We have an 8 node, dual core server. Assuming: a) no other jobs are running c) we have a simple passive-active-passive stage structure in our test job d) IPC is enabled How many processes will be started for the test job? Assuming the first test job is running, if a second test job (test2) with the ...

We have had success with similar situations doing the following: 1. read the sequential file using a single column string format. 2. in a transformer stage test the control character and route the records to a a distnct path that processes that record type. Use a Column Import stage that will parse ...

Multiload uses some work tables. When we run Multiload in parallel mode then each process will try to create a set of work tables with same names that leads to job abort.To fix this we have to run Mload only in sequential mode. Multiload is itself fast efficient loading process.It doesnot need addi...