Customer Merge Log Fact Table

This table captures the details of customer account merges within the system. It includes information about the accounts involved, the reason for the merge, and the date and time details of various events related to the merge process.

Databricks Table Name: customer_merge_log

Customer Merge Log - Entity Relationship Diagram (ERD)

Zoom in the table for more clarity. Click the table title to view its details.

Customer Merge Logauto_update_time: bigintdetails: stringdim_event_date_id: bigintdim_event_time_id: bigintdim_event_user_id: bigintdim_latest_updated_date_id: bigintdim_latest_updated_time_id: bigintdim_merged_by_admin_id: bigintdim_merged_by_zone_till_id: bigintdim_victim_user_id: bigintPKmerge_event_id: bigintmerge_reason: stringvictim_external_id: stringvictim_mobile: stringyear: intAdmin Usersis_active: intis_deleted: intmiddle_name: stringfirst_name: stringemail: stringLKid: bigintlast_name: stringdateLKdate_id: intday_of_month: intweek_of_year: intmonth: stringyear: intquarter: stringweek_number: intweek_start_date: stringweek_end_date: stringday_of_week: stringmonth_no: intmonth_no_of_year: intmonth_of_year: stringday_of_week_no: intquarter_no: intyearly_quarter_no: intdate: stringDateTimeLKtime_id: biginttime: stringhour_of_day: int