Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in April 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community

FULL CACHE
answered 09-03-2018 07:56:04 -0500

Hi: I'm trying to use fullcache for a DV compound of a join between a ODBC and JDBC base views, when executing this DV dv_customer_calls without cache the result is 2512 rows, however when updating the DV to Full Cache it restuns 0 rows. Is this the ex...

Answers: 1

Cache

Environment management with Version Control (TFS specifically)
answered 09-03-2018 07:33:16 -0500

The VCS documentation is not all that clear, especially when it comes to environment management. When using VCS with several environments, we see that Denodo checks in a .properties file for each environment, containing only their name and description....

Answers: 1

TFS Environments VCS Properties

Attribute level business metadata
answered 09-03-2018 07:16:21 -0500

We have a external metadata repository with all of our business definitions. We assign a business definition to every field in the database/rest service etc. Is it possible to bulk import field descriptions from external sources? Can it be extended t...

Answers: 1

Metadata

Scheduler Data source change
answered 09-03-2018 07:05:58 -0500

Hi Team, Can you please let us know in which log we can capture any changes made at scheduler data source level ? Thanks

Answers: 1

Export Script for Changed Views(Delta)
answered 09-03-2018 06:48:36 -0500

Hi Team, I know we can have export script written which can take backup of complete virtual databases. I am looking to have a script which will only export Delta for those views or component which got changed after last export was run. Each view shou...

Answers: 1

ODBC Timeout.
answered 09-03-2018 06:19:52 -0500

I created a ODBC connection DSN to Denodo, using the Denodo ODBC driver, that is using a long running query. I had the timeout set and eventhough the query was still returning data, the connection timedout according to the setting. That is not the beha...

Answers: 1

ODBC

JDBC Connection Query "select 1"
answered 09-03-2018 06:16:49 -0500

We have some webservices setup to hit Hadoop Impala's JDBC connection. We are seeing "select 1" queries every minute for each of the webservices that we have setup. Is there a way to change the frequency of these queries (they are being fired off every...

Answers: 1

Denodo 6.0 JDBC

Alias name of view is something different
answered 09-03-2018 05:36:48 -0500

Hi Team, I have view in DB as DND_PRODUCER_SUMMARY_VW, just importing into Denodo, while importing, I changed capital name into small letters as "ud_producer_summary_vw' but when i see VQL for this base view. I am getting as below, my question is why a...

Answers: 1

Lookup - Informatica PowerCenter
answered 09-03-2018 05:31:32 -0500

I hear regular complaints from my ETL team that Denodo Views selected as lookup is not performing well, they had to move it as source qualifier. Do you have any recomendataions on this before i get more details from my team.

Answers: 1

lookup DENODO Informatica

Meaning of the join arrow's direction in a join view
answered 08-03-2018 08:11:48 -0500

When joining two or more views (as source) together in a join view, Denodo will draw an arrow between the tables. The arrow's direction seems to depend on how you "draw" the line, i.e. from which table you start. Is there any "deeper" meaning to this ...

Answers: 1

join