That's exactly what I have done before and it worked well. You just have to ensure that you can map the data from the other database properly, and that the FDW you're using is of good quality (since they're not officially part of Postgres).