OTP-category indicator flag
Bank Otkritie is building risk scoring by the operation type — payments and regular transfers need different limits and anti-fraud logic. Analytics prepares an indicator to split these streams in the dashboard.
Attach an indicator to each row: 1 when category contains payment, and 2 when category contains transfer but does not contain acc. Drop every other row — they don't belong in the dashboard feed.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| status | category | client_id | indicator | entered_at | session_id |
|---|---|---|---|---|---|
| success | otp-payment | 2 | 1 | 2024-04-01T07:05:00.000Z | 101 |
| success | otp-transfer | 3 | 2 | 2024-04-01T07:10:00.000Z | 102 |
| success | otp-payment-recurring | 5 | 1 | 2024-04-01T07:20:00.000Z | 104 |
Bank Otkritie
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid