Configure Pipeline — PL-D-001

Enterprise Brain · Operational
3
TO
PL-D-001 — Core Banking CDC Sync
DeterministicSource: Core Banking System — Oracle (SRC-001)
Ontology pin: v1.1.0 CDC: Debezium Running
Mapping Editor
CDC Config Validation Schedule Run History
Core Banking — Oracle
14 tables discovered
CUSTOMER
customer_idNUMBER(10)PK
full_nameVARCHAR2(200)
pan_numberVARCHAR2(10)
phoneVARCHAR2(15)
emailVARCHAR2(100)
date_of_birthDATE
addressVARCHAR2(500)
statusVARCHAR2(20)
created_dateDATE
last_modifiedTIMESTAMP
ACCOUNT
account_idNUMBER(12)PK
customer_idNUMBER(10)FK
account_typeVARCHAR2(30)
opening_dateDATE
statusVARCHAR2(20)
branch_codeVARCHAR2(10)
TRANSACTION8 columns
ALERT12 columns
CASE15 columns
EXIT_RECORD9 columns
Mappings
7 active · 2 transformed
customer_idbrain:hasIdentifier
full_nameTbrain:hasName
pan_numberbrain:hasPAN
phonebrain:hasPhone
emailbrain:hasEmail
statusTbrain:hasStatus
created_datebrain:hasCreatedDate
Active transforms
SPLIT_NAME: full_name → givenName + familyName
MAP_STATUS: {ACTIVE→Active, CLOSED→Closed, DORMANT→Dormant, SUSPENDED→Suspended}
Enterprise Context Model — Target Topics
Physical SchemasData
brain:hasTableNamexsd:string
brain:hasColumnNamexsd:string
brain:hasDataTypexsd:string
brain:hasConstraintxsd:string
Entity Resolution RulesDomain
brain:hasIdentifierxsd:stringrequired
brain:hasNamexsd:stringrequired
brain:hasPANxsd:string
brain:hasPhonexsd:string
brain:hasEmailxsd:string
brain:hasStatusbrain:StatusEnumrequired
brain:hasCreatedDatexsd:date
brain:hasAddressxsd:string
brain:givenNamexsd:string
brain:familyNamexsd:string
Mapping Test — 100 sample records
Run 9 Aug, 10:15 · 100 records → 347 triples · 100% SHACL validation pass
Re-run Test
CUSTOMER #4821 → brain:Entity_C4821
hasIdentifier '4821' · hasName 'Ashok Palekar' · hasPAN 'ABCPD1234E' · hasPhone '+91-98765-43210' · hasStatus 'Active'
SHACL: PassTopic: Entity Resolution Rules
CUSTOMER #4822 → brain:Entity_C4822
hasIdentifier '4822' · hasName 'A.R. Palekar' · hasPAN 'ABCPD1234E' · hasPhone '+91-98765-43210' · hasStatus 'Exited'
SHACL: PassDedup candidate: same PAN as Entity_C4821
ACCOUNT #A-10847 → brain:Entity_A10847
hasIdentifier 'A-10847' · hasCustomer Entity_C4821 · hasType 'Current' · hasStatus 'Active' · hasOpenDate '2024-03-15'
SHACL: PassTopic: Physical Schemas