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.