DSXchange

Ok. From what I understand of your needs here's what I would do in your shoes, Kris, other than walk funny that is. Create a job that just truncates your table and does nothing more. This is perfectly valid and something I've done many times before. All you need is a transformer and a database stage...

Kris - just how 'occassional' is this occassional need to occassionally truncate the table in question? If it is truly occassional, why go through all this who-ha and why not just occassionaly truncate the table... manually?

With 7.5.x and the new Sequence job capabilities, you must abort your jobs in order for Checkpoint Restarting to work properly. Must. If your jobs are not dependant on each other and you want them all to run regardless of the outcome of any one job, then you don't need any fancy stuff - not even Fai...

There isn't a dedicated forum here for that. You've already done the right thing it looks like, post to the 'Server' forum and mark your job as a '390' job.

Please try searching the forum. I just did an 'exact match' search for Type 2 SCD and got 20 hits. There's alot of information buried here, please spend a little bit of time trying to dig it up. Then come back with specific questions. As to learning, there is a tutorial that ships with the product t...

If your requirement is it read XML files and load them into Oracle, then your job would look more like: Folder --> XML Input --> OCI (or ODBC) With maybe a transformer between the XML and OCI/ODBC stages. As a general rule of thumb, you should parameterize anything in these stages that could change ...

Yes, because the Wait For File stage has to 'fail' when it doesn't find a file it can trigger the Exception Handler. A couple of things you can do about that - 1) Try using either an 'Unconditional' trigger instead of a Failed one or two triggers, an Ok and an Otherwise so that it thinks you are han...

Not to be confused with FOD.

This seems to be pretty much a 'no brainer'... I mean, how could they afford to do something like that?

Good. I looked when you first posted this but couldn't find any on my server, so waited for others to chime in.

Worked fine for me...

Use the Wait For File stage set to look for a non-existant file and then to give up after your desired 'sleep' time.

Sometimes the key is doing an Exact Match search. Doing one of those for -14 got me 115 results.

First, make sure you are changing the 'Rows per transaction' setting on the 'Transaction Handling' tab and not the 'Transaction size' setting on the General tab - that's ignored. Second, chat with your DBA about how they have the UNDO setup. It's not just about commit frequency, there are other fact...

I get the following lines on UNIX ../Projects/$PROJECT/Staging Not Found DoNothing.ksh dsjob not found Before run Job_Status = dsjob -run - mode RESET -wait PolSubD3 DoNothing DoNothing.ksh dsjob not found You need to remove the line that cd's to staging - it is specific to Kim's scipt and not need...

Some can be executed before/after SQL using 'call' but some will insist on being 'executed' in an anonymous block, which can't be done there. If you have 7.5.x then you have the Stored Procedure stage which would be the prefered methodology. It does allow you to wrap it in an anonymous block and (mo...