As mentioned in this post :
It is currently necessary to manually map all tables whenever a new promotion of a Prepare instance is done. This makes the use of multiple environments for DTAP tedious and unnecessary a lot of work. With each new release the amount of fields/tables could grow, leading to more overhead work for mapping. Since only 1 ODX could run per server isn't it a simple solution to just get a pop-up which asks if we would like to use the same Ingest instance or choose one? It can then automatically remap based on the new Ingest instance. Whenever a table or fields name doesn't match it could give us the same remapping table in which we can manually correct these or take other actions.
Please look into this, since I cannot see how the current process should work as it does.