Q&A

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

How to create self-referential data source?
answered 06-12-2019 15:28:28 -0500

Hello Denodo experts, I want to create a base view from query from a self-referential data source..how do I create this self-referential data source? Please advise. Thanks!

Answers: 1

Database Baseview DataSource

Updates failing in scheduler
answered 06-12-2019 02:51:05 -0500

I have designed a VDP job in schdeuler. I have two three columns in the MSSQL table and all three of them are part of primary column. In the exporter section of scheduler job I have set the config as below Delete table contents to false update tupl...

Answers: 2

VDP Denodo Scheduler 7.0 Export MSSQL

Is it possible to write back to a delimited file?
answered 05-12-2019 23:59:12 -0500

Working on denodo 7.0. Is there anyway where a base view created on delimited file (like csv file) can be used to insert data back into file?? Regards, Gopal Krishan

Answers: 1

Copy of the Database / Folder
answered 05-12-2019 23:56:46 -0500

Can we make the copy of the folder or database in the same environment in Denodo 6. The clients doesn't maintain the repository - to handle any changes - planning to make the copy of the existing views and make the changes in one copy which may help t...

Answers: 1

Duplicates

How to get "Result" values from jobs in Scheduler
answered 04-12-2019 12:20:49 -0500

We are trying to get the history detail for each job using the scheduler API. We are able to get the start time using the JobReport.getStartTime p.e. However, we are not able to get the "Result" values (COMPLETE, ERROR etc) for each execution in the ...

Answers: 6

#Scheduler #SchedulerAPI

Detailed test results with Denodo testing tool
answered 03-12-2019 19:07:25 -0500

How can we get a detailed test result with rows from both "Execution" and "Result" for rows which failed the test case. Right now we only get the number of row and the mismatch value, this result is difficult to decipher in cases where execution and R...

Answers: 1

Denodo TEsting Tool

avinash
answered 03-12-2019 10:54:48 -0500

ARS :: Same/Diff Sav Roles:: Same config for Parent & Delegate :: Request History ::Delegate not able to see Parents request , Also his own records are not appearing as per the Advanced Query

Answers: 1

Need 3 digits after decimal
answered 02-12-2019 21:19:11 -0500

Hi Team, I want to know is there any function in denodo just like to_number in oracle ,which can give me 3 digits after decimal. For example :Suppose in a column(let suppose amount) there are values like. 1.01 1.256 .355 1.1 Expected output 1.010 1....

Answers: 1

Same query run in different servers, one is fine and another has errors
answered 02-12-2019 16:29:31 -0500

When run a query, got below error: QUERY [VIRTUAL] [ERROR] QUERY [JDBC WRAPPER] [ERROR] QUERY [JDBC ROUTE] [ERROR] Received exception with message 'ORA-20000: Error in pkg_get_read_data.fn_pl_get_entity_detail ORA-01792: maximum number of columns in a...

Answers: 1