Step 3 — MAP
AI Maps, You Approve
LLM-powered source-to-target column mapping with reasoning. Every suggestion is transparent — review, refine, and approve before anything runs.
AI-Suggested Mappings
employees.first_name → dim_employee.full_name 95% departments.dept_id → dim_department.dept_key 99% salaries.amount → fact_compensation.salary_amount 92% positions.title → dim_position.job_title 88% 4 of 42 columns mapped ✓ Approve All
How It Works
1
Discover
AI scans source schema — tables, columns, types, relationships
2
Match
Heuristic + LLM dual approach suggests mappings with reasoning
3
Validate
Generate validation rules — null checks, ranges, uniqueness
4
Approve
Review, refine, and approve before anything runs
Key Capabilities
3-panel mapping editor (source ↔ rules ↔ target)
AI-suggested mappings with reasoning
Heuristic + LLM dual approach with fallback
Validation rules generator
Coverage report (matched vs unmapped)
Human review and approval workflow
Mapping project version history