--Felder (amount_min, amount_max, category_name )aus Satellite h_operator_s_core raus:

{
  "name" : "core",
  "type" : "Satellite",
  "hubName" : "operator",
  "description" : "Operator main data",
  "selection" : [
    {
      "sourceSystem" : "crm",
      "sourceFieldTable" : "user",
      "sourceFieldAlias" : "first_name",
      "nameExpression" : "",
      "alias" : "first_name",
      "datatype" : "VARCHAR255",
      "dvEncoding": "BYTEDICT"
    },
    {
      "sourceSystem" : "crm",
      "sourceFieldTable" : "user",
      "sourceFieldAlias" : "last_name",
      "nameExpression" : "",
      "alias" : "last_name",
      "datatype" : "VARCHAR255",
      "dvEncoding": "BYTEDICT"
    },
    {
      "sourceSystem" : "crm",
      "sourceFieldTable" : "user",
      "sourceFieldAlias" : "gender",
      "nameExpression" : "",
      "alias" : "gender",
      "datatype" : "VARCHAR50",
      "dvEncoding": "BYTEDICT"
    },
    {
      "sourceSystem" : "crm",
      "sourceFieldTable" : "user",
      "sourceFieldAlias" : "team_name",
      "nameExpression" : "",
      "alias" : "team_name",
      "datatype" : "VARCHAR100",
      "dvEncoding": "BYTEDICT"
    },
    {
      "sourceSystem" : "crm",
      "sourceFieldTable" : "user",
      "sourceFieldAlias" : "status",
      "nameExpression" : "",
      "alias" : "status",
      "datatype" : "VARCHAR100",
      "dvEncoding": "BYTEDICT"
    },
    {
      "sourceSystem" : "crm",
      "sourceFieldTable" : "user",
      "sourceFieldAlias" : "automatic_operator",
      "nameExpression" : "",
      "alias" : "automatic_operator",
      "datatype" : "SMALLINT",
      "dvEncoding": "MOSTLY8"
    },
    {
      "sourceSystem" : "crm",
      "sourceFieldTable" : "user",
      "sourceFieldAlias" : "created_at",
      "nameExpression" : "",
      "alias" : "created_at",
      "datatype" : "TIMESTAMP",
      "dvEncoding": "ZSTD"
    },
    {
      "sourceSystem" : "crm",
      "sourceFieldTable" : "user",
      "sourceFieldAlias" : "roles",
      "nameExpression" : "",
      "alias" : "roles",
      "datatype" : "VARCHAR255",
      "dvEncoding": "BYTEDICT"
    }
  ]
}

-- neuer Import anlegen auf user Tabelle Basis:
{
  "sourceSystemName" : "crm",
  "name" : "user",
  "stageLoadQuery" : "SELECT @@AUTO@@ FROM src_crm.user",
  "stageIncrementalFields": "",
  "schedule": "0 24 * * * *",
  "fields" : [
    {
      "nameExpression" : "id",
      "alias": "id",
      "dataType" : "INT",
      "description": "ID des Users"
    },
    {
      "nameExpression" : "operator_category_id",
      "alias": "operator_category_id",
      "dataType" : "INT",
      "description": "ID der Operator Kategorie"
    }
  ]
}

-- crm_operator_category import anpassen (id muss mit):
{
  "sourceSystemName" : "crm",
  "name" : "operator_category",
  "stageLoadQuery" : "SELECT @@AUTO@@ FROM src_crm.operator_category JOIN src_crm.user ON operator_category.id = user.operator_category_id",
  "stageIncrementalFields": "",
  "schedule": "0 53 10 * * *",
  "fields" : [
    {
      "nameExpression" : "operator_category.id",
      "alias": "id",
      "dataType" : "INT",
      "description": "ID der Operator Kategorie"
    },
    {
      "nameExpression" : "operator_category.name",
      "alias": "name",
      "dataType" : "VARCHAR50",
      "description": "Name der Kategorie"
    },
    {
      "nameExpression" : "operator_category.min_amount",
      "alias": "min_amount",
      "dataType" : "INT",
      "description": "Min Amount vom der Kategorie"
    },
    {
      "nameExpression" : "operator_category.max_amount",
      "alias": "max_amount",
      "dataType" : "INT",
      "description": "Max Amount vom der Kategorie"
    },
    {
      "nameExpression" : "NOW()",
      "alias": "load_date",
      "dataType" : "TIMESTAMP",
      "description": "Ladezeit"
    },
    {
      "nameExpression" : "user.client_id",
      "alias": "client_id",
      "dataType" : "INT",
      "description": "Client ID"
    },
    {
      "nameExpression" : "user.client_user_id",
      "alias": "client_user_id",
      "dataType" : "INT",
      "description": "Client ID User"
    }
  ]
}

-- Hub operator_category anpassen:
{
  "name" : "operator_category",
  "type" : "Hub",
  "allCurrentPit": "view",
  "selection" : [
    {
      "sourceSystem" : "crm",
      "sourceFieldTable" : "operator_category",
      "sourceFieldAlias" : "id",
      "nameExpression" : "id",
      "alias" : "category_id",
      "datatype" : "INT",
      "dvEncoding": "MOSTLY16"
    },
    {
      "sourceSystem" : "crm",
      "sourceFieldTable" : "user_operator_category",
      "sourceFieldAlias" : "id",
      "nameExpression" : "id",
      "alias" : "category_id",
      "datatype" : "INT",
      "dvEncoding": "MOSTLY16"
    }

  ]
}

-- operator changed category NHL anpassung (operator category id hinzu):
{
  "name" : "operator_changed_category",
  "type" : "Link",
  "hubNames" : ["operator_category", "operator"],
  "selection" : [
    {
      "sourceSystem" : "crm",
      "sourceFieldTable" : "operator_category",
      "sourceFieldAlias" : "client_id",
      "nameExpression" : "",
      "alias" : "client_id",
      "datatype" : "INT",
      "dvEncoding": "MOSTLY16"
    },
    {
      "sourceSystem" : "crm",
      "sourceFieldTable" : "operator_category",
      "sourceFieldAlias" : "client_user_id",
      "nameExpression" : "",
      "alias" : "client_operator_id",
      "datatype" : "INT",
      "dvEncoding": "DELTA"
    },
    {
      "sourceSystem" : "crm",
      "sourceFieldTable" : "operator_category",
      "sourceFieldAlias" : "name",
      "nameExpression" : "",
      "alias" : "category",
      "datatype" : "VARCHAR50",
      "dvEncoding": "BYTEDICT"
    },
    {
      "sourceSystem" : "crm",
      "sourceFieldTable" : "operator_category",
      "sourceFieldAlias" : "load_date",
      "nameExpression" : "",
      "alias" : "assignment_date",
      "datatype" : "TIMESTAMP"
    },
    {
      "sourceSystem" : "crm",
      "sourceFieldTable" : "operator_category",
      "sourceFieldAlias" : "category_id",
      "nameExpression" : "",
      "alias" : "operator_category_id",
      "datatype" : "MOSTLY16"
    }
  ]
}