topic Target as lookup table in Talend Studio

Target as lookup table

_AnonymousUser — Sat, 16 Nov 2024 13:09:11 GMT

Hi,
Can we use target table as a lookup table in the same job. (Like Dynamic cache in Informatica).
Can anyone suggest please.
Thanks,
Vijay

Re: Target as lookup table

Anonymous — Mon, 10 Jan 2011 17:05:49 GMT

Yes, you can.
I assume you are trying to determine which row to update and which to insert based on lookup against target table?
Just connect your table to tMap AFTER you connect the first table your geting the data from.
Peter.

Re: Target as lookup table

Anonymous — Mon, 10 Jan 2011 17:37:42 GMT

Hi,
The equivalent to dynamic look up of Informitica is:
use tmap:
Select reload at each row with cache enabled. (check the documentation for how to)
Do not forget to create a connection for the lookup and reuse this connection otherwise it will create a connection for each row of the main.
You can refer to the webinar
http://www.talend.com/webinar/archive/index.php
in french:
Adaptez vos processus d'intégration de données pour gérer de très gros volumes de données
in english:
Tune data integration processes to handle massive data volumes
benjamin

Re: Target as lookup table

_AnonymousUser — Wed, 09 Mar 2016 04:51:20 GMT

Hi,
The equivalent to dynamic look up of Informitica is:
use tmap:
Select reload at each row with cache enabled. (check the documentation for how to)
Do not forget to create a connection for the lookup and reuse this connection otherwise it will create a connection for each row of the main.
You can refer to the webinar

in french:
Adaptez vos processus d'intégration de données pour gérer de très gros volumes de données
in english:
Tune data integration processes to handle massive data volumes
benjamin

Re: Target as lookup table

jrpatel12 — Wed, 27 Mar 2019 05:38:55 GMT

What is the meaning of the below statement? If possible could you please elaborate?

Do not forget to create a connection for the lookup and reuse this connection otherwise it will create a connection for each row of the main.

Re: Target as lookup table

jrpatel12 — Wed, 27 Mar 2019 05:40:30 GMT

Hey, could you please elaborate the below statement? I'm not able to understand this.

"Do not forget to create a connection for the lookup and reuse this connection otherwise it will create a connection for each row of the main."