Hi Team, We are facing issues while fetching data from Oracle DB, which is taking longer time than usual. When checking with DB team, they suggested to use below(with parallel option) while running a select command. I tried to run the same manually an...
Answers:
1
I am running Denodo Virtual DataPort Administration Tool using a Virtual Machine. When I combine the data using a join method and retrieve all the rows from the join, it takes approximately 24 minutes to return ~6.6M rows. I have attached the Tree View...
Answers:
1
We have defined some excel datasources that resides in a FTP server and Denodo BVs are created on top of them. We have a requirement to put the last modified/update date of each of the files (coming from different sources at different time). Is there a...
Answers:
2
Hello, I need to connect Denodo to the specific folder on the Unix server, so I can use flat files as a datasource. Our security team only permits non-interactive login. Is there a way to connect Denodo to the Server non-interactive, and how that con...
Answers:
1
Hi, I can't execute a job in the scheduler because "dataSource 'PRE_CD2'. authentication error: The username or password is incorrect" I've configured in 'Data Sources > New Data Source > VDP' the PRE_CD2 which has the correct 'Connection URI' ...
Answers:
1
While selecting columns with space in column names from denodo , informatica bdm is throwing error as such a column doesnot exist.
Answers:
1
when i am calling http://localhost:9090/denodo-restfulws/ from python request,porst() it throws a 401 not authorize error. how can i pass username and password here?
Answers:
1
Hi, Is there a way to optimize a join from Excel that has 1.7M registers with other one that has 25M registers. The problem here is it takes longer than 15 minutes so it times out. Any suggestions? Thank you, Best regards.
Answers:
4
When applying custom i18n mapping to existing views and setting the custom i18n mapping as default we made these changes: To create custom I18N mapping CREATE MAP I18N i18n_us_est_custom ( ‘country’ = ‘US’ ‘datepattern’ = ‘MM/dd/yyyy’ ‘datesubtypepat...
Answers:
1
Getting erorr: Unable to establish connection: The JDBC driver was not found. The Denodo Platform does not include the JDBC driver for this adapter. Copy the jar files of the driver to the folder "<DENODO_HOME>/lib-external/jdbc-drivers/hive-2.0...
Answers:
1