Q&A BY TAG 'DENODO'

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

Pagination
answered 08-02-2018 06:39:11 -0500

Hi Team, Where can I find study material on pagination for REST HTML WS ? I tried to use "$count" parameter to get total number of rows as described in below url, but i receive an error - "There was an error while generating this response: Code #11...

Answers: 3

DENODO

Denodo cache Refresh using Tidal Scheduler
answered 05-02-2018 07:23:42 -0500

Hi, Version - Denodo 6.0 We have applied FULL Cache on most of our views and we need to refresh cache on a daily basis but, we dont want to use Cache Scheduler. We plan to use Tidal scheduler which is the enterprise scheduler at our client site for al...

Answers: 1

Denodo Scheduling Tidal

Page By/ Group By email Reports in Denodo Scheduler
answered 29-12-2017 07:24:23 -0500

Hi Team, If the view shows records in below tabular fashion: | Id | Name | Department | | 1 | John | Finance | | 1 | John | Accounts | | 2 | Maria | HR | | 2 | Maria | Facilities | | 3 | David | Legal | Is it possible to send seperate email reports ...

Answers: 1

DENODO Denodo Scheduler 6.0

Denodo error when creating/updating view.
answered 28-12-2017 04:49:22 -0500

Hello guys. I faced with issue when trying to delete/update some derived view (and its base view/table/wrapper), the following logs are from denodo: 14460953 [RMI(30959)-10.111.111.222-4929] FATAL 2017-10-18T08:36:24.281 com.denodo.vdb.interpreter.ex...

Answers: 6

denodo

Make input parameters optional when importing a SQL Stored Procedure
answered 08-11-2017 06:55:56 -0500

Hello, I have a Stored Procedure in SQL. I imported it into Denodo and made a RESTful service from it. Here I am seeing all the input fields as required in the service. I want to make all the input fields as optional and if I don't give any value to t...

Answers: 1

Denodo REST API Stored Procedure

Finished with error: No search methods ready to be run. The following fields are obligatory:
answered 23-10-2017 09:57:39 -0400

Hi, Created one customized Base view. On top of that created selection view with parameter (from view parameter option; Passed teh default value as well). In where condition pass this parameters like: "BV_fact_table"."TC_D_TXN_VALUE_AS_OF_DATE" >=...

Answers: 1

Denodo

Need to delegate the date column's data into two different databases-Hadoop and Oracle, but facing issue.
answered 23-10-2017 09:56:53 -0400

Hi Team, Scenario is like that: I have a Union View which is based on Hadoop+Oracle. Now, when I am mentioning any date condition like 'dd-MON-yy' (while executing), I am getting the result from Oracle but from Hadoop( Impala) I am not getting any re...

Answers: 1

DENODO

How to Delegate to_date function instead of to_timestamp into Oracle DB-at runtime
answered 23-10-2017 09:31:53 -0400

Hi, I created base view with interpolation variable (where expression) where I am passing “where” condition at runtime. But when I am passing the date value from denodo, from execution plan I do see the date value is converting to timestamp always and...

Answers: 3

DENODO

No search methods ready to be run
answered 18-10-2017 07:46:54 -0400

Hi, I created base view. On top of that created selection/derive view and there I created parameter. That parameter I used in join codnition with respective field. But when I am running that selection view by passing parameter below error is coming; ...

Answers: 1

DENODO

Is it possible to create volatile table(temp table) in teradata via Denodo?
answered 12-10-2017 02:59:25 -0400

I was trying to create a baseview in denodo by using the below query. i am getting an exception com.denodo.util.exceptions.InternalErrorException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.35] [Error 1077] [SQLState HY000] executeQuery() cannot be us...

Answers: 2

teradata DENODO