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

Pinned topic undup match stage not preserving case

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

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?
-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
    18 Posts

    Re: undup match stage not preserving case

    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
    533 Posts

    Re: undup match stage not preserving case

    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.