DSXchange

I've never faced this issue. I haven't had the chance to use the new XML stage yet. But I DID read your post. I read every post. When I have nothing to add, I usually add nothing.

Use any UML editor. That's what UML is for. There's plenty of them out there, some are even free, some are free for non-commercial use.

You also get them in title bars. For the moment learn to live with them. If they are causing panic attacks in your organization, log a PMR with IBM.

I'd do it all in user-defined SQL using the appropriate stage type to connect to your particular database.

You probably need to buy/licence the SAP R/3 Pack from your reseller.

Specify Unicode, write to a text file, view using a hex display utility (for example UltraEdit).

Maybe mark the target string extended property as Unicode.

Otherwise find out which character is not being handled as ASCII in your data, and handle it appropriately.

The first thing to observe is that not every VarChar can be converted to Integer, so you probably need to use an IsValid() function to test whether the string you have is a valid integer. That done, there are a couple of ways you could effect the conversion, for example StringToDecimal() with the De...

You can always create alias columns, for example in a Transformer stage.

Yes, the "process" is to build a Rule Set. Begin by documenting all the known variations (for example Indian phone numbers are always 10 digits long, but the area code can be anything from 2 to 5 digits of that. Country codes vary from one to four digits. You might consider a lookup table ...

You'll also find that the address rule sets in QualityStage can also handle the #1801 construct correctly. You might consider using these rather than the AVI stage. Or using both.

Working well at both of my current sites. In both cases, though, the virtual machines are hosted on heavy-duty hardware.

Glossary import/export doesn't need a bridge. Bridges are for, basically, non-IIS things like BI reports, data models, etc.

There's nothing in any of the out-of-the-box DataStage stages that allows this functionality. But you could create your own custom stage to incorporate your requirements.

Search in BG has Options one of which, I am fairly certain, does allow the abbreviations to be searched. That's in BG; I don't know what options are available for the Cognos search. To answer your subject question, these fields are to allow two abbreviations to be defined for a term. For example the...