DSXchange

Your question about refresh frequency also makes me wonder about implementing slowly changing dimensions in the dimension server.

Thoughts on the best practices approach to the good old friend of data warehouse developers?

What are some typical ETL challenges faced during a RazzaDS implementation?

CoSort's latest newsletter boasts its plugin for DS 7 is 2 to 10 times faster than the sort stage. Of course there is a big different between 2X and 10X. What are the approximate gains that CoSort implementers have had in the past? Also, how easily can it be implemented? It seems pretty simple...

Okay...let's phrase it this way...forget the exact odds. Here is the scenario that counts: You are a consultant ETL developer. You use this method, and with your luck you get a false positive causing an error during your ETL process. You explain to the client the method used and what happened. Would...

In my heirarchy the limbs have a standard folder icon and the leaves has a standard paper sheet icon. What steps are involved in changing these defaults? In the admin tool I've created a new glyph, and then created a new node type with this glyph assigned to it. I got lost from here. I don't quite u...

thanks Ray. that's why I've tended to stay away from checksum in the past, but seeing an actual number for odds should clear any doubt as to the effectiveness of the method

Does a master data management strategy need to done from an enterprise/corporate level to be most effective, or can it be done in a more department mode? Would a departmental mode tend to lead to the same problems that are trying to be avoided?

What are the prerequisites to implementing a master data management strategy? If a recent and formal L0 through L4 data quality assesment hasn't been done, would this initiative be set up to fail or can it still be a successful IT direction regardless of successful data quality management?

I'd followed jreddy's advice and have a transform after the lookup. Also, just to make sure since this is how you typed it into the post, If field.StateCD = "NULL" will look for a string constisting of N,U,L,L. Is the source data has a true null as opposed to the string word "NULL&quo...

typically I use a method like Craig suggests, where I concatenate the columns into one string and use a stage variable to compare. I've never used checksum CRC's much so I'll pose this question to the gang: Is using checksum() another valid way to search for duplicates (especially is the source is t...

I'm assuming PS and AS can't really analyze EBCDIC data. The AuditStage manual says 'If the data file contains non-ASCII data, such as EBCDIC, packed, or null characters,
the results may be unpredictable.'

This implies its not supported, but you could try, so has anyone tried something like this?

I found a discrepancy between the RazzaDS documentation and the product version 4.7. I don't have a clear understanding of what the final section (after Version, Hierarchy, Node, and Relationship) is. The documentation I have refers to the final section as " Property ", says it " cont...

Since RazzaDS is intended to manage large complex dimensions with different hierarchical view across the enterprise such as accounts or product line dimensions, I was curious if there was any worth in trying to also manage a date dimension in a central place, possibly with just the goal of making th...

I am trying to complete a completeness snapshot. I can correctly output to the screen but not to the database. I get an error for each column and noticed the QA_MD_COMPLETE table doesn't exist in the database. Anyone seen this? There appears to be only a few tables for AuditStage and their structure...

When first connecting to a database there is a message box that says "Please standby while AuditStage upgrades the Domain Table found in the data source." This is followed by this error message two times: "Error upgrading Domain Table:". The does source does have a QA_MD_DOMAIN t...