{
  "id": "lib-process:data-engineering-analytics--scd-implementation",
  "_kind": "LibraryProcess",
  "_file": "generated-library/processes.yaml",
  "_cluster": "generated-library",
  "attributes": {
    "displayName": "scd-implementation",
    "description": "Slowly Changing Dimension (SCD) Implementation - Implement Type 2 SCD patterns for historical tracking in data warehouses,\nincluding merge logic, surrogate key generation, temporal tracking fields, versioning, late-arriving data handling, and comprehensive testing.",
    "libraryPath": "library/specializations/data-engineering-analytics/scd-implementation.js",
    "specialization": "data-engineering-analytics",
    "references": [
      "- The Data Warehouse Toolkit (3rd Edition) - Ralph Kimball: https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/\n- Slowly Changing Dimensions: https://en.wikipedia.org/wiki/Slowly_changing_dimension\n- Kimball SCD Techniques: https://www.kimballgroup.com/2008/08/slowly-changing-dimensions/\n- Type 2 SCD Best Practices: https://www.kimballgroup.com/2013/02/design-tip-152-slowly-changing-dimension-types-0-4-5-6/\n- dbt Snapshots Documentation: https://docs.getdbt.com/docs/build/snapshots"
    ],
    "example": "const result = await orchestrate('specializations/data-engineering-analytics/scd-implementation', {\n  projectName: 'Customer Dimension SCD',\n  dimensionTables: ['dim_customer', 'dim_product', 'dim_supplier'],\n  scdType: 'type-2',\n  targetPlatform: 'Snowflake',\n  sourceSystem: { database: 'production_db', schema: 'public' },\n  testingStrategy: 'comprehensive',\n  includeType1Attributes: true,\n  enableAuditLogging: true\n});",
    "usesAgents": [
      "dimensional-analyst",
      "key-architect",
      "temporal-architect",
      "merge-engineer",
      "ddl-architect",
      "load-engineer",
      "incremental-engineer",
      "late-arrival-specialist",
      "lookup-engineer",
      "test-engineer",
      "performance-engineer",
      "monitoring-engineer",
      "orchestration-engineer",
      "technical-writer",
      "implementation-validator"
    ]
  },
  "outgoingEdges": [
    {
      "from": "lib-process:data-engineering-analytics--scd-implementation",
      "to": "domain:data-engineering",
      "kind": "lib_applies_to_domain",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:data-engineering-analytics--scd-implementation",
      "to": "workflow:data-pipeline-deployment",
      "kind": "lib_implements_workflow",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:data-engineering-analytics--scd-implementation",
      "to": "specialization:data-engineering-analytics",
      "kind": "lib_belongs_to_specialization",
      "attributes": {
        "weight": 0.9
      }
    },
    {
      "from": "lib-process:data-engineering-analytics--scd-implementation",
      "to": "lib-agent:scientific-discovery--dimensional-analyst",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    },
    {
      "from": "lib-process:data-engineering-analytics--scd-implementation",
      "to": "lib-agent:shared--test-engineer",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    },
    {
      "from": "lib-process:data-engineering-analytics--scd-implementation",
      "to": "lib-agent:software-architecture--performance-engineer",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    },
    {
      "from": "lib-process:data-engineering-analytics--scd-implementation",
      "to": "lib-agent:meta--technical-writer",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    }
  ],
  "incomingEdges": []
}