DSXchange

Thanks Roy, yes it could have been one long poll but I thought that would involve too much reading. Thanks to those who voted, almost 50 participants. Only 50 more and I have a Family Fued question! I have drafted the article but will keep checking the polls to see if more votes come in. Please, if ...

Thankyou to those people who answered my certification poll questions last week, you have shed some light on reasons for taking/not taking certification. For those who missed it please vote at one of the two certification poll threads to help me with a certification article I am writing for DB2 Maga...

You may hit the same metadata hurdles, both products come with a seperate metadata reporting or management tool that has its own set of training, installation and administration requirements. Most DataStage Enterprise implementations that ignored or dropped MetaStage could not supply the resources t...

There is a picture of a type 2 SCD job in my db2magazine article comparing it to a job that uses the Hawk SCD stage. Shows one possible design. Includes a surrogate key retrieval.
http://www.db2magazine.com/story/showAr ... =186500841

Somewhere between $200 and $300 depending on your country and exchange rate. In Australia about $256.

IBM partners can join a program where they get a full refund for most certification exams that they pass. I qualified for this refund.

Why do you plan to take the certification test this year? Pick your main reason. Pick your most important reason, even if several are true. Use the other poll if you do NOT plan on taking the test this year. The results of this poll will appear in my article in the next issue of the DB2 Magazine. Th...

Please pick a reason why you will not be taking the DataStage certification exam this year. Use the other poll if you are planning on taking the test this year. Also respond if you have another reason or any thoughts on the question. The results of this poll will appear in my article in the next iss...

You've got to assume that if a record is rejected that reprocessing it will have the same result, since the data has not been changed. If you are changing data then you are manually altering it to differ to what is in source systems which is a dangerous path to take. Have a look at my data quality f...

Yes, our company has several estimation models for ETL and DataStage work that we use on project work. You can contact BearingPoint in your country or contact me via a private message. Since IT is highly competitive I don't know of any freely available estimation tools.

I thought the difference stage was being phased out and replaced by the change capture stage. If you can identify a small set of key fields the change capture stage should have good performance, especially as it is running on parallel architecture. Most other methods will require a lot of field matc...

I don't think there is any point learning an older version of DataStage since going forward most of the new projects (who are constantly looking for staff) will be on the latest version. Most new large projects are in parallel, most existing sites are on server edition. I think we will have to wait ...

The primary function of the EDM appears to be tracking changes to data over time, for the purposes of auditing and rollback. Whether you stage raw data or transformed data isn't a big deal. The process of staging can be beneficial for auditing, rollback and troubleshooting.

The EDM is in the staging area, which means data is moved from the old database into a staging area and then into the target. The staging database lets you keep data is close to raw form. It lets you track changes to the raw data over time. It lets you profile the state of that data. It is a good de...

Have a look at my blog on the data quality firewall within a DataStage job. This lets you capture bad records as you process the raw data and deliver it to your datasets. If you want to identify bad records within the source databases you will need some type of profiling tool such as ProfileStage.

DataStage Hawk has completed beta 1 and is moving into beta 2. Read about it at Ground Control to Beta One, You've Really Made the Grade.