Apartment value is moving into different column after CASS

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
tverma27
Participant
Posts: 8
Joined: Tue Mar 10, 2009 3:56 am

Apartment value is moving into different column after CASS

Post by tverma27 »

Hi

In my project, we are preprocessing on Address columns and area columns. After this we are doing the standardization as per client's requirements. His requirement is to have Apartment in address line 2.

We are using the USADDR.set and USAREA.set for this.

But somehow, when feeding ths standardized output to CASS stage, it is pushing the APT value to address line 1. This is not happening for all the records but for few.

For eg:
After standardization:
addr_1, addr_2
"175 BLEECKER ST", "APT 12";

Output after CASS:
addr1, addr2
"175 BLEECKER ST APT 12", null


Appreciate your earlier response.

Thanks in advance!
-tverma
lstsaur
Participant
Posts: 1139
Joined: Thu Oct 21, 2004 9:59 pm

Post by lstsaur »

I barely recalled that the input's Address Line 2 field for CASS stage must be "junked" out in order for version 8 CASS to make a reference match correctly. Call your support to see whether they can develop the new patch to fix your problem.
tverma27
Participant
Posts: 8
Joined: Tue Mar 10, 2009 3:56 am

Post by tverma27 »

Thanks for the reply.
We have reported this issue to the support team, lets see how they can help us.

Thanks
-tverma
Post Reply