I have one table in database A and one table in database B, both table having same structure.
1) data transfer from A-->B.
2) compare the data in both table then delete the data in source table(A)
Here Database B having incremental data and tables doesn't have date column. My question is: how to compare data in both tables which don't have date column?
Please share your approach? Thanks in advance.