Skip to Content
Former Member
Jul 01, 2012 at 04:51 PM

DB View



Need some feedback on this scenario.

I created a DB View in SRM for several internal/custom tables in SRM. Created the Datasource in SRM on top of that View and replicated in BI. When I was mapping fields in Transformations, I realised that I needed to add another table in that View. Now, If I went back to the SRM View and made those changes and activated the View, what needs to be done in order for those new fields to appear in the Datasource? There are no options to refresh the datasource so that it will reflect the changes in the VIEW. Any suggestions besides creating a new datasource on the view and do all the mappings again? Any help would be appreciated.