Hi,
I will explain my need with a small example. I have a datamodel thats contains a table sources and a table items. items has a foreign constraint to sources. In my job I iterate over every source and getting information from the internet. This information will be saved to the table items setting the souce_id that is used in the current iteration.
I use the tMap inner join function for finding items, that are not already inserted. For this I join over an title column for the table items and the internet information. Every reject column is not in the table items and could be insert. The table items is huge. I need an alternative for simply loading all elements for the lookup.
Now I like to only lookup items for the current source. Beside that, I like to insert item even though the title is identical for two different sources, what will not work with my first approach.
How do I add a dynamic condition to a lookup statement for tMap?
Thanks in advanced,
Danny