DSXchange

For SCD II, some of the lookups require the date range criteria. This is not accomodated in hashed file and the performance was terrible when I attempted it with the UV Stage. Sounds like you missed the need to create an index over the key fields so that the UV lookup isn't dog slow. Search the for...

George has a big 'ol thread on that very topic over in the Server forum. Right now he's got bigger fish to fry as DataStage won't start for him.

You bulk load the updates into a work table and issue a MERGE. For Oracle, anywho.

Nope - if you read the pdf documentation on the stage, you'll note all the various clients that must be loaded and configured to use the stage for them. For example, to select 'Oracle' you must have the Oracle client software and sqlnet 'configured' in the same manner as OCI requires. No mention of ...

Actually, the DRS stage set to 'Oracle' does use the native OCI interface under the covers from what I recall. Totally agree . But still, doesn't the DRS stage have a similar overhead like the ODBC stage as compared to the native OCI interface? I was promoting the OCI stage as opposed to DRS in ord...

Or farm it from the log.

Find any post by Kim Duke (user name 'kduke') and check his sig block for his website address. Go there and download the 'XML Best Practices' document he is hosting there for us. More than likely, you'll be storing the 'chunks' and then 'joining' them together in the final xml creation step via some...

Ok... out of curiousity, how exactly is this message sent back to Tivoli?

Yah... kind of figured it wouldn't be all that different from other database products where scratch/temp space can get blown out by large queries.

Actually, the DRS stage set to 'Oracle' does use the native OCI interface under the covers from what I recall.

Actually, you can - it's just not a recommended practice. It will stay red but will work as long as they are in the correct order, top to bottom. Best to use two transformers as noted, IMHO.

What is the actual datatype in the Oracle table - DATE or some flavor of TIMESTAMP?

Yikes... you probably walk under ladders, too.

Run out of temp space, perhaps?

We are confused as well. Seems like you'll want to resolve the inability to connect first, then we can worry about the Oracle problem. Kinda hard to import much of anything if you can't even connect to the Server. First, do an Exact search for 'internal error 39202' and see if any of the solutions t...