Data base comparision

[praneshsapmm]

Hello ,

I have this requirement of comparing duplicate data between SAP and SQL DB .

SQL DB contains 100GB data and SAP data is downloaded daily which need to compared with SQL Data .

Currently it is taking time let 1 GB data pass through the workflow and to complete comparision . Is there a faster way to do this . 

Thankyou.

[Luke_C]

Do you need to compare each and every record? Maybe you can summarize record counts based on key attributes and compare those first, for example both DBs have 1,000 records for ABC, 3,500 for DEF, etc. Then if there's a difference you can drill into it.

[praneshsapmm]

Hi @Luke_C ,

There are certain criteria to summerize even that takes a bit longer time .

Thanks.

[praneshsapmm]

Hello ,

Any suggestions for the above problem .

Thanks.