DSXchange

No, it does not load 'all data at once'. Again, it can only load the data as fast as you can provide it. Your 'bottleneck' more than likely isn't the load, but the processing you are doing first. Verify this by breaking the job into two discrete jobs. First, CFF to flat file, doing everything you ar...

Technically, it doesn't 'invoke sqlldr' as in the command line function but instead hooks directly into the database via an API. This also means it does not generate the 'bad' or 'ctl' or 'dsc' logs you would normally be interested in.

Ok... Can you restate your problem, please? What does or doesn't happen or what is it that you are trying to accomplish that isn't quite working out.

In other words - it's not the constraints. Seek your solution elsewhere. You've already gotten a couple of good suggestions, let us know if you need any help with them.

Is this something you can read in as a Varchar or LongVarchar and then parse afterwards with one of the XML stages?

Ok... then have you taken this issue to your DBA?

You use the Exception Handler if you want to control what happens when there is an 'abort'. Without it, DataStage decides what happens. Are you on a fairly recent version, say 7.5.x? If so, then your question re: a 'better way' is to use the 'Automatically handle activities that fail' option in the ...

We'd need more details to give any meaningful advice. How about as complete of a description of your job as you can manage? That should get us started.

How will you recognize these 'first 12 months' of data? What is the business rule you are attempting to implement? The answer to that question will help determine the appropriate place to do the dirty deed. ps. Unless your constraints are horribly complex, I don't see how they could be your 'taking...

chulett, Do you mean that pre CASTed sql in oracle stage will not be recognised by the job? No. I just mean it won't know you've done that in the sql. It will still use the metadata to drive the warnings you are seeing. If i have a field defined as NUMBER (no precision,no scale) in oracle database,...

Welcome. Here is something a quick Google turned up: m Have you discussed this with your DBA? First thing to check seems to be to see if the listener is up. Can you connect to this instance from anywhere else? Are you sure you changed the password in your job, not just in 'all ODBC related files'?

What makes you think you have to use the filter command to achieve this? That sounds more like a job for a Transformer constraint. How will you recognize these 'first 12 months' of data? What is the business rule you are attempting to implement? The answer to that question will help determine the ap...

From the Director's Log View, there should be a View entry on the toolbar, and a Filter option under it. From what I recall. It should be fairly obvious but you must be viewing the log for it to show up, or at least that's how I'm remembering it right now.

And that 'sensible relationship' would typically be this: Transaction Size should be an even multiple of Array Size.

1) You can use the NOTFOUND variable for anything you like. I'm just passing along my own personal observance that while I know it works fine for Hashed File stages, I found it unreliable for DBMS work. Your mileage may vary. 2) Not sure what you mean. Yes, that functionality is built into the engin...