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 September 2019.

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.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Denodo Specialist Responsibilities
answered 20-01-2020 13:17:47 -0500

Hi Team, Can you please tell me what are role and resonsibilities of denodo specialist

Answers: 1

Replicate data automatically
answered 20-01-2020 12:38:39 -0500

Good evening, once I have virtualized a database how can I do to export the data from the tables again. In other words, if I have loaded some tables in the Denodo, the transactional systems continue to fill my database (tables), as Denodo can be conf...

Answers: 2

Type of model in the join
asked 20-01-2020 12:35:45 -0500

The Denodo tool has the join function that allows you to join or integrate data from different sources, however, this works by means of PK (primary key) or FK (foreign keys), I would like to know what models are formed. In other words, it is a star mo...

Answers: 0

View statistics questions
answered 20-01-2020 11:24:00 -0500

I recently inherited Denodo admin duties and am investigating a scheduled job which is failing. The job gathers a list of all base tables in Denodo, then runs the following VQL: CALL GENERATE_SMART_STATS_FOR_FIELDS('SMART_THEN_ATSOURCE_THROUGH_VDP','B...

Answers: 4

generate_stats search methods VDP resultset Statistics timeout

2 solution managers 1 for production and1 for others
answered 20-01-2020 10:37:41 -0500

Hi, Can we have 2 solution managers installed. One for production and 2nd for other dev/test/QA etc. The reason is production team will not take any responsibility of any enviornment other than production. What's the best practice to deploy scripts to ...

Answers: 1

Join with Excel data source
asked 20-01-2020 08:38:14 -0500

Hi, Is there a way to optimize a join from Excel that has 1.7M registers with other one that has 25M registers. The problem here is it takes longer than 15 minutes so it times out. Any suggestions? Thank you, Best regards.

Answers: 0

Unable to start webcontainer
answered 20-01-2020 05:54:39 -0500

I am not able to deploy any web service. When I check the status of Webcontainer, it says OFF. WEBCONATINER START in VQL shell is unable to start. It says started but even after 30 minutes the status is still OFF. When I check the status: webcontainer...

Answers: 1

Error when run Ddenodo.launcher.excluded.jars
answered 18-01-2020 19:19:13 -0500

version: 7.0 OS: windows Error: When I run Ddenodo.launcher.excluded.jars on windows cmd,I saw '-Ddenodo.launcher.excluded.jars' is not recognized as an internal or external command, operable program or batch file. '-classpath' is not recognized as an ...

Answers: 2

Manage outlier with Denodo
answered 17-01-2020 23:47:36 -0500

Good afternoon, how can I manage the outlier in Denodo. Verify that they exist and then be able to eliminate them. It is to say from a list of quantities I have values that are exaggeratedly high or exaggeratedly low that will interfere with my data....

Answers: 2

How to get file modified date for an excel file in FTP location
answered 17-01-2020 17:47:30 -0500

We have defined some excel datasources that resides in a FTP server and Denodo BVs are created on top of them. We have a requirement to put the last modified/update date of each of the files (coming from different sources at different time). Is there a...

Answers: 1

File Modification Date