Q&A BY TAG 'join'

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

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


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


Getting error with un-clear error messagge in VDP
answered 18-10-2016 06:27:04 -0400

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

Answers: 1

VDP join derived view

error in using join
answered 12-09-2016 11:40:00 -0400

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

Answers: 1


Optimizing Join Operation on BAPI returning arrays
answered 30-03-2016 18:18:20 -0400

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

Answers: 2

BAPI join

Joining on a trunc'd date
answered 17-10-2014 13:54:46 -0400

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

Answers: 10

vdp join