Data Warehousing:
Data Acquisition Solutions-
Accelerated Development for Data Warehouses and Data Marts

The data acquisition process is a critical component of the data warehouse initiative. However, it is often under-planned and under-estimated: an orphaned side-effect of the "real" project, namely building the data warehouse.

Daman Incorporated can help you prepare wisely for your data acquisition requirements. Applying its tried and tested methodologies, Daman Incorporated can plan and design an accurate and efficient data acquisition process. You'll receive a process plan that will effectively support not only initial deployment but also the day-to-day operation of your warehouse.

Strong Capabilities
Daman Incorporated project teams bring strong capabilities to your data acquisition and interfaces efforts. These include:

• Strong functional expertise of the source operational systems and understanding of data warehousing methodologies,
• Solid core competency in analysis, programming, testing and database performance tuning,
• Expertise with automation and/or productivity tools used to streamline and accelerate the implementation process.
• Experience with designing and developing data acquisition solutions for data warehouses on varied platforms (including Oracle, Sybase, Informix, DB2, Teradata, and Redbrick)
• A profound knowledge of meta data management tools and methodologies, including Daman Incorporated's MDMS^TM™ meta data modeling and management tool.

Advanced Functions
Daman Incorporated's data acquisition methodologies address the following functions:

• Identification of the requisite source and external data
• Query of source systems and extraction of data
• Data preparation, transformation, and/or integration
• Verification of data integrity (source & derived; detail &summary/aggregate)
• Initial population of data warehouse
• Process for 'change data capture' and incremental refreshes (either scheduled or on a real-time basis)
• Automated meta data generation; update of meta data repository
• Integrated meta data models and advanced impact/ dependency analysis
  • Error and exception reporting and processing
  • Data replication and data interfaces between multiple DSS structures

The primary drivers of the architecture that best supports the functions described above include decision support information and reporting requirements, and technical constraints and requirements. Daman Incorporated will factor these in to arrive at an optimal architecture and approach.

Your Critical Advantage
A key component of Daman Incorporated's Data Acquisition Solutions is the use of accelerated development methodologies and tools in developing and deploying solutions for both enterprise-scalable data marts and enterprise-wide data warehouses.

These accelerated solutions can deliver targeted information to decision-makers quickly and in a cost-efficient manner. Ongoing feedback from user experience can then be used for complete optimization of the design of both the warehouse and acquisition solution. Such an accelerated approach can significantly enhance the probability of success of the warehouse effort.

Daman Incorporated provides assistance in the selection of such tools and approaches. We also provide value-added Incorporated services to optimally leverage investment in such tools.