Merge issuer_country values for United States in Littlepay mart tables
Closed this issue · 0 comments
charlie-costanzo commented
User story / feature request
As a payments data analyst, I want the value representing the country United States in the issuer_country field to have a consistent value in the table fct_payments_rides_v2
Acceptance Criteria
Currently, the country United States is represented by two different values for issuer_country in the fct_payments_rides_v2 table: ‘UNITED STATES’ and ‘UNITED STATES OF AMERICA (THE)’. These should be coalesced to one value: ‘UNITED STATES’, likely in the staging table.
Notes
This was requested by Rebel/Georgia to facilitate their fraud analysis