SQL BI Stack review

- There is flexibility to Transform various data. There are also templates that help to guide you in using best practices such as building TYPE 2 loading of Data Warehouse tables
- There are many transformation features that allow for sorting, lookups, using a variety of data sources and targets. It is a full featured product.
- There are a lot of properties that allows you to customize data flows to suit your needs.
Cons
- Having to sort prior to merging is a pain.
- Working on very large data sets approaching 1 billion records require a lot of pre-planning. Teradata handle large data sets better
- Error messaging is sometimes not explicit enough. "Something went wrong" is one of my "favorites" that I have seen