4 Replies Latest reply on Sep 20, 2019 6:34 AM by Erik van Driel

    Irish postal codes

    Erik van Driel Active Member

      Hello!
      I am currently configuring address validation for Ireland. The output is not appending a postal code (eircode) to the validated address

      In the knowledge base, I found this reference for on-premise. Does the same apply for the cloud version of AD?
      https://kb.informatica.com/solution/23/Pages/65/527631.aspx?myk=ireland

      Thanks!
      Erik







        • 1. Re: Irish postal codes
          Shubham Garg Active Member

          Hi Erik,

           

          Yes, For the Ireland, Address Doctor has two type of database files ( _01 and _02 ) for on-premise setup.

          If you we see the above screenshot,

           

          DB5_IRL5BI_02_190701.zip file,  does contain postal code (EIRCODE) for Ireland address.

           

          I have tested some addresses In the Address Doctor Cloud and able to see that Address Doctor is  populating/appending the postal code for Ireland addresses. 

           

          Address Doctor Cloud contain the _02 file in database.

           

          Thanks,

          Shubham Garg

           

           

           

           

           

           

           

          • 2. Re: Irish postal codes
            Erik van Driel Active Member

            Thanks for the feedback Shubham
            I did run a sample file of 1000 addresses and many return C4 & V4 codes, however no zip code has been appended.

            Here is the current database details:

            <DataBase CountryISO3="IRL"

            Type="BATCH_INTERACTIVE"

            TrialDataBase="NO"

            Path="/vibeinsdir/Informatica/10.2.0_HF1/Server/services/DQContent/INFA_Content/av/default/IRL5BI.MD"

            Status="ACTIVE"

            Size="189374464"

            Version="5.00.02"

            StartDate="2019-03-11"

            ExpirationDate="2019-07-31"

            UnlockStartDate="2019-05-21"

            UnlockExpirationDate="2021-05-20"

            ReleaseDate="2019-03-05"

            DataDate="2019-02-01"

            Encoding="NATIVE"

            PreloadingType="NONE"

            PreloadingSize="0"/>

            Thanks!
            Erik








            • 3. Re: Irish postal codes
              Shubham Garg Active Member

              Hi Eric,

               

              From your Database details, I can see file is having Size="189374464" ~ 181 MB  but While check in-house.

               

              Size of  the  Batch_Interactive file without Postal Code (DB5_IRL5BI_01_190701.zip) is Around 181 MB

              Size of the Batch_Interactive file with Postal Code  (DB5_IRL5BI_02_190701.zip) is around 387 MB

               

              It means, in your database you have the Batch_Interactive file which is without Postal Code. 

               

              You need to update the IRL Batch_Interactive file with the _02 file ( Batch_Interactive file with Postal Code) so that you can get the ERICODE for the addresses.

               

              Thanks,

              Shubham

               

               

              1 of 1 people found this helpful
              • 4. Re: Irish postal codes
                Erik van Driel Active Member

                Thanks Shubham
                I will open a support ticket to have the files replaced as we are using the cloud version.
                Have a nice weekend!
                Erik