DSXchange

I agree, that's a perfectly valid solution.

While Ray goes into internal specifics, it is also documented in Chapter 6 of the Parallel Job Developer's Guide. Search for "Aggregator stage: Options category: Method".

"Too new" I would imagine so there hasn't been time to fully certify it yet. Nothing gets supported "by default"...

Other than the one you just quoted?

Emphasis on the word buy - there's no free version, I'm afraid.

Or Re-Open Topic and away we'll go...

both tables are in huge volume so my understanding is ETL will be more efficient Generally that would not be true. Suggest you leave the Join stage for when you absolutely need it, i.e. for disparate sources. Now, if the source database is under-powered or over-utilitized and you are just making ma...

Are those two tables in the same database by chance? Wondering if you really need to be doing the join "in job" and can't tell from what you've posted so far...

It's not about how long it takes to "load" but rather how long before the first record gets to the target. I'd look into optimizing your source SQL as much as possible.

Why start by not post your "structure error"? That an confirm that you have accurately posted the sample XML in question.

In my experience, you can use a lower version Oracle client to connect to a higher version Oracle instance without issue. However, the reverse could be problematical.

No problem... and it gives me a chance to get it in the proper forum.

It could be the complete message, the Connector errors can be a little... sparse. However, it does say 'row not updated' rather than 'cannot be done' so it should just mean your key values are not matching up like you think they should be. Then as you've noted, the updat is considered to have 'faile...

Thanks... but I meant the entire "update cannot be done" error message.

I had created xls file using Sequential file stage with the extention of xls but it is not creating in binary format. Sorry, but... of course not. The extension of a file in UNIX doesn't have the significance that it does in Windows world so all you got was a flat file with ".xls" at the ...