DSXchange

What function(s) are you using to change string to timestamp and for null handling?

Sorry buddy. You cannot parametrize column names. No method that I know of. You will have to explicity define column names and keys.

Unload your dimension tables (surrogate key and natural key(s) only) in seperate hashed files. Do a lookup against these hashed files instead of going directly against the database. You should see a boost in performance.

The poor select performance might be due to 'back pressure' from your target database stage. If you replace your target with a dataset, you will see that the select will increase exponentially.

Welcome Aboard
In a parallel job, I highly doubt it. But in server job CRC() function can be used for this purpose.

Welcome Aboard
You need to read each record as a single column and depending upon the range, duplicate them. You need to write your own routine to do this. Roy has a great FAQ entry on how to generate rows with a single row. Check here.

StringToDate() is a parallel job function and not a server job function. Use ICONV/OCONV to get your desired result. If your date is already in YY-MM-DD format and that is what you require then leave it as it is. Server jobs are not fussy about datatypes. You can directly map a varchar to a date fie...

Do a Search on all terms on keyworlds "The section leader on died".

So what solved your problem? Did you seperate the update and insert streams or just dropped the indices and recreated them after the load?

I believe the following should work. Test it out before you stick to it.

No. Dont change anything. It actually is cat `/.dshome`. That was a typo on my end. Anywho, I dont see ORACLE_HOME set in your dsenv file. cat `/.dshome` is not for oracle home.

Great. You can mark the post as "Resolved" then.

You can pass your stream through either a modify stage and use handle_null() or use IsNull() in transformer.

Not possible. If this is for debugging then cut and paste the "half" of the job in a new job or make a copy of your present job and delete the half you dont want to execute.
NOTE: This is where modular jobs really shine.

Learn about multiple instance jobs in server developer guide. Job Invocations are used in multiple instance jobs.