IanWaterman
Programmer
I am trying to reconcile data going into a Datawarehouse from two different sources
Premium is posted and charged to Credit card and policy receipted with correct amount.
Data is transamitted to Credit Card provider which hold policy number and amount plus other info. So the only link between policy data and Credi card data is policy no, amount and date. This is all fine and I can relate the two data sets on those fields.
Problem arises when Credit card payment generator has a senior moment and posts reciept multiple time. So in my Policy data set I have one record and in credit card set say 3 records.
Is there a quick way I can identify the fact that Policy data is being duplicated when it matches with CC data, so that I can add a field which shows Duplicated Y or N. This is all going into a table for reconciliation. If I do not identify the dupes table will reconcile as Policy data will be duplicated to match!
Thank you
Ian
Premium is posted and charged to Credit card and policy receipted with correct amount.
Data is transamitted to Credit Card provider which hold policy number and amount plus other info. So the only link between policy data and Credi card data is policy no, amount and date. This is all fine and I can relate the two data sets on those fields.
Problem arises when Credit card payment generator has a senior moment and posts reciept multiple time. So in my Policy data set I have one record and in credit card set say 3 records.
Is there a quick way I can identify the fact that Policy data is being duplicated when it matches with CC data, so that I can add a field which shows Duplicated Y or N. This is all going into a table for reconciliation. If I do not identify the dupes table will reconcile as Policy data will be duplicated to match!
Thank you
Ian