I am a newbie to Talend/ java World. We are migrating from Informatica to Talend. We have a concept as "Unconnected Lookup" in Informatica, where you can refer lookup using function lookup(Key) and get corresponding value from the lookup. This function also can be used in if-else loop to connect multiple lookups or keys on the same lookup.
I can achieve if-else functionality in tmap component when I have different Keys for the same lookup; however, I cannot implement if-else logic when I have different lookups, due to connected lookup.
I can take a regular approach and put multiple splitters and tmaps to take care of each condition, but with 20-22 lookup, it's just very costly solution.
Can anybody please suggest any routine or component where above logic can be handled?
Thanks.Can I implement this logic on joining keys? i.e. if key from main flow does not found in lookup 1 then search in lookup2 with Key2 and so on.
there is no concept of unconnected lookup in talend. You will have to understand what the functionality of an unconnected lookup does and custom code it or use tmap.