I'm coping MySQL databases to Red-Shift with the help of an ETL tool called Matillion, and I'm using the same tool to query the database. Most of the queries I've written are basic select queries with lots of joins, unions and sub-queries.
Since Red-Shift is specialized for analytical processing, I want to transform my basic queries into OLTP queries.
I'll be grateful if someone could point me a direction to learn how to write queries more OLTP way.
Thanks!
To clarify, Redshift is not an OLAP database (like HANA or SSAS), so you can't query Redshift in an OLAP way.
However, Redshift does of course support the full range of analytic functions, which are very much OLAP-like: http://docs.aws.amazon.com/redshift/latest/dg/c_Window_functions.html
Matillion supports that too, for example with the
Window Calculation Component https://redshiftsupport.matillion.com/customer/portal/articles/1991935-window-calculation-component
You can also search for a Rank Component on the Matillion ETL for Amazon Redshift support portal.
Matillion also has documentation/videos on Data Quality Framework which goes through some of these.