Q&A BY TAG 'primary keys'

Hello. I have a view named left_view with 5 rows: column_1 column_2 column_3 abc some value some value def some value some value ghi some value some value ...

Duplicates Distinct primary keys join left join

I have a data source that is doing a series of calls to an API to pull in a full data (the first time) that takes almost 6 hours. I successfully cached that data into a view -- but now want to only update records everyday that have a "last updated date...

primary keys Cache Error API

I have a baseview I created from our LDAP connection. I am trying to set the field samaccountname as the PK and I get the following error message: Unexpected error executing operation: null Is there a reason for this?

LDAP primary keys Error

In the scenario where we do not have concept of primary/ foreign key in source system such as Snowflake in that case I got to know enforcing primary key in denodo 6 does not assure that i will have unique values for a column or set of columns.What I am...

primary keys

Hello, Does Denodo require primary key on all views even if it is not defined on source system? If yes, Why? What benefits it offer. Thanks, Adinath

Related to: Denodo Query Optimizations for the Logical Data Warehouse

primary keys

Hiwe havearun 600 columns in our derived view and select distinct Option in the output tab would generate a vql with select distinct on all the 600 columns. This makes the query very expensive on the data source ( fully delegated). Is there a way to fo...

Duplicates primary keys

We would like to do POST requests to Denodo 5 webservices without including a primary key in the HTTP body/document and then have oracle generate the primary key based on a sequence. The equivalent SQL statement we are trying to mimic in Denodo is: ...

rest sequence oracle primary keys