Latest Activity

code

Adding prefix to a register subfields

Hello, I want to add a prefix to all register subfields. In my case I have a register of registers. For each subfield of the register i want to add a specific prefix depending on the position of the register in my schema. For example, I have a registe...

code

List of Datasource

Hi team, I have to list out all the Data Sources which are present in my Design Studio. Along with name , I need other detzails as well like connection string username etc. Can you please tell me how to get this list. Is there any table or procedure ...

code

Timezone in solution manager

Hello All , Please i want to know how can change Timezone in solution manager ? Thanks for your time

code

denodo training

in my training section under the courses there is " access expires in 8 days " does that mean i cant watch the videos of the course after 8 days ?

code

python connect to denodo by using PSYCOPG2

I am getting below error port 9999 failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

code

Invalid Views list.

Hi team , I am using Denodo 8.0 Verssion. Please let me know how do I bring list of All Invalid Views and associations ( including Base , Integration , Derived , staging , Business views ) in tabular format. I tried to execute desc database <databa...

code

time dimension table

my fact table contain two field of time one for the creation and the other for the shiping how i can create the time dimension tible in denodo ?

code

in denodo scheduler the cache jobs are stuck running state

in denodo scheduler the cache jobs are stuck running state

code

One of our View is running longer.

Hi, One of our query is running longer. Scenario-1: We have created one view to get some columns( using case statements) and used 4 to 5 sub queries and joined them individually with main table. Scenario-2: We have modified the Scenario-1 query like m...

code

Query a field in a register in denodo

Hi, Can we query a subfield from a register in vql shell without knowing the exact path of the subfield. is there a query like : select [subfield name] from xxview. So if the subfield is under register1.register2..registerN, we dont have to specify th...