How to combine data from multiple ODS
I need to lookup data in multiple ODS. Instead of coding multiple select statements, I was thinking that I might create a view on multiple ODS and then do one lookup on the view. Is that a way to go or I should consider doing something else?
Apreciate your input.