How to do a jdbc lookup based on a string in the Sender file name?.
For example Sender file name is NYC1010st.csv and CAL2010st.csv
I need to determne dynamically to go to different systems to get data. If NYC then call to System X , If CAL call another system to get data.
My scenario is MATMAS --> XI ---> FTP. Within XI I need to do jdbc look up based on above criteria.
Thanks for any siggestions and help and is appreciated.