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