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 November 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.

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

Date conversion not working as expected
answered 26-04-2017 07:09:36 -0400

I have a NUMERIC source column which is in format “YYYYMMDD”. I am using TO_DATE function to convert into date. However the dates are not converted accurately using the function. The dates I have in the source column are 20170421 while the output of TO...

Answers: 1

TO_DATE function

McAfee exclusions for Denodo
answered 25-04-2017 09:38:13 -0400

We have the McAfee Anti-virus software installed on our Denodo server and we are noticing very slow performance while loading the cache. Are they any McAfee exclusions that we need to consider to improve performance

Answers: 1

Denodo intstallation and Unintsallation on Linux Server
answered 25-04-2017 09:33:20 -0400

Hi Team, Can you please guide me for below queries : I have installed denodo on Linux server but somehow I forgot the steps . 1) How to unistall denodo from Linux Server 2) After downloading installer file , I know we need to execute below command ...

Answers: 1

installation

Can branch pruning remove unwanted joins during query execution from same source
answered 24-04-2017 17:32:43 -0400

We are using Denodo 6.0 and are trying to see if branch pruning works for the following condition: We have 2 base views bv1 and bv2 build on the same source. We have defined an assicoation between these 2 views. bv1 is Principal and bv2 is Dependent. O...

Answers: 1

Branch Pruning

Teradata as Cache Database and Configuring Monitoring Tool for Teradata
answered 24-04-2017 16:56:47 -0400

Teradata as cache Database: Does Denodo supports Teradata as caching database ? If yes then is it works as other RDBMS system does ? I wanted to confirm if I setup Teradata as cache database, element delegation such as function, subquery, etc, should w...

Answers: 2

cache cache configuration Denodo Monitor teradata monitoring tool monitor

Connecting with Hive database in Cloudera distribution in VDP Denodo
answered 24-04-2017 16:23:15 -0400

Hi, I am trying to connect to Hive database in cloudera distribution with denodo installed on my local machine. I have database in hive and unable to configure the data source properties in VDP as it is asking for Credentials. Please provide me the ...

Answers: 3

cloudera Hive

VDP hangs, unable to create base view
answered 24-04-2017 12:01:59 -0400

During the creation of Base View the VDP system hangs. The DS is a delimited file with 1000+ columns. -- Lokesh

Answers: 1

lastIndexOf Functions
answered 24-04-2017 08:45:56 -0400

Is there a function like lastIndexOf? https://www.tutorialspoint.com/java/java_string_lastindexof.htm Or any workaround?

Answers: 1

LastIndexOf

Any idea whether basic ETL transformations like aggregation, lookups, etc. are possible in Denodo Platform?
answered 24-04-2017 05:53:52 -0400

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.

Answers: 1

Informatica

Organize columns under Denodo Join View
answered 24-04-2017 05:32:16 -0400

I'm working on Denodo Plateform 6.0. My client wants the Join View columns organized according to the dimension and fact it's been build upon. I went through many Denodo documents but not able to find any clue which describe the organizing of Join View...

Answers: 1