You can translate the question and the replies:

Lookup - Informatica PowerCenter

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.
Informatica lookup DENODO
user
31-01-2018 13:58:33 -0500
code

1 Answer

Hi, When you have the Source qualifier and Lookup on the same machine it is recommended to use the source qualifier. Also when using source qualifier operation happens at the data source layer and not in the Informatica layer. This is the reason as to why Denodo views selected as source qualifier performs better. Also, this looks like an issue in the Informatica layer and hence you can refer to the Informatica Power Center support team. Hope this helps.
Denodo Team
09-03-2018 05:31:32 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here