Q&A

Create empty file if query does not return result
answered 21-01-2020 08:10:07 -0500

Is there some way to distinguish when we have an input empty file in the source or the file is missing? (sftp protocol with "flat file" data source) From our POV, the behaviour should be different: We are expecting to receive a delta file with "yeste...

Answers: 5

emptyresult

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

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

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

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

Configure fields to ungroup or group dates
answered 15-01-2020 13:57:06 -0500

I want to make an integration of data where I can manage the date, that is to say a type of query for a period of time. Weekly sales, monthly sales, among others. Greetings from Ecuador.

Answers: 2

Using Denodo VDP admin database as source from Talend
answered 15-01-2020 13:33:47 -0500

I got Denodo AWS trial environment and trying to use Denodo as the source from Talend Data Catalog tool to test the metadata harvesting. I tried to use 'jdbc:vdb://ec2-54-175-90-97.compute-1.amazonaws.com:9999/admin' with 'admin/admin' as username/pwd ...

Answers: 1

aws free-trial

Load data from Google Sheets
answered 15-01-2020 10:24:47 -0500

Hello, I'm trying to load data using the Google Drive API from Google Sheets with Denodo. I followed the steps described here: https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Google%20Sheets%20Tool%20-%20User%20Manual an...

Answers: 1

Google Drive API

Fail query if filenames do not exist in path
answered 14-01-2020 12:03:16 -0500

Hi is it possible to fail the query if the required files are not in the path? I tried this, but in the path it is nos possible to set regular expressions (anychar). PATH /path/PATTERNAME_^DateRange("yyyyMMdd",@startdate,@enddate,"yyyyMMdd")(.*) <...

Answers: 1

Collecting Field wise stats without using CSV
answered 14-01-2020 08:45:13 -0500

How can I generate statistics at a field level using the scheduler without creating the csv or the base view to pass the viewname and fieldname values ?

Answers: 3
Related to: How to update the statistics of a view automatically

Automic scheduler Gather Statistics Generate stats