User Activity

I need to mimic Informatica’s simple connected lookup process. I want to look for a record on a target table and if it exists, update it, otherwise insert it. I have tried to use the Lookup Snap, but I haven’t been able to make it work for me. Does...
My Oracle input is address information similar to: STREET: 123 MAIN STREET CITY: ANYTOWN STATE: ANYSTATE ZIP: 12345 COUNTRY: USA STREET: null CITY: OTHERTOWN STATE: OTHERSTATE ZIP: 54321 COUNTRY: CAN STREET: null CITY: OTHERTOWN STATE: null ZIP: null...
This may have been asked before, but I can’t find a solution. I need to extract the weekday name from the current date. In other words, today is March 8. I need ‘Monday’. Date.now().getDay() returns the number 1.