DSXchange

It also depends on NLS_LENGTH_SEMANTICS - could be set to BYTE or CHAR . If it is set to CHAR then Oracle create a column defined as VARCHAR2(1 CHAR) or VARCHAR2(1) (which is then the same) by default as VARCHAR2(3 BYTE) . When you create a column longer than 1333 CHARs then you could get problems w...

ok - thank you. it was no kidding.
Next time I will read the documentation
more carefully. But it is good to know that it describe more that just the package we bought.

I use DataStage for about half a year. But now I really like to ask whether there is really no join stage in this tool. i found the description into the online help but cannot find the symbol to use in my jobs. I like to make a join or lookup with something similar to a "between in SQL". I...

I like to make a lookup to hashfile with a similar mechanism as
the between clause in the where as it exists in Oracle?

Is it possible in Data Stage 5.2?

Or do I need do write a function in DS-Basic?

Is there any way outside DataStage to calculate the CRC32-Checksum
provided by Ascential to have the same result or can I use any CRC to get the same code?

I already coded a Java CRC32 and loaded to Oracle - but didn't the it
against the output of Ascential!

thx

Well, DataStage Server jobs are single-threaded. This means that the SELECT query is prepared however the database does it, then a process spools the data to DataStage, which is handled in a single-threaded fashion. DS spools the data to a file, then initiates a sqlldr session to load it. Compare t...

The Datastage runs on the same server as the destination database.
sure There is one more step that DataStage does, but do you guess there
is a better way than make the INSERT SELECT?

I archieve a poor performance into a job that reads data from a distributed Oracle Database (Source and Destination are 9i). Now an ORAOCI8-Stage selects the data (restricted by a timerange). Then a bulk Loader Stage loads the data - which is not the bottle neck. For 1.000.000 rows it takes 30 Minut...