Filtering rows with a Multi Phase data pump -
04-18-2005
, 09:02 PM
Hello All,
I get text files that have sensitive data like credit card numbers. We only
bring te last 4 digits. I need to filter some rows that are used for sales
demo purposes. For example 11111-2222-0987.
I could remove the rows after the source is loaded but then I also remove
valid customers whose last 4 digits are 0987.
What I would like to in the data pump is filter rows that meet a set of
values. If a row meets a value it is never brought through the data pump.
Any thoughts? |