Q&A

Joins in Derived Views (VS) Associations
answered 21-10-2020 07:57:58 -0400

Hello Team, I would like to understand what option is better to use in the scenario of star schemas: Only Joins in models for the derived views Only Associations in Derived views A combination of Joins and Association in Derived Views Plea...

Answers: 1

joins Associations Derived views

Associations Vs Joins
answered 21-10-2020 07:50:44 -0400

I would like to understand what option is better to use in the scenario of star schemas: Only Joins in models for the derived views Only Associations in Derived views A combination of Joins and Association in Derived Views Please explain in ...

Answers: 1

association derived view aasociations vs joins

Received Error 500 when logging in
answered 21-10-2020 07:09:31 -0400

I received the following error when logging into the Denodo community website... Error 500 SOMETHING'S NOT RIGHT BUT WE'RE LOOKING INTO IT An internal server error has happened but our support team is working on it. Please be patient while we fix it.

Answers: 3

Creating Base View using Delimited files
answered 20-10-2020 10:39:04 -0400

Hi Team, I have one requirement: There is one folder on FTP path which contains text files(many text files) having record like Name:Neetu Age:34 Department:IT ContactDetails: Mob:123456 Phone:56778 Address:xyz EducationDetail: HighestQualification:...

Answers: 1

Delimited file data source

Need to extract the second row of a duplicate in a table
answered 20-10-2020 08:03:34 -0400

Hi Folks! I have a scenario where I have a list of customers with a driver number. In some instances, the customer is duplicated because of a second driver being assigned to the customer. Such as this; Customer Driver 101369 5058 101369 5602 How do ...

Answers: 1

row number select derived views

Using com.denodo.scheduler
answered 20-10-2020 04:06:40 -0400

Hi, I'm using Denodo 7.0 update 20200803 and attempting to use the scheduler api via Python/Jpype. Is there a particular jar file I need for the Scheduler? The code below is my attempt. import jpype import jpype.imports from jpype.types import * jp...

Answers: 1

Denodo Scheduler 7.0 API Python

Connecting to data lake gen2 with a free trial
answered 19-10-2020 11:42:52 -0400

Would like to download The Distributed File System Custom Wrapper to connect to a data lake store gen2 in Azure. I cannot download the file from support.denodo.com as I have a trial license only. How can I get the wrapper, my trial is running out, so ...

Answers: 3

Azure Data Lake Storage Gen2

Losing connectivity for Denodo user
answered 19-10-2020 06:39:19 -0400

When I provision the Denodo AMI as an EC2 instance, I follow the directions to get it going and everything is fine. However, if I stop that instance (e.g. working on something else for a while) and then restart it, all of a sudden the Denodo user can'...

Answers: 1

AWS Login time out AWS

Fetching View's underlying query
answered 16-10-2020 08:53:59 -0400

Hi Denodo team, I have a requirement of fetching view and also the query through which this view is created if that view is created by query.I have tried GET_VIEWS(), CATALOG_VDP_METADATA_VIEWS() and CATALOG_METADATA_VIEWS() procedures.But none of them...

Answers: 1

Base view Stored Procedures query logs Denodo view

Full Caching mode
answered 16-10-2020 07:41:32 -0400

Hello, I am trying out full caching mode and I am using a API from whcih I am calling data and I cannot store last refresh date in it. Can you let me know if still I can use Full caching as it fully suits my requirement.

Answers: 1

caching