Need detail information about Data Cleanse Transform.

[Former Member]

Hi Every One,

I Need detail information about Data Cleanse Transform.

1. what is Local Cleansing Packages?

2. what are Directories and Dictioneries.

3. Data Cleanse Transform INPUT , OPTIONS, OUTPUT tabs and usage.

4. Details on Transform Input Field name in Data Cleanse INPUT tab.

5. What is PARENT_COMPONENT,FILED_NAME,FIELD_CLASS,CONTENT_TYPE in  Data Cleanse OUT POT TAB.

I tried using "EnglishNorthAmericaDataCleanse" transform with NAME_OR_FIRM_LINE1.  When I ran the job I got below warning message and my job was success full nut status it shown as failed.

Warning message:

"Trasform Data Cleanse is unable to retrieve cleansing packages from Cleansing Package Builder. Only local cleansing packages are available. Info: Unable to log on: Could not connect to server d184932040.sng1.attens.net:6400.  Please check that the server name is  correct, and that the server is running. "

Please make me understand, why did I get above message.

Thanks in Advance ...

[Lynne_Lintelman]

Hello,

Cleansing package is a reference file that contains content and rules around person, firm, title, phone data and so on.  Cleansing package used to be referred to as dictionaries.  Directories are usually referred to address reference data or address directories.  The input, output and option tabs are similar to other Data Quality transforms.  For detail information on what each of the input fields and output fields are and how the options work can be found in the Data Services’ Designer Guide (http://help.sap.com/bods).

The warning message you are getting is stating that Data Services is not able to connect to the server to check to see if you have made modifications to the PERSON_FIRM cleansing package.  You are not required to make any changes to the PERSON_FIRM cleansing package, but can change rules or content based on your organizational rules.  If you want to make changes you will need to install SAP Information Steward.  If you would like to install SAP Information Steward you can find documentation for installation on the Help Portal, http://help.sap.com/bods, along with some great Videos.

You can also find some great Data Services Product Tutorials on the SAP Community Network, at http://scn.sap.com/docs/DOC-54115.

Thank you,

Lynne Lintelman