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 -
am i using it in right way - Standardize Stage
-
- Participant
- Posts: 33
- Joined: Tue Oct 21, 2008 10:29 am
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
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.
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.