TableA loads with a where clause 'where date > '1/1/2011'' and TableB is join to TableA. TableB is huge and linked to TableA by ProductID. Now i would only want to load only relevent fields to reduce the load time.Any help please!
If I understand correctly, you concatenate a few fact loads and then want to join rows from table PUB.uwm120 on field [Policy Number]. uwm120 is large so it takes a long time to pull down all the rows and you only need a subset of rows for the join.
You could move the join into the SQL so the join happens at the DB Server. That should speed things up. Since you are concatenating unlike columns, it may be easiest to add the umw120 join to each of the fact SQL SELECTs.
I do not have access to the DB, only interfacing. Could you please illustrate the latter part "Since you are concatenating unlike columns, it may be easiest to add the umw120 join to each of the fact SQL SELECTs".