Latest Activity

code

Joining JDBC and ODBC base views, fail execution (ODBC error)

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

ODBC Access JDBC join

code

Adding Logic to Join View

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

VQL REST join Logic Web Service

code

All joins are executed when creating Star Schema

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

DENODO join

code

multiple joins lead to nesting behavior

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

Related to: Denodo Query Optimizations for the Logical Data Warehouse

join

code

Getting error with un-clear error messagge in VDP

Hi, While I am adding a view and corresponding join into a derived view, its giving following error while saving the changes. "Unexpected error executing operation: Index:3, Size: 3" Can someone help me to interprete the error better and get it respo...

VDP join derived view

code

error in using join

I created a view it is working fine then i created a new view from previous one using group by this view is also working fine but when i join these two views it is giving error there are two fields where the error is coming if i remove that two fields ...

join

code

Optimizing Join Operation on BAPI returning arrays

Hi, I have one Bapi returning a single row where the output columns are arrays. input_param1, input_param2, t_header_array, t_order_array,t_another_array, t_another2_array As part of the transformation i need to flatten all the 4 arrays to add some...

BAPI join

code

Joining on a trunc'd date

We have a calendar view in Database A that contains a primary key "date_id" which is a date at midnight (ex: 10/15/2014). The view contains other rollup data such as week number, year, is holiday..etc. It is used primarily for warehousing. We have a...

vdp join