Q&A

Association will take effect on snow flake schema join?
answered 30-09-2019 06:41:20 -0400

Dose associations take effect for the snow flake join, for example, fact join dim_A,Dim_B, are star schema join, and join Dim_c, Dim_C join is not on fact column, it is on DIm_A and Dim_B column, how to make the association take effect?

Answers: 6

snow flake schema Association

How is the export properties file generated?
answered 30-09-2019 05:13:45 -0400

Working on automating a process of exporting a folder and its contents from one VDB and importing into another. We currently use the UI to export a folder and properties file then import to another VDB. The export tool will create a VQL and properties ...

Answers: 3

row_number() on flat file data source?
answered 27-09-2019 20:47:30 -0400

I have a flat file data source. I'd LOVE to use row_number() OVER ( PARTITION BY id ORDER BY id ASC ) against my flat file data source. But when I do, I get this: Finished with error: Error executing view: Function row_number is not executable I sa...

Answers: 1

issue with pagination in REST API call
answered 27-09-2019 09:16:58 -0400

I've configured a datasource with an http path of https://company.service.com/api/v1/entities?firm=2. The API uses next page pagination and so I've set those paramters up as well. when I run a query in my base view and look at the execution path, I see...

Answers: 1

Nothing happens on clicking Denodo icon
answered 27-09-2019 08:09:20 -0400

Hi i have installed Denodo software and can see Denodo shortcut icon on the desktop screen. However when i double click the icon nothing happens, also i tried clicking the icon in the actual location folder and nothing happens, i mean Denodo does not s...

Answers: 3

installation cannot use icon new installation

SQL Collation conflict between base views on different servers.
answered 27-09-2019 08:07:31 -0400

This error message is sent when executing queries against two joined sql tables: QUERY [JDBC ROUTE] [ERROR] Received exception with message 'Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in th...

Answers: 3

sql collation

Queryable API
answered 27-09-2019 07:31:54 -0400

For an API, can I query by multiple values? Example, if I have multiple employees, how can I write a queryable API to handpick a few employee's ?employee_id in '02019590, 02019592, 02019593' does not seem to work.

Answers: 1

SQL Query Reference
answered 27-09-2019 02:20:20 -0400

We have a customer who is trying to use our software to query via ODBC a Denodo virtual database. Apparently something about the way we format the SELECT statement is not liked by your query engine. Where can I find a reference on your SQL query lang...

Answers: 1

Vertical pivoting
answered 27-09-2019 02:05:46 -0400

Hi Team, Is there a way to do vertical pivoting in denodo? I have one data element which is a combination of 3 fields basically seperated by ~. Example: abc~dfv~1234 cvfdv~as~23 So the first seperation till ~ belongs to field A, second part belongs to...

Answers: 1

#array #customfunction

Caching Intermediate views
answered 26-09-2019 08:30:43 -0400

We have a requirement to cache an Intermediate view and it should never expire. We don't want it to be done manually for every single run. We need to implement it permanently. How do we do it in VDP or VQL Shell? We tried doing it by ticking the check ...

Answers: 1