Q&A BY TAG 'primary keys'

You must sign in to ask a question. If you do not have an account, you can register here

Enforcing primary key
answered 06-06-2018 16:20:29 -0400

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

Answers: 1

primary keys

Primary Key Must?
answered 20-04-2018 03:34:45 -0400

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

Answers: 1
Related to: Denodo Query Optimizations for the Logical Data Warehouse

primary keys

Forcing primary key to remove duplicates from a derived view
answered 30-01-2018 13:23:25 -0500

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

Answers: 1

Duplicates primary keys

How can we insert rows with a sequence generated primary key?
answered 10-10-2014 01:07:01 -0400

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

Answers: 2

rest sequence oracle primary keys