The following M query references the SQL view (BI.vDim_Customer) via the staging query (AdWorksSQLServer) and does not apply any further transformations:
Customer Dimension Query
The customer query accesses the unique M record associated with the schema (BI) and SQL view (vDim_Customer) from the table produced by the staging query (AdWorksSQLServer). This record contains all field names of the staging table query including the Data field that stores the SQL view. Referencing the Data field of the M record retrieves the results of the SQL view.
Since no M transformations are applied, the M query reflects the source SQL ...
