There aren't many medium sized companies these days that don't
already have a multitude of existing systems and piles of data.
Any new system will invariably require a migration of data from
existing systems. This can be purely standing data, such as product
migration, or it can include historical data too, such as details
of sales transactions. The average data warehouse
will have both standing and historical data but further complications
will arise over time as a result of changes in standing data.
Therefore we have devised a method for planning, building and running
data migrations, encompassing:
- Mapping Specification and Verification
- Data extraction
- Data conversion
- Data mapping, cleansing and transformation
- Data validation and verification
- Bulk and incremental data loading
We also have experience of many techniques needed for a successful
data migration of a significantly sized system (e.g. millions to
billions of transactions):
- Fast processing programs written in C/Pro*C
- Array processing
- Parallel processing
- High performance SMP sort packages (e.g. syncsort and cosort)
- SQL*loader tuning (a.k.a. "go faster" parameters)
- Change data capture
Data migration is one of Veriton's core competencies. We also have
software to manage and control the process along with a Product
that converts data from EBCDIC to ASCII (for migrating data from
mainframe or AS/400 to UNIX).
If you'd like to know more, whether your project is at the feasibility
stage, or if you've met problems with a migration project then please
give us a call.