Question: what is the difference between lookup and joiner in informatica?
Answer: A joiner is used to join data from different sources and a lookup is used to get a related values from another table or check for updates etc in the target table. for lookup to work the table may not exist in the mapping but for a joiner to work, the table has to exist in the mapping. pal.