DSXchange

Hi All, When i read the date and time column from DB2/UDB API stage i see the date as 12436 (2002-01-17) for date and 58384 (16:13:04) for time column instead of 2002-01-17 for DT and 16:13:04 for Time.These columns are loaded into seq file and the rarget data looks like 12436 for Date and 58384 for...

Well .... The Country Rule set provides the two letters ISO country code , if it can be resolved from your data Dowstream, after resolving the ISO country code you should do a look up against a lookup table with ISO country codes and the country names to get the country name Thanks very much for yo...

Hi All,
Is there a way to asign county name for the given address record in QualityStage?

Thanks in advance.

QualityStage does not "correct" anything. However, if there exists another record with the same address, then probablilistic matching can take the spelling/transposition errors into account when matching them to identify potential duplicates. Address verification (for example CASS, or wha...

Hello All, I have a address field with value as 5500 parkmor rd calbasas 91301.But the correct address is 5500 parkmor rd calabasas 91302.Here both city name(calabasas) and zip(91302) are typo errors.Is quality stage smart enough to correct the city and zip?If so how can I do this in QS? Thanks in a...

Hello All, I am trying to implement the web services example http://www.ibm.com/developerworks/data/library/techarticle/dm-0703xiong/ and the wsdl for this example is http://soapclient.com/xml/googleSearch.wsdl .When I try to run this job I got the following error CopyOfwebservice..Web_Services_Tran...

That is a difficult question, and I'm not sure it can be done. The schema could define default values for fields which don't validate and that value could be set to some common one outside the normal data range but that wouldn't work as a generic solution, unfortunately. I really appreciate if you ...

That is a difficult question, and I'm not sure it can be done. The schema could define default values for fields which don't validate and that value could be set to some common one outside the normal data range but that wouldn't work as a generic solution, unfortunately. I really appreciate if you ...

Hello Everyone, I have to validate input file datatypes and collect all the invalied records to the reject file.Presently iam using the stage variables, one for each field to validate. Valid = 0, Invalid = 1 and lastly sum them. Good row constraint: sum = 0, reject everything else.My question is how...

Thank You. I am actually looking for 7.5.x certification. But this will help.

I am trying to find sample questions for certification, but looks like they have been removed from IBM web site.
http://www-03.ibm.com/certify/tests/sam415.shtml

Any help in letting me know where I can find the sample questions is greatly appreciated.