DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
bettyso



Group memberships:
Premium Members

Joined: 30 Apr 2007
Posts: 7
Location: Canada
Points: 172

Post Posted: Mon Sep 26, 2011 12:01 pm Reply with quote    Back to top    

I am working on a MDM integration project, and I find that the data in AddressLineOne, AddressLineTwo in Response file are different with the output from QualityStage Standardization job.

Is it a configuration issue? Any idea how to fix it? Thanks.

Example ONE:
Input Address data:
     <TCRMAddressBObj>
         <AddressLineOne>9729 159 STREET</AddressLineOne>
         <City>EDMONTON</City>
         <ZipPostalCode>T5P2Z4</ZipPostalCode>
         <ProvinceStateValue>QC</ProvinceStateValue>
         <CountryValue>Canada</CountryValue>
         <StandardFormatingIndicator>N</StandardFormatingIndicator>
    </TCRMAddressBObj>

Output from QS:
       AddressLineOne_Formatted:  9729 159 ST NW
       UnitType:  Unit
       UnitValue:  9729
       StreetName:  159
       Street Type:  ST
      SuffixDIrection:  NW
 
Response File:
     <TCRMAddressBObj>
            <AddressIdPK>269831671481910983</AddressIdPK>
            <AddressLastUpdateDate>2011-09-24 18:44:58.278</AddressLastUpdateDate>
            <AddressLastUpdateTxId>821431690429734566</AddressLastUpdateTxId>
           <AddressLastUpdateUser>Standardization</AddressLastUpdateUser>
          <AddressLineOne>159 ST NW</AddressLineOne>
          <City>EDMONTON</City>
          <CountryType>31</CountryType>
          <CountryValue>Canada</CountryValue>
          <ProvinceStateType>101</ProvinceStateType>
          <ProvinceStateValue>AB</ProvinceStateValue>
          <ResidenceNumber>UNIT 9729</ResidenceNumber>
          <StandardFormatingIndicator>Y</StandardFormatingIndicator>
          <ZipPostalCode>T5P2Z4</ZipPostalCode>
          <StreetName>159</StreetName>
          <StreetSuffix>ST</StreetSuffix>
          <PostDirectional>NW</PostDirectional>
          <DWLStatus>
                <Status>0</Status>
          </DWLStatus>
    </TCRMAddressBObj>
 
 
 
Example TWO:  (addresslinetwo_formatted is set to NULL in QS)
Input Address data:
    <TCRMAddressBObj>
         <AddressLineOne>P.O. Box 6500</AddressLineOne>
         <City>NORTH YORK</City>
         <ZipPostalCode>M3M3K4</ZipPostalCode>
        <ProvinceStateValue>ON</ProvinceStateValue>
         <CountryValue>Canada</CountryValue>
         <StandardFormatingIndicator>N</StandardFormatingIndicator>
    </TCRMAddressBObj>
  
Output from QS:
         Addresslineone_formatted:  PO BOX 6500
        BoxType:  PO BOX
        BoxValue:  6500
 
 
Response File:
   <TCRMAddressBObj>
        <AddressIdPK>666631663323856192</AddressIdPK>
        <AddressLastUpdateDate>2011-09-21 15:27:18.562</AddressLastUpdateDate>
        <AddressLastUpdateTxId>805931663323844086</AddressLastUpdateTxId>
       <AddressLastUpdateUser>QA</AddressLastUpdateUser>
       <AddressLineOne>PO BOX 6500</AddressLineOne>
       <AddressLineTwo>PO BOX 6500</AddressLineTwo>
       <City>NORTH YORK</City>
       <CountryType>31</CountryType>
       <CountryValue>Canada</CountryValue>
       <ProvinceStateType>108</ProvinceStateType>
       <ProvinceStateValue>ON</ProvinceStateValue>
       <StandardFormatingIndicator>Y</StandardFormatingIndicator>
     <ZipPostalCode>M3M3K4</ZipPostalCode>
       <BoxDesignator>PO BOX</BoxDesignator>
       <BoxId>6500</BoxId>
       <DWLStatus>
              <Status>0</Status>
       </DWLStatus>
  </TCRMAddressBObj>

_________________
Bso
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours