Q&A BY TAG 'join'

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

Denodo Disparat sources join without Cache.
answered 26-12-2019 14:12:56 -0500

Hi Guys, I am new to Denodo. I have installed Express edition on my laptop and running a sample task. I have two disparate data sources (Postgres and MySQL), Postgres has agents table while MySQL has Customer and Orders data. When I execute a join ...

Answers: 3

join Cache

Different Hashes for same values hash()
answered 20-12-2019 08:53:17 -0500

Can anyone please help me understand how hash() function generates different results for same string input? Tables are different but the source is same, i.e. Postgres DB. because if this is the case, then join won't work on string columns, and it ...

Answers: 1

join hash

Join attributes of different (compatible) types across different data sources
answered 07-01-2019 07:40:30 -0500

Hallo Denodo Team, Suppose you need to join tables from different data sources (say Oracle and Teradata). Suppose the matching should happen between attributes that have different data types (say VARCHAR(N) on one side, NVARCHAR(m) on the other side, ...

Answers: 1

join datatypes

How do I concatenate two columns and use them in the join?
answered 20-12-2018 17:05:10 -0500

Hi Team, I would like to know, how would I perform the below join condiiton in VDP, how do I concatenate two columns to use them in the join operation. table_a a LEFT JOIN table_b b on a.column_a = concat(b.column_b1,b.column_b2) Regards, Shafeeq

Answers: 1

join

Meaning of the join arrow's direction in a join view
answered 08-03-2018 08:11:48 -0500

When joining two or more views (as source) together in a join view, Denodo will draw an arrow between the tables. The arrow's direction seems to depend on how you "draw" the line, i.e. from which table you start. Is there any "deeper" meaning to this ...

Answers: 1

join

Join type mismatch
answered 30-01-2018 17:07:59 -0500

We have an issue with database tables having different primary key types (numeric / character). There is a performance hit on the database side when these occur. is there any way for denodo to help identify when a type mismatch occurs when creating or ...

Answers: 3

join

Joining JDBC and ODBC base views, fail execution (ODBC error)
answered 21-11-2017 06:35:18 -0500

I am doing the first course of the Denodo Developer Certification. I am trying to join (inner join, any type of join method) bv_wo_customer table, from an Oracle-JDBC based source, with bb_cc_service_call, from an MS Access-ODBC based source, by commo...

Answers: 1

ODBC Access JDBC join

Adding Logic to Join View
answered 18-09-2017 08:47:01 -0400

Hello, I am having some issues designing a solution to a feature that I need to create. Scenario: I have a data set with a specific field that needs to be modified when a condition true is passed in from the web service and not modified when a condi...

Answers: 1

VQL REST join Logic Web Service

All joins are executed when creating Star Schema
answered 13-03-2017 21:27:54 -0400

Hi Team I am having a star schema with 1 fact and 5 Dimensions .I created a view and Checked the data through Denodo. If I pull form column from 1 Dimension and one fact measure only small query should be fired against the Database and give me result...

Answers: 3

DENODO join

multiple joins lead to nesting behavior
answered 15-12-2016 05:37:48 -0500

Best practice in de model-desinger for building multiple joins from one driving table (A), it is going to nest joins. From one driving table two LEFT JOIN's (B, C) and normal joins (A+D) always result in some nesting behavior. Should this be put in as ...

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

join