Hi,
In my job after using standardize stage (USNAME rule set) I want to use match frequency stage.So after standardize stage I am using a transformer(according to Quality stage tutorial) where I am creating a column named MatchFirst1(Varchar1,Nullability yes).
The derivation of this field is
If isNull(Standardize.MatchFirstName_USNAME) then Setnull() Else Standardize.MatchFirstName_NAME[1,1]
Then this column along with other original i/p columns(Name,Addr) is input to the Match frequency stage.The o/p is fine.
But if I don't derive the column MatchFirst1 and input the original fields only to the match frequency stage then the error comes "MatchFirst1 not found".
Can you please explain why this column is required?
In the derivation of that field instead of MatchFirstName_USNAME column if I use any other column of rule set o/p(eg:AdditionalName_USNAME) then also it is working fine.
What is the significance of creating this column.Please give your thoughts
.
Thanks in advance
Shaonli
Error using Matchfrequency stage in qualitystage job
Infosphere's Quality Product
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration