DM for aldi
find out the dimension
confirm the tipper and POS status
verification flow: [2020-07-10 3:54 PM] Celina Sun (CN):
OWNER_DWH.F_ALDI_EVENT_LOG_TT
wechat id dimension
POS & Tipper Status
POS
Tipper Status
cl_tipper_status
if the time of the valid can be decided
verify the useful of the column
verify the column does it make sense?
find out why the blocked POS still can generate volume when they're blocked during the fraud attack.
why the posl still can generate volume when they are blocked?
device/wechat id blah
device
F_TIPPER_2_DEVICE_TT .SKP_MOBILE_APP_DEVICE
click to edit
QR code
type
click to edit
ask AF to confirm whether they are using this table
if yes, how they find out the period the tippers valid, if not which one they are using
which one they are using
verify if it is possible that one device not valid but still generating volume
click to edit
f_salesroom_ad.skp_salesroom_status
TEXT_IP_ADDRES FROM OWNER_DWH.F_ALDI_EVENT_LOG_TT LOGTT