So, you have a bit of a situation here, trying to tackle unmapped master data management values in your ETL stream! Let’s take the specific example of general ledger accounts extracted from financial module of your ERP or transactional system.
How to provide options to the users to map unmapped GL accounts and get the updated mapping uploaded into the warehouse?
Let’s take a landscape with SAP BODS as ETL tool and Process Maker as the master data management tool. Here’s what happens next, as part of the solution:
- While the daily load happens the GL for which mapping are missing will be moved to a rejection table and a case id is generated for the same
- While inserting the records into the rejection table, BODS calls a webservice to access the process maker server to get the case id generated