DSXchange

Hi,

I have a question about standardize stage -

I have two different tables, i took the two standardize stages to standardize the data.

input1->standardize1->output1
input2->standardize2->output2

when i opened a new process in standardize, i have 10 available columns.
But i need to use 5 columns to do standadize (lastname, firstname, DOB, Gender, Phoneno)

I have selected the relests after this the output window look like

Rules - columns

USNAMES.SET LAST_NAME, FIRT_NAME
VDATE.SET BIRTHDATE
VPHONE.SET PHONE_NBR

then i have selected the stage properties, i did selected the all columns from mapping tab and dragged those (56 columns) into right side window.

----my question is am i doing right way ?? if this is the rightway - how to select a rule for Gender ??

please reply back to me -

Yep, it sounds like you've got the right idea.
The 3 STAN's you specified seem fine, and as for the lots of output fields, you can copy over as many or as few as you like. It all depends on what you want to do with them afterwards..

As for gender, there is not a specific ruleset. You might have to just map them yourself in a transform rule or join to a mapping table, if they need it.
Creating even a simple ruleset for that might be overkill.

USNAME will also try to come up with a gender based on the name it STANs, so you may also try to compare what the Gender field says and what QS says.

Well, I think the best practice to standardize is using USPREP rule set.