Amazon Redshift database
AWS Redshift

Copy
Copy fixed length
Copy Manifest ( like informatica txt file locator will have all the file names as entry)


AWS is an IAAS

Redshift could connected in VPC(Virtual Private cloud) or using sql workbench


Compression

Columnar

Zone map

Direct attached storage

Large datablock size

Cost Effective (less than 1k$ ) for Teradata


DS2 and DS1 servers


Operations

Load

Query

Resize the cluster

Backup

Restore


SQL Client


leader Node

Compute Node

Amazon s3


Data Block : 1 MB

HPC(High Performance Computing)

Process 4TB /Hr

VIrtual Processing Systems


Moving data from System to Cloud
Snowball
Hybrid Cloud
Storage Gateway
Technology Partnerships
Kinesis Firehouse
Transfer Acceleration