DSXchange

It depends... If your hash file needs a lot of records (100.000's) and needs a full refresh every run while you only need a couple of 100 rows an OCI lookup on the original data will be much faster than using a hash file. If you only have a couple of 100 rows in your hash file, it would beat an OCI ...

satish_valavala wrote:Hi,
If we change uvodbc.config and .odbc.ini in DS Home directory,
do we need to restart DataStage Server?

No

Ogmios

Are you sure your input data is correct. What usually happens is that e.g. you pick a ',' as seperator and some input field internally also contains a ','. This will lead DataStage to see more columns than actually were intended.

Ogmios

Does not work, can not work... DataStage starts up its jobs as seperate processes (with even subprocesses) with seperate database connections so you can never get 1 big transaction for all jobs in a sequencer.

Ogmios

Is Data Integration project same as Data Warehousing project. The wrong forum, but to answer you question... it could be or it could be not... depending on the person who issued the statement of Data Integration project... clarify with him/her. Data Integration can be used e.g. in the context of En...

This is a "known" problem with DB2... besides forcing off all users accessing the table (and hoping they don't restart their query) not much can be done about it. What we do in some places is to start early (window for ETL) and send an automatic e-mail after the ETL finishes for every proj...

How about:
in Sybase... the biggest disadvantage of calculating the maximum in DataStage is that you have the I/O from Sybase to DataStage (where depending on your input a lot of data is not useful).

Ogmios

If you register the driver of the client database software in "branded_odbc" it also seems to work. You don't use the Merant driver, only the driver delivered with the database client software.

Ogmios

Not much experience with AIX... on a solaris/HP-UX box my first guess would be to check the /etc/services file... If you install as non-root chances are very small you will be able to change that file, and the change in there is really required. By the way, I would not recommend non-root installatio...

There's also the thing about OS restrictions... most of them are now either 4Gb or 4 TerraByte: to be able to keep track where you are in a file you a need to be able to address the offset (and this is usually OS dependent).

Ogmios

There's also an option with the installation that allows you to chose which mode to use... you can also change it afterwards in uvconfig (but better probably at installation).

Ogmios

Not directly in DataStage, but since it's flexible you can find ways around it: store values in files, databases, hash files, ...

Ogmios

Are you talking Dual core or Hyper-threading? Dual core, but I'd rather have 2 single core cpu's, then 1 dual core. Performance wise they're not the same. Anyway Ascential sales just ask for the number of cpu's, and don't ask these "technical" questions as dual-core, single-core, hyper-th...

Personally I think the counting of 1 dual core cpu as 2 single core cpus by DataStage is kind of a rip off. If you look at optimal performance (read benchmarks) you will see that 1 dual-core (for Sun e.g.) has the performance of about 1.5 single core cpu's.

Ogmios

Oh, it works all right - it just that every job finishes with at least one warning. In other words, no job ever gets a plain old 'Finished' status. Or are you saying that it works differently under 7.5? In the version I have no warnings. But my hunch is that it's because of the dual core cpu's: the...