Hello everyone!
I’ve successfully completed ETL processes for two datasets from two different hospitals, with the goal of harmonizing them for joint analysis. For the ETL procedures, I used the open-source repository provided by The Hyve (https://github.com/thehyve/ohdsi-etl-prias).
Now, I’m wondering what the best approach is to combine the results of these two ETLs. Should I merge all harmonized data into a single schema, or is it better to maintain two separate schemas for each dataset and perform the same research question in two steps?
I would appreciate any advice or best practices on how to proceed with this!