Wednesday, November 18, 2009

Global address cleanse USA transform worked!

the zip4us directory needs to be downloaded along with 2 more files, zip4us, zip4us.rev to REFERENCE_DATA location. Re-ran the job and it worked!

Global address cleanse USA transform

I started doing the exercise from the manual and I am stuck. It is a simple data flow with one source, the transform and target table. The job first complained that:

"At least 1 DISABLE_CERTIFICATION option(s) must be present in this group".
"At least 1 REPORT_OPTIONS option(s) must be present in this group".

Found solution from BOB and imported gac.atl from C:\Program Files\Business Objects\Data Services\Admin\Repo. That removed that error.

Then the job complained city, zip4us directories are missing. Got those and placed in
C:\Program Files\Business Objects\Data Services\DataQuality\reference_data.

Finally the job is giving an error,

"3984 400 DQX-058306 11/18/2009 4:04:57 PM Transform : Global Address Transform: BAD INITIALIZATION OF ZIP4SHS DIRECTORY. Check the path and filename"

It stands here. Figuring out how to resolve this. Trying to find out what ARE ALL the directories that this transform needs to work correctly on address data.

DQ Installation

As far as DQ installation is concerned, business objects has recently released data services that has the data integrator components coupled with data quality transforms.
I installed data services (usual installation) and then added the following Licenses in the license manager:

Data Quality XI 3.0 (premium)
Universal data cleanse

I also installed the cleansing package downloaded from the SAP support site.
Created a cleansing database, repository and invoked that from the designer (Dictionary --> Manage connection)

Data Quality - A start

I have recently started working on data quality transforms using data services. Although I am well versed with data integrator, it seems quite a task to master the data quality transforms. Here is all the resources one should use while learning DQ,

1. Data Quality Manual where in there are exercises to work that will help master the working knowledge of these transforms

2. BOB - Business objects board

3. https://wiki.sdn.sap.com/wiki/display/BOBJ/Data+Quality