Hello, I'm new to the Deonodo coummunity. I'm currently working on a poc using two Exel datasources I've created and built views on top of. I am trying to join two of these views together based on a field that contains a calendar quarter. In one field ...
Answers:
1
I am seeing some odd behavior with a derived view that is the result of a field with JSON data being turned into an array and joined back to the original data set and the flattened. if I do a select * (no where clause) of the resulting join (after th...
Answers:
2
I am having 3 tables - A, B, C. I need 4 kinds of output Case 1 : If condition 1 and 2 both not satisfied : Sel from A Case 2 : If condition 1 satisfies : Sel A. from A Inner Join B Case 3 : If condition 2 satisfies : sel A. from A Inner Join C Case ...
Answers:
2
If we have a schenario where results from two paginated APIs are to be JOINED. e.g. We have 1 million customers, and an API that returns 100 at a time. And another API that reutrn All Customer Orders, again 100 at a time, with no guarantee about what p...
Answers:
1
Hello, is it possible to solve the following scenario: I have two views with different sources, which I would like to join (a push-down is therefore not possible). I want to join these views and make them available for reporting. However, the reportin...
Answers:
1
Hello, I have following tree view: View / | \ View1 View2 View 3 | | | BV BV BV | | | DS DS DS The DS is a Web Service Datasource...
Answers:
1
Hi, I need help with a very specific use case. I have 2 different data sources and I need to create a base view from source A filtered by some values from another base view coming from source B. This values in the second view would be a hole column, ...
Answers:
5
Hi Team, I want to join 2 views.First view is created from Json file and second view is created from delimited files(Text Files) I need to join both of them on basis of one coloumn. This column can be easily written by specifying view name and then ...
Answers:
1
Hi, I observered a poor performance for a join between a jdbc type view and json array. individually when queried they are running fast but when we do a join it's performance degrades. Can you suggest how to improve performance ? Also i see 347 subp...
Answers:
1
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