Amazon Redshift provides high-performance cloud data warehousing via a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your business data—especially when compared with traditional solutions.
Amazon Redshift delivers fast query performance by using columnar storage technology to improve I/O efficiency and parallelizing queries across multiple nodes. Data load speed scales linearly with cluster size, with integrations to Amazon S3, Amazon DynamoDB, Amazon Elastic MapReduce, Amazon Kinesis or any SSH-enabled host.
Amazon Redshift supports standard SQL and provides custom JDBC and ODBC drivers that you can download from the console, allowing you to use a wide range of familiar SQL clients. You can also use standard PostgreSQL JDBC and ODBC drivers.
The Informatica Cloud integration solution for Amazon Redshift is a native, high-volume data connector that enables you to quickly and easily design petabyte-scale data integrations from any cloud or on-premise sources to any number of Redshift nodes, and to gain rapid business insights.
ETL World with informatica 