DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
vamsi_4a6
Participant



Joined: 04 Jun 2014
Posts: 95

Points: 1072

Post Posted: Mon Nov 02, 2015 6:46 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
i am trying to understand the rule set.stuck up with following questions.
USNAME RULE set:
classification:
;;QualityStage v8.0
\FORMAT\ SORT=Y
;-------------------------------------------------------------------------------
; USNAME Classification Table
;-------------------------------------------------------------------------------
; Classification Legend
;-------------------------------------------------------------------------------
; A - Abbreviations (Misspellings)
; C - Common Words
; F - First Names
; G - Individual Name Generations
; I - Initials
; L - Last Name Prefixes
; O - Organization Name Suffixes
; P - Individual Name Prefixes
; Q - Additional Name Qualifiers
; S - Individual Name Suffixes
; W - Organization Name Words
; Z - Delimiters
;-------------------------------------------------------------------------------
; Table Sort Order: 51-51 Ascending, 26-50 Ascending, 1-25 Ascending
;-------------------------------------------------------------------------------
;END ENDOWMENT W
AN AN C
AND AND C
AS AS C
AT AT C
BY BY C
FOR FOR C
FROM FROM C
IN IN C
OF OF C
ON ON C
OR OR C
THE THE C
TO TO C
WITH WITH C
AARON AARON F
ABBEY ABBEY F
ABBIE ABBIE F
ABBY ABBY F
ABDUL ABDUL F
ABE ABE F
ABEL ABEL F
ABIGAIL ABIGAIL F
ABRAHAM ABRAHAM F
ABRAM ABRAM F
ADA ADA F
ADAH ADAH F

Doubt 1 :what is the meaning of below code in classification?

ABIGAIL ABIGAIL F
ABRAHAM ABRAHAM F

doubt2 :Dictionary File code is not clear.it would be better if someone explain code for each block.

Example:
;-------------------------------------------------------------------------------
; Business Intelligence Fields
;-------------------------------------------------------------------------------
NameType C 1 S NameType ;0001-0001

;-------------------------------------------------------------------------------
; Matching Fields
;-------------------------------------------------------------------------------
MatchFirstName C 25 S MatchFirstName ;0203-0227
------------------------------------------------------------------------------

;-------------------------------------------------------------------------------
; Reporting Fields
;-------------------------------------------------------------------------------
UnhandledPattern C 30 S UnhandledPattern ;0420-0449
UnhandledData C 100 S UnhandledData ;0450-0549
InputPattern C 30 S InputPattern ;0550-0579
ExceptionData C 25 S ExceptionData ;0580-0604
UserOverrideFlag C 2 S UserOverrideFlag ;0605-0606

;-------------------------------------------------------------------------------
; USNAME Dictionary File
;-------------------------------------------------------------------------------
; Total Dictionary Length = 606
;-------------------------------------------------------------------------------
; Business Intelligence Fields
;-------------------------------------------------------------------------------
NameType C 1 S NameType ;0001-0001
GenderCode C 1 S GenderCode ;0002-0002
NamePrefix C 20 S NamePrefix ;0003-0022
FirstName C 25 S FirstName ;0023-0047
MiddleName C 25 S MiddleName ;0048-0072
PrimaryName C 50 S PrimaryName ;0073-0122
NameGeneration C 10 S NameGeneration ;0123-0132
NameSuffix C 20 S NameSuffix ;0133-0152
AdditionalName C 50 S AdditionalName ;0153-0202
;-------------------------------------------------------------------------------
; Matching Fields
;-------------------------------------------------------------------------------
MatchFirstName C 25 S MatchFirstName ;0203-0227
MatchFirstNameNYSIIS C 8 X MatchFirstNameNYSIIS ;0228-0235
MatchFirstNameRVSNDX C 4 Z MatchFirstNameRVSNDX ;0236-0239
MatchPrimaryName C 50 S MatchPrimaryName ;0240-0289
MatchPrimaryNameHashKey C 10 S MatchPrimaryNameHashKey ;0290-0299
MatchPrimaryNamePackKey C 20 S MatchPrimaryNamePackKey ;0300-0319
NumofMatchPrimaryWords C 1 S NumofMatchPrimaryWords ;0320-0320
MatchPrimaryWord1 C 15 S MatchPrimaryWord1 ;0321-0335
MatchPrimaryWord2 C 15 S MatchPrimaryWord2 ;0336-0350
MatchPrimaryWord3 C 15 S MatchPrimaryWord3 ;0351-0365
MatchPrimaryWord4 C 15 S MatchPrimaryWord4 ;0366-0380
MatchPrimaryWord5 C 15 S MatchPrimaryWord5 ;0381-0395
MatchPrimaryWord1NYSIIS C 8 X MatchPrimaryWord1NYSIIS ;0396-0403
MatchPrimaryWord1RVSNDX C 4 Z MatchPrimaryWord1RVSNDX ;0404-0407
MatchPrimaryWord2NYSIIS C 8 X MatchPrimaryWord2NYSIIS ;0408-0415
MatchPrimaryWord2RVSNDX C 4 Z MatchPrimaryWord2RVSNDX ;0416-0419
;-------------------------------------------------------------------------------
; Reporting Fields
;-------------------------------------------------------------------------------
UnhandledPattern C 30 S UnhandledPattern ;0420-0449
UnhandledData C 100 S UnhandledData ;0450-0549
InputPattern C 30 S InputPattern ;0550-0579
ExceptionData C 25 S ExceptionData ;0580-0604
UserOverrideFlag C 2 S UserOverrideFlag ;0605-0606
rjdickson
Participant



Joined: 16 Jun 2003
Posts: 378
Location: Chicago, USA
Points: 2531

Post Posted: Mon Nov 02, 2015 9:50 am Reply with quote    Back to top    

Hi,

Answer to question 1:
Please see [url]http://www-01.ibm.com/support/knowledgecenter/#!/SSZJPZ_11.5.0/com.ibm.swg.im.iis.qs.ug.doc/topics/c_CLS_file.html[/url]

Answer to question 2:
Please see [url]http://www-01.ibm.com/support/knowledgecenter/#!/SSZJPZ_11.5.0/com.ibm.swg.im.iis.qs.ug.doc/topics/c_Dictionary_file.html[/url]


I hope this helps!

_________________
Regards,
Robert
Rate this response:  
Not yet rated
vamsi_4a6
Participant



Joined: 04 Jun 2014
Posts: 95

Points: 1072

Post Posted: Mon Nov 02, 2015 9:55 am Reply with quote    Back to top    

Thanks for Input.For Dictionary file what is meant by business, matching, and reporting fields
Rate this response:  
Not yet rated
rjdickson
Participant



Joined: 16 Jun 2003
Posts: 378
Location: Chicago, USA
Points: 2531

Post Posted: Mon Nov 02, 2015 11:55 am Reply with quote    Back to top    

Hi,

Just a textual description ('Documentation') of the intent for those output columns.

Robert

_________________
Regards,
Robert
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54535
Location: Sydney, Australia
Points: 295717

Post Posted: Mon Nov 02, 2015 4:35 pm Reply with quote    Back to top    

The Business Intelligence fields are typically derived from the input and are likely to be transferred through to final output. The Matching fields are more likely to be used to drive Matching an ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours