CONDITIONAL LOAD WITH JOIN

Hi all,

I need to load about 5 million rows into a table using SQL Loader from an amount of 10 million with the condition that some data is in a big lookup table (2 million rows).

To clarify, lets say that I have a PRODUCT table with the columns PRODUCT_ID, PRODUCT_DESCRIPTION Then I have a FACT table that should store all the products I sold with the following columns
DATE, STORE_ID, PRODUCT_ID, PRODUCT_DESCRIPTION Now, let's say that I receive raw data in files that contain the following info DATE, STORE_ID, PRODUCT_ID and I want to insert a record in my FACT table with
DATE, STORE_ID, PRODUCT_ID, PRODUCT_DESCRIPTION only if the product is "registered" in the PRODUCT table.

How could I do this knowing that I'm using SQLLDR to load the data and I have strong performance requirements. Received on Tue Jul 09 2002 - 21:58:48 CEST