2_4_Data_Mapping_Matrix.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Map ID	Source System	Source Table	Source Field	Source Data Type	Source Format	Target System	Target Table	Target Field	Target Data Type	Target Format	Transformation Logic	Validation Rules	Default Value	Mapping Status	Owner	Notes
2	MAP-001	Legacy CRM	CUSTOMERS	CUST_ID	VARCHAR(10)	CUST-NNNNN	Cloud CRM	customer_master	customer_id	UUID	UUID v4	Generate new UUID; maintain mapping table for legacy ID reference	Must be unique; not null	N/A	Complete	Data Engineer	Mapping table: legacy_customer_id_map
3	MAP-002	Legacy CRM	CUSTOMERS	EMAIL_ADDR	VARCHAR(100)	email@domain.com	Cloud CRM	customer_master	email_address	VARCHAR(255)	RFC 5322	LOWER(TRIM(EMAIL_ADDR)); validate with regex pattern	Valid email format; unique; not null	NULL	Complete	Data Engineer	Email validation regex applied
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100