One Star

Target as lookup table

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
3 REPLIES
One Star

Re: Target as lookup table

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

Re: Target as lookup table

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
One Star

Re: Target as lookup table

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