Re: data cleansing: externally or internally?
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 4 Nov 2011 11:33:23 -0700 (PDT)
Message-ID: <793768.592.1320431603692.JavaMail.geo-discussion-forums_at_yqhd1>
Robert has listed some good points. The devil is always in the details. What does 'dirty' mean in this context. Is the data dirty cause someone had the shift key depresssed when he or she tried to enter a numeric digit or it is dirty because a related reocord or table row (FK) does not exist for some of the data? Perhaps both conditions are true.
Date: Fri, 4 Nov 2011 11:33:23 -0700 (PDT)
Message-ID: <793768.592.1320431603692.JavaMail.geo-discussion-forums_at_yqhd1>
Robert has listed some good points. The devil is always in the details. What does 'dirty' mean in this context. Is the data dirty cause someone had the shift key depresssed when he or she tried to enter a numeric digit or it is dirty because a related reocord or table row (FK) does not exist for some of the data? Perhaps both conditions are true.
You may in fact want to filter the data via shell scripts for some of the issues and then use Oracle tools for other issues.
HTH -- Mark D Powell -- Received on Fri Nov 04 2011 - 13:33:23 CDT