DSXchange

It is a trick question. An incremental load is based on only selecting records in the source which have changed. You can do that without keys. All you need is last updated field in the source.

What to update in the target may require keys.

Wow, Ray asked a question. Where is Ernie when you need him?

We do 2 with emails from Autosys. It works very well. We use something like Autosys but not exactly the same.

Wow, Ray. Give Craig a little credit once in a while. Besides I would be more impressed if you thought it and he wrote it.

If you do not want to land the data unencrypted then you create your own stage type and pipe the data through the command to decrypt then transform it and pipe it back through the encryption process before outputing it.

Is your encryption PGP or GPG?

The job DSJobReportDbDriver is the one job to start with. It runs a job called DSJobReportDb which runs dsjob -report XML as a before job routine for whatever job you feed into it as a parameter. Take out the code to run the job DSJobReportDb and just execute a shell to run dsjob without the XML opt...

I agree with Nick but you need to identify the format first. Write something which figures out what the format is then transform that format into your base.

I would make those fields char() and format it YYYYMMDD HH:MM should work fine. I would think it would speed up your performance too.

I would think the index needs to be on the key and not the columns. Your between clause would need to change to be on the key.

You have developers in 2 different default groups. You need to change everyones default group to be dstage or learn how to make multiple groups work while using DataStage.

You need write access.

Ken Bland has a utility which will fix the auto purge settings for all jobs on his web site.

There used to be a utility on ADN which would do a CLEAR.FILE RT_LOGnnn for every job. This is not recommended but does work. Not sure who has this now. Would be easy to rewrite.

I bet it does not work.

Hope you get the job.

EtlStats will generate all jobs, all jobs in a sequence. Take that code and modify it to meet your needs.

The job log will tell you which sequence started it.