Q&A

Create a birmap indexes in a remote table
answered 15-02-2021 06:26:37 -0500

Hi, Is there a way to create a bitmap index in a remote table ? Pierre SANGUINETTI

Answers: 1

remote table Index

Configure Bulk data load API for databricks source in denodo 8.0
answered 15-02-2021 05:49:28 -0500

Would like to know how to configure bulk data load API for Databricks source in denodo 8.0. I have gone through the Bulk data load API docs for Databricks, spark and impala. But I didnt understand how to configure it. Can you please let know the step b...

Answers: 1

bulkload Bulk Data Load databricks Spark

Use of Interpolation variable with multiply function
answered 15-02-2021 04:38:04 -0500

Hi Team, Can you please provide me syntax how to use mult function i have a requriment with interpolation variable like this in teradata: Query1: 1.where "Count" <= (@EmployeeCount 60) i tried like this : 1."Count" <= mult(@EmployeeCount,60) 2....

Answers: 1

mult func

Not able to execute the generate_stats..getting timeout..
answered 15-02-2021 01:59:25 -0500

Hi Team, I am trying to execute the procedure call GENERATE_STATS('view_name'); calling some 18 baseviews... Info: begin batch execution Info: number of jobs: 18 Command #1 ..... OK Command #2 ..... OK Command #3 ..... OK Command #4 ..... OK Command...

Answers: 2

Bring rules of the tables to base views
answered 12-02-2021 03:48:37 -0500

we have implemented security on tables in sql server ...we are using denodo 7.0.when we import the tables to create the base view do they bring them all or do we need to recreate them all again in denodo ? the denodo security doc dont have any comments...

Answers: 1

Access Denodo Express DENODO

How to ftp the flat file from local to Denodo shared folder.
answered 11-02-2021 07:24:02 -0500

we need to move the faltfiles whish are the datasources of some baseviews from dev shared folder of denodo to test env. now we copied the file manually. Going forward we would like to go with ftp. I see in tutorial, direction is been provided for ftp s...

Answers: 1

How to export the meta data and resource files with more granularity?
answered 11-02-2021 06:59:35 -0500

Hi Team, We are documenting the procedures for Denodo 7.0 to Denodo 8.0 product upgrade. We are planning for phased migration. We don't want to export the entire meta data as a whole but we would like to split it in several sprints. Say few application...

Answers: 1

#Denodo8.0_Product_upgrade #Export_metadata #Export_Resource_File

Passing Multiple values to multiple parameters in a REST API - Error
answered 11-02-2021 06:44:27 -0500

System Details : Denodo 7.0 - Windows 10 Operating system Query Topic : Passing multiple paramters and multiple values in REST API Web Service through URL Issue : While trying to pass multiple values to the multiple input paramters of REST API throug...

Answers: 1

REST API Multiple values multiple Parameters

Unable to establish connection: ORA-00018: maximum number of sessions exceeded
answered 11-02-2021 05:17:17 -0500

Hi Team, I am getting the below error message while connecting to the Oracle datase. Unable to establish connection: ORA-00018: maximum number of sessions exceeded

Answers: 1

How do I modify input parameters of a created base view?
answered 10-02-2021 07:02:22 -0500

Input parameter values are entered when creating a base view from a linked data source. Is there a way to modify the parameters values of an existing base view?

Answers: 1

Custom Connector