View Single Post
  #2 (permalink)  
Old December 23rd, 2005, 05:11 PM
David_the_DBA David_the_DBA is offline
Friend of Wrox
Join Date: Dec 2005
Location: , AZ, .
Posts: 146
Thanks: 0
Thanked 1 Time in 1 Post


You said you hope that your post makes sense, and since I can get the general feel for what you are doing, even if I can't make sense of the details I am going to recommend an alternate approach.

Rather than trying to a complicated transform I find it easier to setup a staging table (identical structure to the source table) in the destination database. Then Use the Data Pump Task to Pump the data into the staging table without transforms, but using the criteria in a where clause to limit the data. Then once you have the data in your staging table you can do joins to your lookup tables and accomplish your transformations using an insert select statement instead of a data pump task.

David Lundell
Principal Consultant and Trainer