DSXchange

Have you created a new Server job by accident? QualityStage stages can only be added to Parallel jobs, not Server jobs.

You might run into this problem on other jobs. The easiest way to spot it is via the job minotor showing that your job processes 0 rows for a long time. It will report that it ran at 200 rows a second but it was probably 0 rows a second for a long time followed by 1000 rows a second once it got going.

The SCD stage is supposed to drop rows where a dimension row is found but all Type 2 column values are not changed. It could be the change data comparison in the stage is not working properly - this can happen when comparing CHAR to VARCHAR or when a string field has extra special characters that yo...

Try installing one layer at a time - repository followed by domain followed by server. That gives you a much shorter install and rollback and it may reduce the chance of failure. If it failed during install of product license it could be the repository and domain both worked (giving you a working me...

You listed version 8 in your original post, you can do something like this in the Information Server console by generating a Source to Target report but you cannot do it in the Designer. In the Designer you can view dependencies and lineage like table definitions, jobs, routines, job parameters, con...

Ab Initio had the first massively parallel ETL tool, Orchestrate was one of the next to do it and were acquired by Ascential, Informatica grid came later.

Informatica dug themselves into a hole in Australia and several years ago Ascential was beating them comfortably. They cancelled a master reseller agreement and opened an office in Sydney and have recovered. Similar stories from other parts of the world, Informatica international revenue increased d...

One thing your SSIS developers might have done is leveraged a lot of SQL Server stored procedures. SSIS is an ETL tool that is capable of running transformations outside of the SQL Server RDBMS engine but a lot of DTS users are more familiar with stored procedures and do a lot of the transformation ...

The initial 8.0.1 release is mainly made up of ProfileStage functionality - and comes with a free copy of AuditStage. Future release will have AuditStage functions added. In DataStage and QualityStage 8 the table definition form has a new tab called Analytical information - it contains a summary and...

I don't know much about it but the challenge for Informatica is that Ab Initio and DataStage EE were built from the ground up as shared nothing parallel processing engines. It's hard to take a product that is single threaded and build that into it - which is why Ascential stopped trying with Server ...

A quick check of ETL jobs in Australia on Seek today (note some listings are duplicates): DataStage - 119 Informatica - 102 SSIS - 80 OWB + Oracle Warehouse Buider - 37 DecisionStream (Cognos) - 14 Data Integrator (Business Objects) - 9 Ab Initio - 6 (most of them Cognos BI roles) ETI - 1 Genio - 0 ...

Yes, try this link: Download Information Server Version 8.0.1 for Solaris platforms.

I did a blog post What is new for DataStage 8 on the Information Server.

I think we all missed the really big milestone - Ray was a gross of gross at 20736 posts.

I've got DataStage 8 running on my laptop with server, parallel and sequence jobs all running. I've got a DSEngine directory with all the UV files in it and all the server job Universe stuff like BASIC routines and hash files are fully supported. I would recommend exporting your DataStage projects, ...