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
This topic has been locked.
2 replies Latest Post - 2008-07-07T11:54:14Z by SystemAdmin
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
SystemAdmin 110000D4XK533 PostsACCEPTED ANSWER
Re: undup match stage not preserving case2008-07-07T11:54:14Z in response to SystemAdminI 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.