Q&A BY TAG 'Informatica'

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

Denodo to Informatica PowerCenter through DenodoODBC driver
answered 17-12-2019 22:19:18 -0500

Hi, I am trying to create a connection from Denodo to Informatica PowerCenter. I tried connecting with DataDirect 7.0 PostgreSQL Wire Protocol driver which was unsuccessful(the connection works locally and I was able to import Denodo data source in m...

Answers: 1

ODBC Linux Informatica

Getting SSL I/O errors while loading data from Denodo views using Informatica sessions
answered 14-06-2019 02:16:17 -0400

I am getting few SSL I/O errors in the Informatica session when I try to load data from Denodo view. The issue seems to go away when I try restart the failed session, but seeing this issue quite often. Do I need to make any configuration changes on De...

Answers: 3

SSL I/O error PostgreSQL Informatica

Lookup - Informatica PowerCenter
answered 09-03-2018 05:31:32 -0500

I hear regular complaints from my ETL team that Denodo Views selected as lookup is not performing well, they had to move it as source qualifier. Do you have any recomendataions on this before i get more details from my team.

Answers: 1

lookup DENODO Informatica

Any idea whether basic ETL transformations like aggregation, lookups, etc. are possible in Denodo Platform?
answered 24-04-2017 05:53:52 -0400

I need to know if possible, how do we perform basic transformations which are normally used in ETL tools like Informatica, SSIS, et al. Any suggestions, clarifications or corrections are welcome.

Answers: 1


Function 'current_setting' with arity 1 not found...
answered 31-01-2017 22:12:53 -0500

Hi all, we're trying to get Denodo and Informatica PowerCenter to talk. We have a simple SELECT..FROM query which runs correctly in the VQL shell, but when run from PowerCenter, it fails with the following error: "Function 'current_setting' with arity...

Answers: 1


Not able to import Denodo views as Data Source in Informatica Designer
answered 18-08-2015 14:01:27 -0400

I am not able to import Denodo views as data source in Informatica Designer. Have installed Postgre SQL ODBC driver 9.03.0300. I am able to login to Denodo database via the ODBC connector; but the Designer crashes every time when I try to select a Deno...

Answers: 1

PostgreSQL Informatica