Wednesday, November 18, 2009

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.

No comments: