Data Migration
Data Warehouse Migration from Teradata to AWS Redshift
An American company that franchises and operates a chain of restaurants needed to migrate their on-premise Data Warehouse (Teradata Database) to AWS Cloud Infrastructure (Redshift Database)
Client Challenges and Requirements
- Large volume of data. Approx. size of data to be migrated was 8TB
- Data field mapping issues
- Time duration for entire Migration
- Large size of few fact tables
- Data Validation
Bitwise Solution
Tools & Technologies We Used
Amazon SCT
Teradata
Aginity for Redshfit
Amazon S3
Key Results
Reduced maintenance and operating costs for Data Warehouse
Faster execution of queries in comparison with previous setup
The deployment time was reduced from 24 hours to less than an hour
Enhanced Business Operations