DSXchange

The Hawk release comes with a new IBM/Ascential product called the Information Server or the Metadata Server, depending on which presentation you go to. This provides metadata services to the Hawk products but also other WebSphere products, it is part of the Master Data Management framework for exam...

Tricky one. I would open this as a case to Ascential. If you could trace the SQL statement being executed you should be able to identify the table and field causing the mismatch and make the field wider on your database.

It was Keith who took the time! I don't mind certain questions being replicated in new threads as you find peoples opinions may change or with new product releases the comparison between the products may change over time and a fresh look can be good. My blog Process in parallel or take up folk danci...

Since most of us know very little about Turbo Image I suggest google searching! There is an article on transforming TurboImage data types to Oracle data types . A vivisimo search of TurboIMAGE ODBC revealed a few sites such as this one from Minisoft that accesses TurboImage databases. Apparently the...

Running out of disk space on your data drives is recoverable, running out of disk space on your software drive is as lethal on a DataStage server as it is on a Windows desktop. Did your server really restart? It is likely you have a port timeout pending. Open up the DataStage Install and Upgrade Gui...

I don't know if it is the same product but there is a DataDirect Developer forum with an ODBC driver topic. There is also a DataDirect Accessing SQL Server from Unix product page with a knowledge base and reference guide.

Well you could read my blogs, there have been two posts comparing server edition to parallel edition. Use the link in my signature.

Have you used the "Insert Parameter Value" button on the job activity stage?

Use a routine stage. Write a routine that receives a job name, a reject link name, a primary link name and a percentage value as input attributes: - Attach the job. - Find the reject and primary links and get the row counts. - Calculate the percentage of rejected rows. - Generate a log message with ...

LK, Go to the Parallel Job Developers Guide, go to the Surrogate Key Stage chapter, look at the first section titled "Key Space" and look at the example diagram showing how keys are allocated across four nodes. It's also a good example of what happens when the partitions are not balanced, Node C has...

Some interesting points made in this thread. There were a few threads on this topic over at www.datawarehouse.com, back when it was popular, and whenever one person stated the advantages of one product over the other someone else was able to dispute each point. As Ray points out they are in almost e...

DataStage has a better splash screen, DataStage is easier to say while you are holding your tongue and DataStage rhymes with MetaStage, ProfileStage and QualityStage. I think you'll find Informatica rhymes with none of those products.

Your current parent volume of 49,000 is very low for a lookup and you are putting undue stress onto the database. I wouldn't consider a sparse lookup until the parent table goes into the millions, or less rows but a large number of fields to return, and the input link has under 100,000 rows.

Use the Batch Job build tool as a short cut to generating your routine code. In the Director choose Tools - Batch - New from the menu. This creates a new batch job. Find your multiple instance job in the combo box and hit the add button, you will get a job parameter prompt and it will add all the co...

In the $PXHOME/bin directory are two scripts called db2setup.sh and db2grant.sh that you need to run to setup access to local DB2 databases. Instructions are in the DataStage Install and Upgrade Guide. For remote DB2 databases you need to follow the instructions in the DB2 configuration guide that I...