Q&A

I wanted to confirm like is Minus operation going to be expensive for Denodo? So, if we have the given logic select table A NOT IN (table A join table B) and we are using MINUS operation to do the same, is this okay or do we have any other optimized...

Dear Team, I am trying to save the BLOB data in Netezza through Summary Creation but it is giving an error that "Error Calculating the Capacity". This is just a simple query. SELECT CAST('blob', 'helloasdfasdfasdf') AS text_to_blob_cast ,CAST('text'...

I have been trying to put row restriction to a derived view using role management restriction but it is not working. It seems I need to apply same condition for each individual user tagged to that role Can I please confirm if we can put row and colum...

If we need to filter daily or monthly state data for final view built in Denodo which is like joining to a date table with the daily/monthly columns to match the date and filter. The view will have good complexity with multiple joins/unions, so where d...

Hi, I have a question regarding how to perform an operation in Denodo. I have data in a base view (on a Snowflake data source) that looks like: | Order_number | Icd10_codes | Icd9_codes | | -------- | -------- | -------- | | 1001 | 100.1,101.2 | | | 10...

Hi I was following the tutorial https://community.denodo.com/tutorials/browse/basics/2fs5jdbc Errors and driver configuration https://imgur.com/a/cQXuLZR Any idea if the configuration on my end is wrong?

What happens if license/temparary license expires in existing envirnoment.

Is there a way to omit any server-specific parameters from the whole export of the Denodo design studio UI, such as 'com.denodo.vdb.vdbinterface.server.VDBManagerImpl.registryURL'. Additionally, we are aware that it may be excluded when exporting data ...

Hi Team, Currently I'm working Denodo 8 and using Power BI as a reporting tool. Data flows from left right as mentioned below. Data Warehouse -> Denodo Views (Views Created on DWH tables) -> Reports Created on Denodo Views. We are using ODBC an...

Hello Denodo Geeks, I am trying to extract certain text from a field in denodo using regular expression. To a certain extend I am able to acheive my target, but there a certain text values in the field that do not work as intented. Here is an example ...