Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Source Mart Designer
Transcript of Source Mart Designer
Late-Binding Data Warehouse
Electronic Medical Record
EMR Source Mart
We'll see how Source Mart Designer is used to bring client data sources into a Late-Binding Data Warehouse.
The EDW Admin database stores all metadata in the data warehouse.
Client Data Sources
The EMR Source Mart contains the transformed column names we mapped using SMD!
EDW Admin Database
We transform the metadata by:
Here is where we map the source columns to the destination columns.
From EDW Admin, the Medication Table metadata is deployed to the EMR Source Mart - which is itself a database within the data warehouse.
This is Source Mart Designer (SMD)
The Medication Table:
We'll grab the metadata from the Medication Table and bring it into Source Mart Designer.
The Data Warehouse!
SMD saved the changes we made to the Medication Table in EDW Admin
We'll use SMD to bring one table from the EMR into the data warehouse
The "MedicationBASE" Table:
We use SMD to repeat the process for each source of data
These are the columns we brought over from the Medication Table.
Changing column names & adding a suffix onto the end
Standardizing column data types
Next we'll save the transformed metadata to our data warehouse!