DSXchange

This article does a good job of explaining the difference between data cleansing and data quality.

http://www.computerworld.com/databaseto ... 30,00.html

The term "business rule" gets bandied about quite a bit in data quality circles. In most of the data cleansing world, a business rule is a pattern that a particular data item must match. In the data profiling world, a business rule entails a pattern, a set of relationships, or a range of a...

I agree on the need for a staging area. Going directly from source to target isn't what it looks like in theory. I disagree about the function call overhead using the parallel extender. You've got a truly multi-threaded solution with parallel extender. The limiting factor is how fast the data stream...

That's interesting that you took that approach. We took a different approach with MetaPure ( http://www.metagenix.com/products ) and allowed the ETL tool to call us at the transaction level and maintain the advantages of multi-threaded execution. The key element in this strategy was to make the busi...

Data quality does not figure very high on their radar .The reason for this being the assumption " once our DW is in place , data quality will be very high". It is never realized that source data can be unclean irrespective of any system. Most companies dont realize that 60% of DW effort i...

Back in June, Metagenix conducted a survey of database professionals and asked them how they were treating the issue of data quality. We were quite surprised to note that very few businesses had a formal data quality program. So what steps are you taking on data quality? Does your company have a for...

I'd like to thank DataStageXchange for the opportunity to moderate this forum, and welcome everyone. We're going to be discussing all things data quality. People used to think of data quality as just name and address cleansing, but now most people realize that it's much more. I've created a list of ...