Performance question for a query from an Oracle Financials db to a datawarehouse.

Hello

We have a need to transfer data from an Oracle db to a data - warehouse.

The transfer is based on a SQL Query with 15 tables. The tables are RA_CUSTOMER_TRX , AR_PAYMENT_SCHEDULES , ZX_LINES , RA_CUSTOMER_TRX_LINES_ALL etc

To give you an idea of the volume , the RA_CUSTOMER_TRX has around 170 million rows in it and we'll be querying for 1000 rows at the most each time.

From a performance point of view , is it better to run the query from the datawarehouse over a db link to all of these tables or to create a view in the Financials db based on the 15 tables and give access to the data warehouse via the view over a db link.