I have a request for some data to flow through QualityStage with no case changes. I have the odbc format convert from Oracle, transfer, preprocess and standardize stages all preserving the original case. However, when I run the match and create the extract, the case is converted to all caps. I can, of course, get around this by not doing a moveall, but just moving the unique identifier fields and then sending the match extract AND the proper case stan file back to oracle and joining them there - but what a pain..isn't there a way to tell the match stage to preserve case?
QS 7.5 on unix/oracle datadirect ODBC
Pinned topic undup match stage not preserving case
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2008-07-07T11:54:14Z at 2008-07-07T11:54:14Z by SystemAdmin
Ray.Wurlod 12000063JK18 Posts
Re: undup match stage not preserving case2008-06-06T03:02:06ZThis is the accepted answer. This is the accepted answer.None that I know of. However, you can carry the original data through the match, or set it aside and join it later. That may be useful to you.
SystemAdmin 110000D4XK533 Posts
Re: undup match stage not preserving case2008-07-07T11:54:14ZThis is the accepted answer. This is the accepted answer.I don't believe the match stage is causing this problem. Can you isolate the stage into a seperate Job with a input file that you know has mixed case and test.