Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - Standardize Stage in Quality Stage

asked Rams September 6, 2014 02:15 AM  

Standardize Stage in Quality Stage


1 Answers

answered By vishnoiprem   0  

Standardize Stage is one of the stage in quality stage, used to make the data into standardize format. After applying the investigation stage, we will move the data into the standardize stage to make the data into standardize format.In the standardize stage we will be applying the three types of standardization rules.

The Standardize rules are as below a) Domain preprocessor rule b) Domain specific rule and c) Validation Rule

Domain Preprocessor rule is the rule that rules are set do not perform standardization but parse the columns in each row record and each token into the appropriate domain specific column sets which are name, area, address like that.

Ex: Rules------ usprep -------ok

Some standard examples will be like

Name 1 John doe Name 2 123 clay field, brisbane Address 1 c/o smith james Address 2 West end 4000

Domain Specific Rules: These rules are rules that rules are set, we can check every individual domain level whether that data is valid or invalid. This is mostly domain specific rules set we an apply on three domains. They are name domain, address domain, area domain

Validation Rules: The validation rules are used to standardize, the common business data including data, name, emailid, phone number, social security number, credit card numbers etc We will be validating the data and reporting the error.

   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!