DSXchange

Hello I am using MNS stage to parse address informations as shown below but apartment part is going to unhandled text column. input: 501 S BEVERLY DR #241 output: 501 S BEVERLY DR unhandled text column : 241. I need output like : 501 S BEVERLY DR 241 Is there a way I can capture 241 value and put it...

Yes, I handled this in transformer stage.

Thanks

Hi I am using VPHONE ruleset to standardize USA phone numbers. But It is working fine for only 10 digits phine numbers. I need to handle the data when I receive the data like 1-800-934-6489 1800-934-6489 since it has more than 10 digits, invalid Phone is generating. Any suggestions are appreciated ~...

Is it possible to standardize the international individual/organization names in a common stage. ? Like MNS stage for international addresses.

Thanks for the response. here is sample data Input - City :MISSISSAUGA state:ON country_Code: CAN Output - ISOCountryCode_Country = US IdentifierFlag_Country = N I've provided three input columns to Country rule set, but the rule set couldn't understand and defaulted to 'US'. Is there anything I am ...

I m trying to identify the internation address country code using Country rule set in standarization stage. I also specified ZQUSZQ in literal and moved to selected columns as shown below: Input_Column <literal> ZQUSZQ But after executing the job the output columns are like below ISOCountryCode_COUN...

I have a few Db2 SQL queries to see the results. Is it possbile to run queries using informatin Analyzer 8.5 tool and generate the report. ?

Thanks for your reply.

Is it possible to change the status for multiple columns at a time. ?

Apperently, not possible but just want to make sure that I m not missing the fecility in the tool.

Hello, I've done column Analysis using information analyzer. Now I'm trying to review the analysis in Frequency distribution -> 'domain & Completeness'. since I have millions records, its hard to go thru every entry. Is there a way to write a condition for each column and get the review done. li...

Hi

Is it possbile to standardize international phone Numbers using IBM Qualitystage 8.5 ? If yes what is the process ? Any helpful thoughts or answers are appreciated.


Thanks
Arun

Hi

Can we analyze the data from a flat file source using information Analyzer (8.5) ?

All the system requirements are passed (No failures or warnings). Then, the installation was started.

however, I'll check with official sevice provider.

Thanks

Middle of the installation a small window is poping up, which contains above error and Resolution. Resolution has below options. 1. Retry install 2. Continue installation 3. Exit installtion. if I choose 1 or 2 options, the error is repeating. This is the only information I have from the installatio...

Hi I am trying to install information server on Linux mechine and facing the below error. CDIIN5106I: Details: ModelDeployAction ( _nsURI = SubstitutableValue: Token="http:///com/ascential/xmeta/model/1/XMetaSystemInfo.ecore", Value="http:///com/ascential/xmeta/model/1/XMetaSystemInfo...

After rebooting the Linux box it worked fine.

Thanks