i was asked to build a data warehouse which uses SSIS to ETL data from 5-6 data sources
my main issue with my design is how do I deal with authorization control for the data sources being loaded into the data warehouse? I mean when I load all the data from all the data sources how do I segregate the data in the DW? So I get all data from finance separate from HR, etc.
I’m interested in the security best practice here