Latest Activity

code

Limitations on derived view (JOIN)

Hi All, we have derived view (JOIN) created with 15 tables (14 joins) and planning add additional logic which will bring 10-15 joins additonally . Could you please let me know if there will be any limitaion on that ? Thanks, Ravi

  • Answers: 1
  • answered 25-01-2023 08:16:47 -0500

limitation hash join join

code

Delegating HASH Joins

I've got a derived view that is re-used in mutiple views. I've identified the code on the sql server side would be most effective at a specified HASH Join. How do I get Denodo to deligate a HASH join to the database (SQLServer)? I've specified a HASH j...

  • Answers: 1
  • answered 08-02-2018 11:20:28 -0500

Related to: Denodo Query Optimizations for the Logical Data Warehouse

hash join

code

Records missing in a derived view, but the data exists in those base views or the source tables even after applying the same join conditions which are being used in derived view.

Hi All, I am encountering this wierd scenario in denodo. 3 records are not displaying when I query based on the name, and 3 records are being displayed when I query based on the id from the derived view. Denodo version: denodo platform 5.5 I have ta...

  • Answers: 3
  • answered 07-07-2016 09:07:59 -0400

hash join missing records resultset derived view sort merge not same with different where conditions

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