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?
Search found 175 matches
- Tue May 04, 2004 10:03 am
- Forum: Infosphere Master Data Management
- Topic: Automated loads and manual maintenance in Razza
- Replies: 4
- Views: 23468
- Wed Apr 28, 2004 1:38 pm
- Forum: Infosphere Master Data Management
- Topic: ETL Challenges [RazzaDS]
- Replies: 0
- Views: 17684
ETL Challenges [RazzaDS]
What are some typical ETL challenges faced during a RazzaDS implementation?
- Mon Mar 15, 2004 12:22 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: CoSort success
- Replies: 4
- Views: 1889
CoSort success
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...
- Mon Mar 15, 2004 8:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How do we capture duplicate records
- Replies: 11
- Views: 5580
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...
- Sun Mar 14, 2004 12:51 pm
- Forum: Infosphere Master Data Management
- Topic: changing the node icon [RazzaDS]
- Replies: 1
- Views: 18661
changing the node icon [RazzaDS]
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...
- Sun Mar 14, 2004 12:04 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How do we capture duplicate records
- Replies: 11
- Views: 5580
- Fri Mar 12, 2004 12:45 pm
- Forum: Infosphere Master Data Management
- Topic: enterprise level strategy versus departtmental [general]
- Replies: 1
- Views: 19125
enterprise level strategy versus departtmental [general]
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?
- Fri Mar 12, 2004 12:38 pm
- Forum: Infosphere Master Data Management
- Topic: prerequisites to a MasterDataManagement strategy [general]
- Replies: 1
- Views: 19652
prerequisites to a MasterDataManagement strategy [general]
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?
- Fri Mar 12, 2004 12:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup Problem
- Replies: 2
- Views: 3270
- Fri Mar 12, 2004 11:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How do we capture duplicate records
- Replies: 11
- Views: 5580
How do we capture duplicate records
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...
- Fri Mar 12, 2004 11:00 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: can ProfileStage/AuditStage analyze EBCDIC data?
- Replies: 3
- Views: 5309
can ProfileStage/AuditStage analyze EBCDIC data?
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?
the results may be unpredictable.'
This implies its not supported, but you could try, so has anyone tried something like this?
- Tue Mar 09, 2004 5:51 pm
- Forum: Infosphere Master Data Management
- Topic: import file sections (clarification on 5th section)[RazzaDS]
- Replies: 1
- Views: 18411
import file sections (clarification on 5th section)[RazzaDS]
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...
- Fri Feb 27, 2004 1:37 pm
- Forum: Infosphere Master Data Management
- Topic: RazzaDS and Date/Time dimensions [Razza]
- Replies: 2
- Views: 19566
RazzaDS and Date/Time dimensions [Razza]
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...
- Wed Feb 11, 2004 8:36 am
- Forum: Data Quality Best Practices
- Topic: AuditStage error: missing QA_MD_COMPLETE table
- Replies: 0
- Views: 2237
AuditStage error: missing QA_MD_COMPLETE table
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...
- Wed Feb 11, 2004 8:29 am
- Forum: Data Quality Best Practices
- Topic: AuditStage error: Error upgrading Domain Table
- Replies: 0
- Views: 2191
AuditStage error: Error upgrading Domain Table
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...