SQL Performance through ODI

Good morning, all

We have a SQL insert that is generated by ODI to load a table in our warehouse. We are selecting from a view across a database link to pull data back to our data warehouse. The entire load runs in about two minutes - great! However when we moved the view (and the tables on which it relies) over to the warehouse database where the load is running, the load takes about an hour.

When we do a direct select * from the view across the database link, it runs in 2-3 minutes. When we do a direct select from the view on the warehouse database, we had to kill it after an hour.