DSXchange

No, you manually have to setup each job activity stage and put the Sequence parameters in as the derivation for all parameters.

Search the forum, this is asked and covered alot.

You want a single row to process in a job, then run the job in its entirety for next row, and so on? Not only is that slow, you are going to find that just running a job that does nothing can take 3-4 seconds. This is because not only does it have startup overhead, wrapup includes purging its log an...

IF NUM(FIELD(INPUT1.RECORD,'|',2)) or ALPHA(FIELD(INPUT1.RECORD,'|',2)) THEN ROW<1> = FIELD(INPUT1.RECORD,'|',2) ROW<2> = "Number or Alphabet" END ELSE ROW<1> = FIELD(INPUT1.RECORD,'|',2) ROW<2> = "Some other character" END CONVERT...

No, the BEFORE/AFTER SQL is meant more for statements such as session variables or stored procedure calls. There is no ability to use it as an extension of the SQL statement.

Your description of the job design is incomprehensible. Could you please restate the design and your requirements?

I didn't use the word KEY because KEY implies uniqueness. If you have duplicates, how could you have duplicate KEY values? I assumed you are using a different column to uniquely identify rows, thus you could have duplicates. Since you have 8 columns that uniquely identify a row, then your exercise i...

You failed to write it to the hash file because of a key definition violation. Or You wrote it to the hash file but your primary key definition allowed another row to overwrite it. Or You read it from a sequential file into the hash, and had First Row is Column Names checked, but the first row is ac...

CHANGE, EREPLACE, CONVERT

How about 2 jobs, one for dupes and the other uniques? Job_Get_Dupes: OCI --> XFM --> SEQ Write SQL like select col_a, col_b, col_c, col_d, col_e, col_f, unique_identifier_column from your_table where unique_identifier_column in (select unique_identifier_column from your_table group by unique_id...

Yep.

All job designs in a project are stored in a single file. You run out of space while writing to that file, and you corrupt it. This means ALL job designs are hosed. There is a chance to partially fix some of the data, but FOR THE MOST PART, it is CATASTROPHIC to run a project out of space while desi...

Okay, so you took your Unix license and used it on a Windoze platform? That enables Parallel as a job type when creating a new job?

Uhhh, seems kind of shady to me. I didn't know that you could use a Unix auth code to activate a Windoze installation.

The distributed hash file has a lot of maintenance overhead, in that you must define partitioning algorithms. A distributed hash file is the same concept as a partitioned table in Oracle. You must include the partition key column when doing any lookup/join to benefit from partition pruning. The poin...

You need to make sure that data is present to a database in the form that it expects. Oracle returns timestamps without any subsecond digits, whereas SQL-Server expects subsecond digits. There are functions in the SDK folder you should look at for manipulating values. You will want to format the Ora...