You can translate the question and the replies:

Any idea whether basic ETL transformations like aggregation, lookups, etc. are possible in Denodo Platform?

I need to know if possible, how do we perform basic transformations which are normally used in ETL tools like Informatica, SSIS, et al. Any suggestions, clarifications or corrections are welcome.
user
16-04-2017 23:00:17 -0400

1 Answer

Hi, Denodo provides the Virtual Query Language (VQL) to perform queries and manage the data from the sources. That language is a SQL-like language highly compatible with SQL 92 ANSI standard. Hence, all the aggregations, selections etc can be performed as in a traditional SQL database. In this article of the Denodo Knowlegde Base, (https://community.denodo.com/kb/view/document/VDP%20Conformance%20with%20Standard%20SQL?category=VQL) we explain the conformance with the SQL 92 ANSI standard. Hope this helps!
Denodo Team
24-04-2017 05:53:52 -0400
You must sign in to add an answer. If you do not have an account, you can register here