Latest Activity

code

What is the impact of replacing a view (Wrapper\Table)?

What exactly happens when CREATE OR REPLACE WRAPPER and\or CREATE OR REPLACE TABLE is executed? I'm supposing it will lock the view for a short amount of time, milliseconds, queries depending on this replaced view will be delayed.

Quary execution

code

Same Query Returns different number of records in Baseview and Derivedview

Hello Team, I have created 2 baseview(bv_studies, bv_results) of dfferent sources in Denodo. After that, I have created one derived view(dv_final) from these baseview with Inner Join. I am passing 2 parameters to bv_studies. Now the problem is, while ...

Quary execution Baseview derived view

code

How to execute a dynamic sql or a stored procedure for a view?

Hi, I used to create a stored procedure in cisco information server(CIS) to produce dynamic sql query. For example, few input params for query columns. However, I am told that I need to wrtie Java code for stored procedure in Denodo. Is it ture? I am ...

Quary execution Stored Procedure

code

unnamed private wrapper

Hi Denodo Team, I tried in IE, Mozilla,Chorme to attach an attachment or screen shot, but I could not able to do. Please help me on <unnamed private wrapper> in the query excution plan. I have table "A" and table "B" just joined and when I am try...

Quary execution

code

How query execute with Denodo

Hi I am new to this tool, I would like to know couple of things like, 1. how query is processed with Denodo ? 2. Would Dnodo push all functions(like TO_DATE in oracle) to database ? 3. Denodo translate query to under line DB language or we need to pro...

Quary execution