We basically had central tables for data enrichment, this was to ensure global deduping and no enrichment was done repeatedly is different tables.
We made pre-set templates, where the data would be written to the single processing table, enriched and then we get it back via lookup.