Q&A

Denodo alternative for TSQL "STUFF.... FOR XML PATH"
answered 04-10-2019 02:35:33 -0400

Hi, I have a table with multiple rows and a single column called ID - it is aways 5 chars long ID 12345 23456 34567 I want to create a view with a single column output and a single row output that will concatentate all the values inserting a com...

Answers: 2

ARRAY

Denodo Architecture for Developer and Administrato
answered 03-10-2019 07:24:19 -0400

Hi, I just downloaded Denodo Express and started importing some sources. I was wondering how I shoould be using Denodo in my Company, for example, is it right to install denodo in a server and then let the developer connect to this server using their...

Answers: 1

Access Denodo Express Administration Tool

Denodo Data Catalog tutorials
answered 03-10-2019 07:01:09 -0400

Hi Team, Can anyone suggest me some links to understand denodo data catalog better? I had a good read about it few weeks before, but am not able to find the content now, when I searched Thanks for your help, Manju

Answers: 1

#data catalog

Denodo 7 data catalog: share (explore) queries
answered 02-10-2019 14:06:24 -0400

Hello, For the Denodo catalog, what is the recommended way for a user to share a query, is it possible via the web interface? to other data catalog users? can it be shared so that other catalog users can see updates after obtaining access to the s...

Answers: 1

Delimited file sources- rows to columns
answered 02-10-2019 09:51:06 -0400

Hi, I'm having an issue with a delimited file source. The file is actually a column from a big query wich contains a CLOB, that clob has the next format : parameter1:value1;parameter2:value2;parameter[n]:value[n]; ........ What i want is to convert ...

Answers: 2

delimited file sources rows columns pattern tupple

get_view_columns
answered 01-10-2019 06:44:41 -0400

We are using the get_view_columns() function to pull denodo interfaces and columns into the MicroStrategy warehouse catalog. We have run into an issue that if a transformation has had manual vql manipulation, the function fails to return all columns. ...

Answers: 1

Microstrategy VQL get_view_columns

In view row_number() is not working expected.
answered 01-10-2019 06:13:59 -0400

In view row_number() is not working expected. but same query from VQL Shell giving me expected results. What is the issue ? I pass same where clause. From VQL shell which is need row_number 1 1 2 3 4 From View row_number 49 50 51 52 115 What caus...

Answers: 3

VQL Vql shell row number

Performing denodo tasks from Jenkins
answered 01-10-2019 04:17:26 -0400

I am trying a create a working prototype for performing denodo activities from my Jenkins server. Steps that i want to perform are : Import a VSQL file from GIT to Denodo from Jenkins. Create a view in Denodo from Jenkins. Run this VSQL file in Denod...

Answers: 3

Jenkins DENODO

consistent user & role management
answered 30-09-2019 18:45:55 -0400

Hello, what is the recommended way to have consistent users and roles on VDP clusters with multiple nodes? Can the solution manager be used for this? At the moment, we have to manually implement changes/additions to users & roles in VDP admin mu...

Answers: 1

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