This section will include the updated capabilities in Lyftron in the month of July. We have added few features and function along with some connectors. For you more detail view you can click on the links.
Two new aggregate and one analytical function added
|GROUPING||Indicates whether a specified column expression in a GROUP BY list is aggregated or not. GROUPING returns 1 for aggregated or 0 for not aggregated in the result set. GROUPING can be used only in the SELECT <select> list, HAVING, and ORDER BY clauses when GROUP BY is specified.|
|GROUPING_ID||Is a function that computes the level of grouping. GROUPING_ID can be used only in the SELECT <select> list, HAVING, or ORDER BY clauses when GROUP BY is specified.|
|CUME_DIST||Calculates the cumulative distribution of a value in a group of values. That is, CUME_DIST computes the relative position of a specified value in a group of values. For a row r, assuming ascending ordering, the CUME_DIST of r is the number of rows with values lower than or equal to the value of r, divided by the number of rows evaluated in the partition or query result set. CUME_DIST is similar to the PERCENT_RANK function.|
A section added to show the Broken Views screen which will display list of views which are no longer valid.
New connectors added
We have added few database connectors in this month.
|Amazon S3 or Amazon Simple Storage Service is a service offered by Amazon Web Services that provides object storage through a web service interface|
|Sybase, Inc. was an enterprise software and services company that produced software to manage and analyze information in relational databases|
|SAP IQ (formerly known as SAP Sybase IQ or Sybase IQ; IQ for Intelligent Query) is a column-based, petabyte scale, relational database software system used for business intelligence, data warehousing, and data marts|