Standardizing Data with a Master FME Workspace
•Download as PPTX, PDF•
0 likes•1,788 views
The document discusses using a master FME workspace to standardize data from various sources into a single GIS database. It describes how the master workspace allows loading and updating data in a standardized, easier to maintain way. The key components that enable this are a standard data model, a data modeling tool like FME with generic transformers, and a reusable generic FME workspace that handles loading, updating and deleting records based on ID matches and CRC checks between source and target data.
Recommended
Recommended
More Related Content
What's hot
What's hot (20)
Viewers also liked
Viewers also liked (16)
Similar to Standardizing Data with a Master FME Workspace
Similar to Standardizing Data with a Master FME Workspace (20)
More from Safe Software
More from Safe Software (20)
Recently uploaded
Recently uploaded (20)
Standardizing Data with a Master FME Workspace
- 1. Producing Standardized Data Using a Master FME Workspace Victor Rutherford GIS Data Analyst, Developer April 25, 2012
- 2. Spatial Database Geomatics Vendor Vendor Cartography GIS Geology DB Geophysics Analysis Vendor Vendor Engineering
- 3. Loading and Updating Data - Unstandardized - Difficult to maintain - Confusing to use GIS DB
- 4. Master FME Workbench GIS DB (Custom) (Generic) Standardized
- 5. Magic Formula? 3 1 2 + + Standard Data Model Data Modeling Tool+ Generic FME Workbench Lookup table Attribute-mappings+ PSDM PSDM (domains) Master Manager FME Workspace
- 6. The Right Person ETL/FME I understand rocks, Corporate Standards Steward FME but what’s an Expert / Domain FME? Data Modeling Rocks! QA Data (Generic) Tool Modeling
- 7. Master FME Workspace (Look Ma, No hands!)
- 12. Match = No Change Source ID CRC Mismatch = Update Target ID Insert Delete?
- 15. Master FME Workspace Easier to Maintain Harder to Maintain
- 16. Master FME Workbench GIS DB GIS DB (Custom) (Generic) Standardized GIS DB
- 17. Thank You! Questions? For more information: Victor Rutherford vr@vrgs.ca victor_rutherford@nexeninc.com Nexen Inc. www.nexeninc.com VRGS Ltd. www.vrgs.ca
- 18. No ID/PK? Source ID Match = No Change Target CRC ID Mismatch = Insert Mismatch = Delete?
- 19. Published Parameters Source PSDM Parameters Output