Very helpful video. About your ETL example. The source [MDS].[mdb].[dimreseller] - Am I right that this comes from a subscription view in the MDS database on the Reseller entity?
@garrettedmondson10 жыл бұрын
Yes, you are correct [MDS].[mdb].[dimreseller] is simply a (subscription) view in the MDS Database. An ETL process should only access MDS data through subscription views created in MDS for that exact purpose.
@advent73246 жыл бұрын
Good content. But painfully demonstrated ! Understood what MDS was all about at end , but jumping about "all over the place" didn't make this easy viewing :(