Les Barbusinski
Les Barbusinski is vice president of technology and co-founder of Digital Symmetry, LLC, a consulting firm that specializes in the design and development of data warehousing and business intelligence solutions. He has more than 20 years of experience in data warehouse and operational systems development and provides hands-on expertise in data warehouse design, development and project management. Les can be reached at dwexpert@dsym.com.
Recent Stories From this Author
What are some of the factors that influence an organization's satisfaction with its data warehouse?
October 7, 2005
What activities and skill sets distinguish and differentiate a data warehouse DBA from a traditional Oracle production DBA?
October 7, 2005
Should the DW use current day as the effective date?
October 7, 2005
What is the relationship between the data warehouse and its portal?
September 7, 2005
Could you please let me know the advantages of ETL tools versus traditional programming?
September 7, 2005
Is real-time integration or staging generally a better approach for enterprise-class software?
September 7, 2005
We're having trouble deciding just who does what and when they do it in the development life cycle.
September 7, 2005
Is any security policy relevant to business intelligence or data warehousing?
August 4, 2005
Is it wrong to build a billing application off the ODS?
August 4, 2005
What is a junk dimension and could you provide an example?
May 2, 2005
Could anyone please highlight the pros and cons of using products where you have to create such data clouds, compared to constructing OLAP cubes?
April 3, 2005 I am currently engaged in a BI (BSC) project. I have reviewed a couple of BI (BSC) tools and have come across several products...
We are building a data warehouse with many source systems that provide data feeds.
February 4, 2005 We are building a data warehouse with many source systems that provide data feeds. In order to reduce the volume of data, we...
Can you point me in the direction of any white papers comparing the pros and cons of selecting a BI tool?
February 4, 2005 Can you point me in the direction of any white papers comparing the pros and cons of selecting a BI tool? I'm looking...
I have been asked to do a performance test of the ETL process of a data warehouse.
January 3, 2005 I have been asked to do a performance test of the ETL
process of a data warehouse. The
testing needs to be done in...
How do we map all the OLTP schema to OLAP to answer queries about historical information in the data warehouse?
November 1, 2004 We have database which stores our enterprise data and we
need to keep track of the history of the information relevant to...
Can you point me to a white paper or case study where adding an ETL layer to the ODS enabled speedier nightly data quality?
November 1, 2004 Can you point me to a white paper or case study where
adding an ETL layer to an ODS (containing retail store POS data) has...
We are extracting data from a legacy system that has summary data in it that we will need in the DW, should we re-derive these counts as functions of ETL to ensure accuracy?
November 1, 2004 We are extracting data from a legacy system that has summary data in it that we will need in the DW, assuming that the legacy...
Would you interview top executives separately or as a group for the collection of business requirements via interviews?
October 14, 2004 Would you interview top executives (CEO, COO, CFO), vice presidents and directors of functional areas separately or as a group...
When planning for an enterprise data warehouse what types of investment should be planned for in the way of technology infrastructure?
October 14, 2004 When planning for an enterprise data warehouse, what types of investment should be planned for in the way of technology...
We have a data consolidation system which takes transactions from multiple systems and consolidate and enriches it with contextual information and publishes the same to the downstream consumer systems.
September 8, 2004 We have a data consolidation system which takes transactions from multiple systems and consolidate and enriches it with...
We about to establish a new IT section, using Oracle9i with a UNIX operating system.
September 8, 2004 We about to establish a new IT section, using Oracle9i with a UNIX operating system. Do you think it is better to purchase two...
We are in the planning stages of implementing a managed data warehouse.
September 8, 2004 We are in the planning stages of implementing a managed data warehouse. The current solution is an Oracle database which feeds...
We are beginning a clean-sheet-of-paper architectural strategy for our overall reporting and BI needs.
August 13, 2004 We are beginning a clean-sheet-of-paper architectural strategy for our
overall reporting and BI needs. Part of this effort...
The new trend has been demanding real-time data from the data warehouse.
July 8, 2004 The new trend has been demanding real-time data
from the data warehouse: 1) to generate operational report at high...
We are currently evaluating several BI solution options and realized that there are solutions that manage by data kept in data warehouses and those that manage by data kept in analysis cubes.
July 8, 2004 We are currently evaluating several BI solution options and realized that there are solutions that manage by data kept in data...
Our situation is that we need to build a system having: stage (loaded daily)-->ODS (loaded monthly)--> DW (loaded monthly).
July 8, 2004 Our situation is that we need to build a system having: stage (loaded daily)-->ODS (loaded monthly)--> DW (loaded...
Have you ever seen UML Use Cases used as a mechanism of modeling a data warehouse functionality? Currently the DW is modeled using dimensional modeling techniques.
June 10, 2004 Have you ever seen UML Use Cases used as a mechanism of modeling a data
warehouse functionality? Currently the DW is modeled...
Any time I get to a data related project I have a choice of ETL tool vs.homegrown solution.
June 10, 2004 Any time I get to a data related project I have a choice of ETL tool vs.
homegrown solution. Over the years I have created...
In a purely dimensional modeling effort we have a need to obtain data from multiple fact tables to complete the report as the clients need it.
June 10, 2004 In a purely dimensional modeling effort we have a need to obtain data from
multiple fact tables to complete the report as...
It's always scary to trot out one's core beliefs in front of the pros, but I need to hear your constructive criticism.
June 10, 2004 It's always scary to trot out one's core beliefs in front of the pros, but
I need to hear your constructive criticism. The...
What factors should an organization consider when determining how often to "refresh" (update) its data warehouse?
May 7, 2004 What factors should an organization consider when determining how often to "refresh" (update) its data warehouse? Is it...
In designing a star schema for grocery, we have promotion dimension.
May 7, 2004 In designing a star schema for grocery, we have promotion dimension. Should we have the promotion key as part of the
primary...
I've recently hired on to administer and manage a previously designed data warehouse.
May 7, 2004 I've recently hired on to administer and manage
a previously designed data warehouse. To my surprise, the active physical...
In data modeling, what is the preference on discriminator in the generalization process?
May 7, 2004 In data modeling, what is the preference on discriminator in the generalization process? Is it necessary
to have a "type"...
Can you tell me how to distinguish reporting that is done from an OLTP system vs. reporting that is done from an ODS?
May 7, 2004 Can you tell me how to distinguish reporting that is done from an OLTP system vs. reporting that is done from an ODS?
We...
I have a question on best practices to be used in designing a data warehouse.
April 27, 2004 I have a question on best practices to be used
in designing a data warehouse. Assuming the data warehouse requires both
an...
I have come across two approaches/practices in building data warehouses.
April 27, 2004 I have come across two approaches/practices in
building data warehouses. One is constructing a data warehouse at the...
We can have a staging area between extract and transform or we can have staging area between transform and load.
March 4, 2004 We can have a staging area between extract and
transform or we can have staging area between transform and
load. I would...
How do you handle the dimension key in a fact table when a row in the fact table does not relate to one of the dimension tables?
March 4, 2004 How do you handle the dimension key in a fact table when a row in the fact table does not relate to one of the dimension...
Can we group star schema database, ROLAP, client MOLAP and server MOLAP into OLAP strategies?
February 4, 2004 Can we group star schema database, ROLAP, client MOLAP and
server MOLAP into OLAP strategies? Are there any new OLAP...
I am working with a client that is currently enforcing a standard that does not allow direct query access to data mart dimensions and fact tables.
February 4, 2004 I am working with a client that is currently enforcing a
standard that does not allow direct query access to data mart...
I am a DBA, new to data warehouse concepts and would appreciate if you could reply to my questions concerning issues of architecture as I prepare to implement a one terabyte warehouse.
February 4, 2004 I am a DBA, new to data warehouse concepts and would appreciate
if you could reply to my questions concerning issues of...
We have six offices worldwide where Clarify is being used.
January 8, 2004 We have six
offices worldwide where Clarify is being used. Each has a
separate Clarify
implementation and the databases...
What tools support data warehouse-specific modeling techniques?
January 8, 2004 What tools
support data warehouse-specific modeling techniques? When
considering a
data modeling tool for a...
What is the third normal form of bookSBN, bookTitle, FirstAuthor, Publisher, PubStreet, PupCity, PubContact,Pages, Price?
January 8, 2004 What is the third normal form of bookSBN, bookTitle,
FirstAuthor, Publisher, PubStreet, PupCity, PubContact,Pages,
Price?
We are in the process of evaluating several EBIS (enterprise business intelligence solutions).
January 8, 2004 We are in the process of evaluating several EBIS (enterprise
business intelligence solutions). We have limited IT resources...
Is there any established procedure to calculate the size of a multidimensional database before actually building it?
January 8, 2004 Is there any established procedure to calculate the size of a
multidimensional database before actually building it?
I am looking for a time dimension table structure.
January 8, 2004 I am looking for a time dimension table structure. I have a date
dimension and all I am looking for is standard time...
When should I use a bitmappped index?
December 9, 2003 When should I use a bitmappped index?
What are the major risk factors in a data warehouse project implementation?
December 9, 2003 What are the major risk factors in a data warehouse
project implementation? Do you have any case studies for these
risk...
What are the responsibilities of a data warehouse project manager?
December 9, 2003 What are the responsibilities of a data warehouse
project manager?
Should I use a work breakdown structure in a data warehouse project?
December 9, 2003 Should I use a work breakdown structure in a data
warehouse project?
Is there any methodology to design and implement a data warehouse?
November 5, 2003 Is there any methodology to design and implement a data
warehouse?
I have a data modeling question regarding patient diagnosis and hospital procedures that I can’t get to work.
November 5, 2003 I have a data modeling question regarding patient diagnosis and
hospital procedures that I can’t get to work. Each patient...
Is a data mart defined by its size or is it defined by the specific business process it supports?
October 9, 2003 Is a data mart defined by its size or is it defined by the
specific business process it supports?
My question is in the realm of operational reporting.
October 9, 2003 My
question is in the realm of operational reporting. My client (a
state
government) does not want the expenses of an...
When evaluating BI products, have you come across a product called Intelli-Mine?
October 9, 2003 When evaluating BI products, have you come across a
product called Intelli-Mine? What do you know about Intelli-
Mine?...
I am newly involved in the BI/BPM space.
August 22, 2003 I am newly involved in the BI/BPM space. One of the
things we are experiencing with our solution is that our
client's...
Have companies that have implemented data warehouses, particularly financial institutions, established a special data warehouse organization?
August 22, 2003 Have companies that have implemented data warehouses,
particularly financial institutions, established a special data...
We are currently looking for a best-in-class, pure Web-based BI tool for reporting, ad hoc and analysis needs.
August 22, 2003 We are currently looking for a best-in-class, pure
Web-based BI tool for reporting, ad hoc and analysis needs. Any...
I'm a JAVA developer involved in developing a data warehouse project.
August 22, 2003 I'm a JAVA developer involved in developing a data
warehouse project. What are the processes involved in developing
a...
I am currently managing the feasibility study phase of a data warehousing project.
August 4, 2003 I am currently managing the feasibility study phase
of a data warehousing project. However I am currently having a
tough...
I am postgraduate in economics, presently working on my MBA in operations.
August 4, 2003 I am postgraduate in economics, presently working on
my MBA in operations. I have a good knowledge of the German...
I would like to know about star schemas with multiple fact tables.
August 4, 2003 I would like to know about star schemas with multiple
fact tables. What are the advantages of having multiple fact
star...
In the insurance industry there are a lot of calculations that could be performed on the premium amounts.
August 4, 2003
Is there a standard that can be used as a guideline for sizing and capacity?
July 2, 2003 Is there a standard that can be used as a guideline
for sizing and capacity? I’ve been reading many sources of
information...
Which are the ETL tools that are generally recommended to be used with MicroStrategy?
June 4, 2003 Which are the ETL tools that are generally recommended to be
used with MicroStrategy?
We are planning a multinational data warehouse.
June 4, 2003 We are planning a multinational data warehouse. This
issue raises a number of interesting questions: How
should we...
We have an LDM in ERwin representing a comprehensive data repository expected to collect data from many sources.
June 4, 2003 We have an LDM in ERwin representing a comprehensive
data repository expected to collect data from many sources. We
are...
If someone were to venture into the BI world, what would be a logical starting place?
June 4, 2003 If someone were to venture into the BI world (say
some one with 10 years of experience in the IT field on legacy...
Do you have any information relating to very large, multiterabyte data warehouses and ODBC performance vs. other access methods to retrieve large queries?
May 2, 2003 Do you have any information relating to very large,
multiterabyte data warehouses and ODBC performance vs. other
access...
I have been told to identify all objects relating to a customer in a data warehouse and a data mart.
May 2, 2003 I have been told to identify all objects relating to a customer
in a data warehouse and a data mart.
Are there any industry standards or best practices on how to handle vendor solutions specifically pertaining to conforming to information architecture standards.
April 2, 2003 Are there any industry standards or best practices on how to
handle vendor solutions specifically pertaining to conforming...
I'm in charge of our data warehouse and one of my colleagues suggested we look into purchasing a job scheduler to handle file transfers, job dependencies, etc.
April 2, 2003 I'm in charge of our data warehouse and one of my
colleagues suggested we look into purchasing a job scheduler to
handle...
We met with one of the BI vendors to discuss query and reporting and multidimensional reporting.
April 2, 2003 We
met with one of the BI vendors to discuss query and reporting and
multidimensional reporting. As the discussion...
What is a DOLAP?
April 2, 2003 What is a DOLAP?
Are Brio, Cognos, Crystal, BusinessObjects and SPSS the same type of BI solution?
April 2, 2003 Are Brio, Cognos, Crystal,
BusinessObjects and SPSS the same type of BI solution? I get the
impression SPSS is more off...
What kind of software can be used in a customer alert system?
April 2, 2003 What kind of software can be used in a customer alert system?
Where do you stand on the Web services architecture debate – REST vs. SOAP. Do you think that Web Services is the same thing as middleware?
March 13, 2003 Where do you stand on the Web services architecture debate –
REST vs. SOAP. Do you think that Web Services is the same...
We are planning to implement a data warehouse. What are the advantages/ disadvantages of using Oracle database over Teradata?
March 13, 2003 We are planning to implement a data warehouse. What are the
advantages/ disadvantages of using Oracle database over Teradata?
Are there any Web sites or institutions that give the pros and cons for each BI tool? And are there any selection criteria?
March 13, 2003 Are there any Web sites or institutions that give the pros and
cons for each BI tool? And are there any selection criteria?
I have trouble selling the data warehouse to management.
March 13, 2003 I have trouble selling the data warehouse to management. They
believe
that the minimal reporting capabilities they have...
We are building a DW for our distribution company.
February 3, 2003 We are building a DW for our distribution company. We
are defining the metrics and key performance indicators (KPIs)
to...
My customer information is spread over multiple systems on different platforms.
February 3, 2003 My customer information is spread over multiple systems on
different platforms (Windows, UNIX, mainframe). The requirement...
I have a small problem relating to the relationships that exist between a dimension table and a fact table.
February 3, 2003 I have a small problem relating to the relationships that exist
between a dimension table and a fact table. There are two...
We are working with a data warehouse project where we extract data from the source (ETL) and create fact tables and dimensions depending on them.
January 13, 2003 We are working with a data warehouse project where we
extract data from the source (ETL) and create fact tables and...
Does implementation of XML require an XML server?
January 13, 2003 Does implementation of XML require an XML server? Does
conversion of standardized extract files from numerous sources...
As part of a corporate-wide, one-instance implementation of ERP (SAP R/3) we are rethinking master data maintenance and data quality.
January 13, 2003 As part of a corporate-wide, one-instance implementation
of ERP (SAP R/3) we are rethinking master data maintenance and...
Is there any possibility of linking the measure of a particular fact to another fact in multiple fact star schema which needs the measure?
January 13, 2003 Is there any possibility of linking the measure of a
particular fact to another fact in multiple fact star schema
which...
We are trying to create a policy on information reporting that would identify the types of reports that should come from our DW vs. those that should come from our operational systems.
January 13, 2003 We are trying to create a policy on information
reporting that would identify the types of reports that should
come from...
Are you aware of any tools that analyze COBOL programs to produce a traceability/transformation map that could be used to migrate to a commercial ETL tool?
January 13, 2003 Are you aware of any tools that analyze COBOL programs to
produce a traceability/transformation map that could be used to...
How do I get project managers (business side/end users) to take ownership in a data warehousing initiative?
January 13, 2003 How do I get project managers (business side/end users) to take
ownership in a data warehousing initiative?
What is the industry standard benchmark for data warehouse customer usage?
December 2, 2002 What is the industry standard benchmark for data warehouse
customer usage? I am particularly interested in comparing the...
If there are 10 data marts which use different schemas (some use star and the others use snowflake), will inconsistencies arise designing a data warehouse using a bottom up approach?
December 2, 2002 If there are 10 data marts which use different schemas (some use
star and the others use snowflake), will inconsistencies...
Assuming that the applications and databases are on separate machines, what is the current thinking on where the data warehouse database should reside?
December 2, 2002 Assuming that the applications and databases are on separate
machines, what is the current thinking on where the data...
Do you suggest surrogate keys in data marts and/or EDW solutions?
December 2, 2002 Do you suggest surrogate keys in data marts and/or EDW solutions?
We are in the process of building an insurance data warehouse.
November 5, 2002 We are in the process of building an insurance data warehouse.
Some of
the people involved in this project are thinking...
We are doing an OLTP project for our client, but they want OLAP capabilities for reporting.
November 5, 2002 We are doing an OLTP project for our client, but they want OLAP
capabilities for reporting. Since these are such opposite...
My company is currently starting an enterprise data warehouse project with an end result of ultimately feeding all of the back-end systems including our General Ledger system.
November 5, 2002 My company is currently starting an enterprise data warehouse
project
with an end result of ultimately feeding all of the...
I am building a data mart for a P&C insurance company.
October 3, 2002 I built a
dimensional model comprised of a dozen dimensions. Something
about it doesn't feel right. Shouldn't I break the...
Managers have always received financials and management reports in Excel spreadsheets that were prepared by the end-user community.
October 3, 2002 Should a data warehouse be used to produce management
reports in specific subject areas that will be sent to the
managers...
I have a customer who has a DW implemented on Oracle and Oracle Express.
October 3, 2002 I have a customer who has a DW implemented on Oracle and Oracle
Express. I'm on the lookout for a tool that would mine/query...
Is BI reporting and reporting embedded in applications different?
October 3, 2002 Is BI reporting and reporting embedded in applications
different? Are
there any tools that do both or should two...
I have a modeling question: I have sales transactions (line items) that I want to put into a star schema in a data mart.
September 4, 2002 I have a modeling question: I have sales transactions (line
items) that I want to put into a star schema in a data mart....
We are having a little debate here regarding the use of codes along with their related descriptions in our the relational dimensions (not the OLAP dimensions).
September 4, 2002
I found several definitions of BI.
August 26, 2002 I found several definitions of BI. I wonder what the real
meaning of BI is and what is its relation with CRM and ERP?
In your opinion, what will be the hottest industry sectors (for example, banking, health care, insurance) for BI applications in the coming year across North America?
July 26, 2002 In your opinion, what will be the hottest
industry sectors (for example, banking, health care, insurance)
for BI...
I would like to know if you have any studies comparing different software for business intelligence?
July 26, 2002 I would like to know if you have any studies
comparing different software for business intelligence?
Many organizations have an interest in enterprise application integration (EAI) lately.
July 26, 2002 Many organizations have an interest in enterprise
application integration (EAI) lately. How are business
intelligence...
What does granularity mean in the context of a data warehouse and what are the various levels of granularity?
June 25, 2002 What does granularity mean in the context of a data warehouse
and what are the various levels of granularity?
We have implemented a data warehouse and we use OLAP (Essbase) and MS Access to query the data in the warehouse.
June 25, 2002 We have implemented a data warehouse and we use OLAP (Essbase)
and MS Access to query the data in the warehouse. We need a...
What is the relationship between the data warehouse and data marts?
June 25, 2002 What is the relationship between the data warehouse and data
marts?
I am in the process of designing the data model for the data warehouse. Is star schema or snowflake better?
June 25, 2002 I am in the process of designing the data model for the data
warehouse. Is star schema or snowflake better?
What are the implications to a data warehouse implementation striving toward a zero latency enterprise (ZLE) solution?
June 5, 2002 What are the implications to a data warehouse implementation
striving toward a zero latency enterprise (ZLE) solution? Is...
My company is planning to replace our old BI tool.
June 5, 2002 My company is planning to replace our old BI tool. One of our
legacy systems
uses an INGRES database. How much of a...
Data quality is a critical issue affecting data warehouses, (DWs) yet there appears to be no sustainable solution with regard to quality input
June 5, 2002 Data quality is a critical issue affecting data warehouses,
(DWs) yet there appears to be no sustainable solution with...
Is there a comparison study/article on the popular BI tools - Business Objects, Microstrategy, Cognos, Crystal and Brio?
June 5, 2002 Is there a comparison study/article on the popular BI tools -
Business
Objects, Microstrategy, Cognos, Crystal and Brio?
What are the recent trends in terabyte-size data warehouse backups?
May 3, 2002 What are the recent trends in data warehouse backups where the
size of the warehouse is in terabytes? Are full online...
What products perform well on an OS/400 platform?
May 3, 2002 I am working on an OS/400 Platform, setting up a data warehouse
structure for my company. A fact table of 5,000,000 records...
What is the difference between summary and aggregate data?
May 3, 2002 This is a simple data mart question. What is summary data? Most
books and white papers state that the star schema contains...
My company is now investigating whether you could use one database model and/or one database for both OLTP and OLAP worlds.
May 3, 2002 My company is now investigating whether you could use one
database model and/or one database for both OLTP and OLAP...
How could developers improve the use of DSS and EIS with DW technology?
April 17, 2002 How could the developers improve the use of DSS and EIS based on DW technology?
In a data warehouse for the financial or telecom industry, the customers are of two main categories: corporate and retail.
April 17, 2002 In a data warehouse for the financial or telecom industry, the customers are of two main categories: corporate and retail....
How important it is to have a separate ETL tool when our target RDBMS supplies ETL capabilities, e.g., PL/SQL in Oracle and DTS in MS SQLServer?
March 13, 2002 How important it is to have a separate ETL tool when our target RDBMS supplies ETL capabilities, e.g., PL/SQL in Oracle and...
I'm looking for some input on building and maintaining the data warehouse development and testing environment.
March 13, 2002 I'm looking for some input on building and maintaining the data warehouse development and testing environment. So far, our...
Our client already has many data marts without a data warehouse.
March 13, 2002 Our client already has many data marts without a data warehouse. I have to build the enterprise data warehouse, but I don't...
I have a question about OLAP.
March 13, 2002 I have a question about OLAP. OLAP is very popular recently. Before when we were talking about BI, we wanted to know our...
We are looking to implement a new messaging/middleware tool before our existing middleware tool causes havoc or grinds to a halt.
March 13, 2002 We are looking to implement a new messaging/middleware tool before our existing middleware tool causes havoc or grinds to a...
There are some lively discussions going on regarding the appropriate use of surrogate keys versus natural keys.
March 13, 2002 There are some lively discussions going on regarding the appropriate use of surrogate keys versus natural keys. What is your...
We are building a data warehouse which will start at 100GB and will reach the terabyte range or more.
March 13, 2002 We are building a data warehouse which will start at 100GB and will reach the terabyte range or more. Can Oracle scale to meet...
Is there any recommendation as to the best way to set up a DW team structure?
March 13, 2002 Is there any recommendation as to the best way to set up a DW team structure? Is it better to have specialists who focus on...
My company is implementing a DW, later this year an EAI project will be initiated.
March 13, 2002 My company is implementing a DW, later this year an EAI project will be initiated. Are there any design considerations,...
Regarding dimensional modeling vs. OLAP modeling.
March 13, 2002 Regarding dimensional modeling vs. OLAP modeling. Should these tasks have separate titles and roles or are they one and the...
How would you characterize the difference between Bill Inmon's philosophy on data warehousing and Richard Kimball's?
January 25, 2002 How would you characterize the difference between Bill Inmon's
philosophy on data warehousing and Richard Kimball's? As a...
Can you point me to articles discussing the importance of front-end tools/applications and the purpose they have in business?
January 25, 2002 Can you point me to articles discussing the importance of front-
end tools/applications and the purpose they have in...
Is there any BI tool that can handle a recursive hierarchy?
January 25, 2002 Is there any BI tool that can handle a recursive hierarchy?
We are developing a VLDB that will probably use aggregate tables as well as database partitioning.
January 25, 2002 We are developing a VLDB that will probably use aggregate tables as well as database partitioning. Which databases are...
What is the difference between data warehousing and business intelligence?
January 22, 2002 What is the difference between data warehousing and business
intelligence?
In your opinion, what are the next round of challenges in the data warehousing field, and what products are well poised to solve them?
December 13, 2001 In your opinion, what are the next round of challenges in the data warehousing field, and what products are well poised to...
Why has the concept of data warehousing become popular?
December 13, 2001 Why has the concept of data warehousing become popular?
In using a true DW design, if data integration techniques and standards are created and followed, are there other things that make it difficult to add additional data design (tables, fields, etc.) in later stages?
December 13, 2001 In using a true DW design, if data integration techniques and standards are created and followed, are there other things that...
I work for the conference production company and am currently conducting research for our new project on the topic of data mining/data warehousing.
December 13, 2001 I work for the conference production company and am
currently conducting research for our new project on the topic
of...
What kind of third-party software can I use to build a cluster for Windows NT? Or can I somehow use just the NT?
December 13, 2001 What kind of third-party software can I use to build a
cluster for Windows NT? Or can I somehow use just the NT?
I've just finished my MBA (systems) and I am looking forward to a career in data warehousing.
November 20, 2001 I've just finished my MBA (systems) and I am looking forward to a career in data warehousing. Kindly advise me on the specific...
I'm evaluating DataStage from Ascential and PowerCenter from Informatica they seem to have pretty similar functionality, can anyone tell me what the main differences between them are?
November 20, 2001 I'm evaluating DataStage from Ascential and PowerCenter from
Informatica they seem to have pretty similar functionality,...
Apart from stored procedures what is the best language for writing data cleansing and transformation code for any DW?
November 19, 2001 Apart from stored procedures what is the best language
for writing data cleansing and transformation code for any DW?
Information Management discussion: Business Intelligence
