Target as lookup table

[_AnonymousUser]

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

[Anonymous]

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.

[Anonymous]

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

[_AnonymousUser]

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

[jrpatel12]

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.

[jrpatel12]

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."