DSXchange

I don't like this design as the sparse lookup is a very expensive overhead on your job. You've got to ask what advantage you are getting from using a DB2 sequence when you have to retrieve it for every row. I think you would be better off generating keys within your job using a parallel counter, ret...

Have a look at the test objectives on the IBM website as it has a list of topics to be covered in the exam. Tick off each subject as you study it. The existing EE courses will be useful but there is still likely to be something you need to study that wasn't covered in the course. As to a certificati...

Someone pointed out to me in a private message that you can install components on different machines, so a metadata server on one machine and the DataStage server on another. Only the DataStage server would require the multiple CPUs.

From the Beta 1.0 installation guide the metadata server requires 2GB for RAM and 4GB of disk space plus it requires a WebSphere Application Server version 6.0.2 (which is bundled with the beta software). The repository requires DB2 version 8.2 (also bundled). The DataStage Server requires 2GB of RA...

The sin bin is a bit too unfriendly for a social site and it could result in duplicate posts if the original is locked out. Posting to the wrong forum isn't the end of the world, if you want to make maintenance easier give Move Thread rights to everyone with over 200 posts. They should be able to ju...

Probably better to name it as a TSV file! Or a txt file. Calling it CSV is a bit misleading since it isn't comma seperated. Import the file definition through the DataStage Manager and you will see tab delimited as one of the seperator options. This will also bring in the field names. Drag and drop ...

I really like those policies, the show a good knowledge of the strengths of an ETL tool and metadata lineage and reporting. We had a very good example today of the ETL v SQL debate. We have a fact summary table built from a fact detail table. It could be written as a fairly simple insert into SQL st...

Welcome to the metadata forum, a bit of a shaky start, you did spell MetaStage wrong in the title but you came good in the post. Just to add to the excellent answers so far, being a metadata hub it sucks metadata in and that metadata is largely readonly. You can enrich your metadata knowledge throug...

I would expect that a DB2 client on Solaris would be able to connect to a DB2 server on AIX, and therefore the EE stage could use that client connection. Have you got a copy of the DB2 Remote Configuration Guide? I noticed someone uploaded the latest version to developernet just a week or two ago.

There are some parallel warning messages that are either unavoidable or only avoidable by making the job less efficient with a workaround. The same is not true of server jobs, server jobs get far less warnings and a well designed server job shouldn't get any warnings at all. It is one of the pleasur...

Don't forget Linux! :D Parallel jobs run fine on Linux too.

There is a FAQ on how to make jobs readonly, I would look to see if the Administrator locked project option is on first and then move to the other readonly job methods.

The QualityStage plugin for DataStage has address parsing, identification and barcoding for locating mailing addresses. I think there is also some geolocation functionality, not sure on this as it doesn't seem to appear anywhere on the web site.

Well I hate to self-promote (not) but there are some blog entries for new users such as DataStage tip for beginners: developer short cuts and Incremental Loads save the day or DataStage tip for beginners - avoiding Stage Amnesia.

The Oracle OCI stage and the Dynamic RDBMS stage should use exactly the same connectivity to access the Oracle database so they should give the same performance. The main difference is the Oracle one may have an extra couple of Oracle settings. Have a look at each one to see which you prefer. The dy...