> > 1 word. Oracle. > > This is really why database software exists. I know > this probably > didn't help much, but if this is more than a one > time occurrence a real > database ought to be considered. > > You might start by checking out any reference > material on how large > database systems handle this sort of thing, as that > is exactly what you > are trying to mimic. >
We are trying to load date into teradata [which is data warehousing, stores Terabytes of data, and which is 10 times faster than any other database..) before loading data into Teradata, we need to do some massaging on data..basically eliminating..duplicate rows and invalid rows... __________________________________________________ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
