whats the best approach to data cleansing?

[Former Member]

Hi All,

      I am having a requirement to do data profiling in Information steward.

My process is

1) Extracting Information from SAP ECC to Data Services and storing the data in SQL Server.

2) Data profiling (Rules) on SQL Server Data using Information Steward.(SAP ECC-->Data Services-->SQL Server-->Information Steward)

3)Again Saving the cleansed data into the SAP ECC by(Information Steward  --> SQL Server-->Data Services-->SAP ECC)

Is there any better way to handle it?

Thanks.

Praveen.

[former_member922475]

Hi,

the approach will work. Another option might be to archive the data before cleansing it. This can help to reduce the amount of data which needs to be cleansed at the end. The challenge is to cleanse the data by a consistent way and to recognize the dependencies (production order, sales orders, business partners and so on).

For more details you could check e.g. www.data-cleansing-check.de

Thanks

Alfred

[former_member187605]

Step 1 and 2 is the correct approach.

For step 3 there are multiple alternatives:

1/. manual modification or upload (depends on number of corrections)

2/. DS indeed, calling BAPI's or posting IDOCs

3/. SAP has a Master Data Governance (MDG) solution that support federation into the source systems

[Former Member]

Making Information Steward as a source to the Master Data Governance(MDG)!

How can i achieve this?

are there any connections to make?