Topic
2 replies Latest Post - ‏2008-07-07T11:54:14Z by SystemAdmin
SystemAdmin
SystemAdmin
533 Posts
ACCEPTED ANSWER

Pinned topic undup match stage not preserving case

‏2008-05-12T17:58:57Z |
Hello,

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?
Thanks,
-Beth Carey
QS 7.5 on unix/oracle datadirect ODBC
Updated on 2008-07-07T11:54:14Z at 2008-07-07T11:54:14Z by SystemAdmin
  • Ray.Wurlod
    Ray.Wurlod
    18 Posts
    ACCEPTED ANSWER

    Re: undup match stage not preserving case

    ‏2008-06-06T03:02:06Z  in response to SystemAdmin
    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
    SystemAdmin
    533 Posts
    ACCEPTED ANSWER

    Re: undup match stage not preserving case

    ‏2008-07-07T11:54:14Z  in response to SystemAdmin
    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.

    Regards,

    Stewart