DSXchange

Hi everyone, I have one requirement.. I have created a sequence command in DB2 and I need to generate a running sequence no using the sequence option and to call it in transformer stage. Can anybody say how to pass the query and do the exercise. Note: I'm aware of system variables and how to use the...

[quote="ray.wurlod"]No idea at all. I have not seen your data, I have not seen your business rules that make those data "bad". So how am I expected to be able to know how to "fix" them? A totally unreasonable request. ...[/quote] hi ray hold on for a min i dint ask or r...

Thanks Ray and Stuart. I have done all the things that you both have sorted out,but out of my curiosity i'm just asking how to cleanse and correct the data values. thats it. Thanks for your comments bro

I understand the whole thing what you are trying to say Stuart. I take up the scenario and tell you in detail. Hope this helps to all the newbies. Take a column which contains 'Name' as data values consider for UK or US.( I know you would apply GBNAME or USNAME ruleset.) It has some valid and invali...

[quote="ray.wurlod"]No, because the detail will depend completely on just how the data are "mixed up". Do the QualityStage Essentials class to learn about using the xxPREP rule set (among other things). That said, my suggested approach will work "out of the box" - at le...

[quote="ray.wurlod"]That's exactly the kind of thing QualityStage does well. You can use your xxPREP rule set to lump absolutely every element into domain-specific single fields, and have the domain-specific rule sets ( ...[/quote] Ray, i understnd the scenario but can u put something to d...