4e0827f6-d3c6-446e-a4d5-64e637e8fa80 585d3855-2115-4b40-85dc-355e18ff3f38 1 ad1e0d9e-3eca-4141-aa8c-9448402869e5 CountryOutline CountryOutline geometry CountryOutline geometry geometry -1 0 0 false true false false None 0 false false Default d8762623-5817-4700-a703-284cb1b4fe7a 585d3855-2115-4b40-85dc-355e18ff3f38 2 b0c2dc09-d9f7-4b9a-8a7b-58f56756a9b6 CountryName CountryName nvarchar(25) CountryName nvarchar nvarchar(25) 25 0 0 false true false false None 0 false false Default fa15d33c-e4c8-4a83-a714-ccbd2fff30db 585d3855-2115-4b40-85dc-355e18ff3f38 3 037bc309-72f0-4805-9550-c77f39791707 CountryNameLong CountryNameLong nvarchar(35) CountryNameLong nvarchar nvarchar(35) 35 0 0 false true false false None 0 false false Default fc3223c6-edb1-479a-9f5d-9561c2454185 585d3855-2115-4b40-85dc-355e18ff3f38 4 5621c845-6e8f-447f-930a-a7a866d825c1 ContinentName ContinentName nvarchar(23) ContinentName nvarchar nvarchar(23) 23 0 0 false true false false None 0 false false Default ec178912-6dc6-41b8-ac64-92ed1f8747b4 585d3855-2115-4b40-85dc-355e18ff3f38 5 ed040af2-ee2f-4aab-8a9b-972af20f1b28 RegionUN RegionUN nvarchar(10) RegionUN nvarchar nvarchar(10) 10 0 0 false true false false None 0 false false Default 51a9975a-ebf1-47cf-bce7-1aaf31bfb0fb 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 1 CountryOutline CountryOutline geometry CountryOutline geometry geometry -1 0 0 false true true false None 1 false false Default 17b6fb3b-2bf6-4c80-aa36-6d6318ab78fb 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 2 CountryName CountryName nvarchar(25) CountryName nvarchar nvarchar(25) 25 0 0 false true true false None 2 false false Default 0de9c448-1499-4f5e-9065-b836ae9d0e7f 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 3 CountryNameLong CountryNameLong nvarchar(35) CountryNameLong nvarchar nvarchar(35) 35 0 0 false true true false None 3 false false Default 8f00eb1b-44a8-44fd-a1a3-9ad9fd09c513 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 4 ContinentName ContinentName nvarchar(23) ContinentName nvarchar nvarchar(23) 23 0 0 false true true false None 4 false false Default 6ed11227-fc2a-434c-b980-abc02fbedbd7 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 5 RegionUN RegionUN nvarchar(10) RegionUN nvarchar nvarchar(10) 10 0 0 false true true false None 5 false false Default 5d5a172e-a6ad-424a-9b1b-42eb469c524d 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 6 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 false true true false None 0 DW_Id false false Default f003ef5f-7920-47a0-92fb-c60f292713a3 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 7 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 false true true false None 0 DW_Batch false false Default a0f1a46d-e553-40ed-8315-3aa4b5f33717 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 8 DW_SourceCode DW_SourceCode varchar(15) DW_SourceCode varchar varchar(15) 15 0 0 false true true false None 0 DW_SourceCode false false Default c1e8373a-c688-49bc-b754-87c667fc570d 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 9 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 false true true false None 0 DW_TimeStamp false false Default d6b38350-5c90-4a79-9d4e-3e1b60b0b669 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 10 DW_ODXBatchNumber DW_ODXBatchNumber bigint DW_ODXBatchNumber bigint bigint 0 0 0 false true true true None 0 DW_ODXBatchNumber false false Default e078f18b-8368-4075-bd68-a871e362d368 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 11 DW_ODXBatchId DW_ODXBatchId uniqueidentifier DW_ODXBatchId uniqueidentifier uniqueidentifier 0 0 0 false true true true None 0 DW_ODXBatchId false false Default 38e84fd4-267a-40aa-a706-0c6e38747dcc 2f176a15-26d6-4e55-a816-a024b0add353 1 42e79e58-bbfa-4ca6-8c73-00c100ac04f5 AddressLine1 AddressLine1 nvarchar(60) AddressLine1 nvarchar nvarchar(60) 60 0 0 false true false false None 0 false false Default d386d2ae-893f-45c7-86fb-f617c93fc593 2f176a15-26d6-4e55-a816-a024b0add353 2 f69b7559-7196-433d-8d06-04a651f11c03 AddressLine2 AddressLine2 nvarchar(60) AddressLine2 nvarchar nvarchar(60) 60 0 0 false true false false None 0 false false Default 336b5a57-422a-4a1f-8b0a-19327dc2f09e 2f176a15-26d6-4e55-a816-a024b0add353 3 2887969b-57cd-4139-b0a6-166f53c06958 City City nvarchar(30) City nvarchar nvarchar(30) 30 0 0 false true false false None 0 false false Default 7bb88979-38f0-4a9e-a2d1-26f151f4cf5e 2f176a15-26d6-4e55-a816-a024b0add353 4 b41244b4-a30c-432a-8531-b1a3d5652e14 GpsCoordinates GpsCoordinates geography GpsCoordinates geography geography -1 0 0 false true false false None 0 false false Default e7f02c88-e50c-4c41-a23f-faab922fa0ef 2f176a15-26d6-4e55-a816-a024b0add353 5 3d908896-1b5f-40a8-a653-d5081a0b0157 PostalCode PostalCode nvarchar(15) PostalCode nvarchar nvarchar(15) 15 0 0 false true false false None 0 false false Default d73b30eb-664c-4991-8ae2-e7579afc747f 946a9ec4-4b98-4507-bc98-eb0070278d0a 1 AddressLine1 AddressLine1 nvarchar(60) AddressLine1 nvarchar nvarchar(60) 60 0 0 false true true false None 1 false false Default caad99d4-cdf6-4501-8be2-fa72b33910f6 946a9ec4-4b98-4507-bc98-eb0070278d0a 2 AddressLine2 AddressLine2 nvarchar(60) AddressLine2 nvarchar nvarchar(60) 60 0 0 false true true false None 2 false false Default 892e921a-9d4b-4a84-907e-61a682fa8077 946a9ec4-4b98-4507-bc98-eb0070278d0a 3 City City nvarchar(30) City nvarchar nvarchar(30) 30 0 0 false true true false None 3 false false Default 2585c8be-6e4d-4012-bd3f-be6f2a733750 946a9ec4-4b98-4507-bc98-eb0070278d0a 4 GpsCoordinates GpsCoordinates geography GpsCoordinates geography geography -1 0 0 false true true false None 4 false false Default 451a6db1-c628-4262-aac2-bee45a5853b0 946a9ec4-4b98-4507-bc98-eb0070278d0a 5 PostalCode PostalCode nvarchar(15) PostalCode nvarchar nvarchar(15) 15 0 0 false true true false None 5 false false Default 355ea46b-c544-4b80-96e3-5eef6bdd8259 946a9ec4-4b98-4507-bc98-eb0070278d0a 6 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 false true true false None 0 DW_Id false false Default 6c5576ba-347c-47d0-ad74-488ec5970384 946a9ec4-4b98-4507-bc98-eb0070278d0a 7 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 false true true false None 0 DW_Batch false false Default 7c6b7719-1763-4512-869d-1d899b729bf7 946a9ec4-4b98-4507-bc98-eb0070278d0a 8 DW_SourceCode DW_SourceCode varchar(15) DW_SourceCode varchar varchar(15) 15 0 0 false true true false None 0 DW_SourceCode false false Default a06c0816-010d-4082-b9ca-26113e3616a2 946a9ec4-4b98-4507-bc98-eb0070278d0a 9 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 false true true false None 0 DW_TimeStamp false false Default 6d82a9af-6898-4eab-8876-b64d499043e0 946a9ec4-4b98-4507-bc98-eb0070278d0a 10 DW_ODXBatchNumber DW_ODXBatchNumber bigint DW_ODXBatchNumber bigint bigint 0 0 0 false true true true None 0 DW_ODXBatchNumber false false Default 6e980698-e615-4b0d-ac87-ec501b684fa0 946a9ec4-4b98-4507-bc98-eb0070278d0a 11 DW_ODXBatchId DW_ODXBatchId uniqueidentifier DW_ODXBatchId uniqueidentifier uniqueidentifier 0 0 0 false true true true None 0 DW_ODXBatchId false false Default b24815ff-5d6f-4677-81ad-4ee92f23e80c 946a9ec4-4b98-4507-bc98-eb0070278d0a 12 GpsCoordinatesGeometry SpatialLocationGeometry geometry GpsCoordinatesGeometry geometry geometry -1 0 0 false true true false None 6 false false Default 36f2aa9f-6992-4bf3-9688-96c6cf3749dc 946a9ec4-4b98-4507-bc98-eb0070278d0a 13 CountrySurrogateKey CountrySurrogateKey bigint CountrySurrogateKey bigint bigint 0 0 0 false true true false None 7 false false Default cc88822f-bda0-4227-b7c2-aeb900e18209 946a9ec4-4b98-4507-bc98-eb0070278d0a 14 CountryNameLong CountryNameLong varchar(100) CountryNameLong varchar varchar(100) 100 0 0 false true true false None 8 false false Default c56bbe37-56a3-45c0-87fe-33382ee533be 39f968d9-b2b2-4c20-a254-af0de983d386 1 DeliverySurrogateKey DeliverySurrogateKey bigint DeliverySurrogateKey bigint bigint 0 0 19 false false false false None 0 false false 7e292d68-88a6-4e0c-8605-ca9315adb54c 39f968d9-b2b2-4c20-a254-af0de983d386 2 CountrySurrogateKey CountrySurrogateKey bigint CountrySurrogateKey bigint bigint 0 0 19 false false false false None 0 false false 296391eb-ebd3-4a5c-9738-e2181024699d 39f968d9-b2b2-4c20-a254-af0de983d386 3 CountryNameLong CountryNameLong nvarchar(35) CountryNameLong nvarchar nvarchar 35 0 0 false false false false None 0 false false 8edf6e4b-c116-4919-bc38-ef7baa33233d d9ccb26f-06e6-4925-abbf-e8289406bc31 1 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 false true true false None 0 DW_Id false false Default 79b242c6-c8bf-4761-9086-95e93e4eb6c9 d9ccb26f-06e6-4925-abbf-e8289406bc31 2 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 false true true false None 0 DW_Batch false false Default 9d5f8005-8e78-437b-a148-41cefd75cd98 d9ccb26f-06e6-4925-abbf-e8289406bc31 3 DW_SourceCode DW_SourceCode varchar(15) DW_SourceCode varchar varchar(15) 15 0 0 false true true false None 0 DW_SourceCode false false Default 4204a4b5-1e3a-40f3-93db-4e41211eee5b d9ccb26f-06e6-4925-abbf-e8289406bc31 4 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 false true true false None 0 DW_TimeStamp false false Default 00b1be49-0f7d-4855-9150-e6e3dd25e470 d9ccb26f-06e6-4925-abbf-e8289406bc31 5 CountryNameLong CountryNameLong varchar(100) CountryNameLong varchar varchar(100) 100 0 0 false true true false None 1 Aggregate_Field false false Default dbae389e-edc0-426a-9db5-feb3d5706b4a d9ccb26f-06e6-4925-abbf-e8289406bc31 6 CntDeliveries CntDeliveries int CntDeliveries int bigint 0 0 0 false true true false Count 2 Aggregate_Field false false Default 585d3855-2115-4b40-85dc-355e18ff3f38 1c635e07-0d64-46a8-a33b-e536919936f1 e50960f8-cd58-41c4-9e69-0514fb2a5367 7e4e2b72-1638-4167-a12e-bddc0d898ea1 Countries dbo Countries Countries false ODX AsProject AsProject false false true true false false true true 0 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 47a4da45-ab8c-4a1d-8160-5f1ca61fecca Countries dbo Countries true DataWarehouse AsProject AsProject false false true true false false true false 2f176a15-26d6-4e55-a816-a024b0add353 1c635e07-0d64-46a8-a33b-e536919936f1 e50960f8-cd58-41c4-9e69-0514fb2a5367 ac3d7a49-1ad8-48d3-b6b9-0f7457286fb8 Delivieries dbo Delivieries Delivieries false ODX AsProject AsProject false false true true false false true true 0 946a9ec4-4b98-4507-bc98-eb0070278d0a 47a4da45-ab8c-4a1d-8160-5f1ca61fecca Delivieries dbo Delivieries true DataWarehouse AsProject AsProject false false true true false false true false 39f968d9-b2b2-4c20-a254-af0de983d386 47a4da45-ab8c-4a1d-8160-5f1ca61fecca MapDeliveriesCountries MapDeliveriesCountries MapDeliveriesCountries false DataWarehouse AsProject AsProject false false true false d9ccb26f-06e6-4925-abbf-e8289406bc31 47a4da45-ab8c-4a1d-8160-5f1ca61fecca AggDeliveriesByCountry AggDeliveriesByCountry AggDeliveriesByCountry false Aggregation AsProject AsProject false false true true false false true false b05807fb-e0f5-4f87-8ad5-488660462848 39f968d9-b2b2-4c20-a254-af0de983d386 946a9ec4-4b98-4507-bc98-eb0070278d0a MapDeliveriesCountries_DW_Id false Relation true 74646b0d-6ae8-4031-8397-049b1983982d 39f968d9-b2b2-4c20-a254-af0de983d386 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 MapDeliveriesCountries_DW_Id false Relation true b1ba22a8-a532-4a1b-a12b-d7458f1ac15b b24815ff-5d6f-4677-81ad-4ee92f23e80c 1 Custom geometry::STGeomFromText([GpsCoordinates].ToString(),[GpsCoordinates].STSrid) false 39f968d9-b2b2-4c20-a254-af0de983d386 false 0ce4e793-b43d-4bbf-b4ab-79abf768906c 438fde07-07e9-4bcd-a4d2-58a969ceace6 Default FailPackage 1 1 1 true ExecutionNumber 1 true true true true 438fde07-07e9-4bcd-a4d2-58a969ceace6 Spatial_Test true Normal 0 true false false 20.10.30.64 20.10.30.64 0 9999-12-31T23:59:59.9999999+01:00 Relation false false true bw8m6lf79FQiRIsTWa/yNdL7qaGLUGLwAJ7o2Cfhc3EJaNXRhIb9RN+O5tUc+s4qR93X/HqhX0z+LOADYkE2Sfgv/6MKepEItMvS020RSdcSi+8GUlAY+eQGRiN07tHOUyCAMImq6iDvNLBP3DgPd4bGEt7FM+OoGXNtKiW7Tne+VOMFboiI4NIfElBqUj31GymLk1uzeHjkjaPjjSijlo+L3jxWM2gM5I5vztOHyvgqOQjlCmJdLQ99hwypsAUF3JMV0uZ2JapxE5fhbGZxOMKgIHSiHEnv4JnNvVrF1l+lU25ZqQIzw6/p/BP404v/ false Error false false false Automatic 13 n8498RImmJneraor1FRkMiVON6bgCtvVhnZFtgTu2QtKp1waE1k+Dx4aVSax51Jb true true Sha1_2005 13 bd96fd11-80c5-4a2e-b764-cbfc9d00b3b4 438fde07-07e9-4bcd-a4d2-58a969ceace6 MDW false 1 2 3a6c6ca9-706b-4294-a9b3-7beb53a1408c b05807fb-e0f5-4f87-8ad5-488660462848 c56bbe37-56a3-45c0-87fe-33382ee533be 355ea46b-c544-4b80-96e3-5eef6bdd8259 889e2f3e-075b-4fa1-b584-ab061896f4f0 74646b0d-6ae8-4031-8397-049b1983982d 7e292d68-88a6-4e0c-8605-ca9315adb54c 5d5a172e-a6ad-424a-9b1b-42eb469c524d c56bbe37-56a3-45c0-87fe-33382ee533be 39f968d9-b2b2-4c20-a254-af0de983d386 7e292d68-88a6-4e0c-8605-ca9315adb54c 39f968d9-b2b2-4c20-a254-af0de983d386 296391eb-ebd3-4a5c-9738-e2181024699d 39f968d9-b2b2-4c20-a254-af0de983d386 47a4da45-ab8c-4a1d-8160-5f1ca61fecca bd96fd11-80c5-4a2e-b764-cbfc9d00b3b4 00000000-0000-0000-0000-000000000000 false localhost WindowsAuthentication QmEvtm671whyw2kZhSr/xw== Spatial_MDW 100 100 As_Parent 300000 Not_Set Roles Related To This Object Disabled Disabled SSISFollowDestination WindowsAuthentication QmEvtm671whyw2kZhSr/xw== false 30 604800 6557302e-3fb4-4338-9d20-2f9547fc89cb 438fde07-07e9-4bcd-a4d2-58a969ceace6 4e0827f6-d3c6-446e-a4d5-64e637e8fa80 51a9975a-ebf1-47cf-bce7-1aaf31bfb0fb false 50c55627-e400-4e22-a1bf-b5d5a5fb8b04 438fde07-07e9-4bcd-a4d2-58a969ceace6 d8762623-5817-4700-a703-284cb1b4fe7a 17b6fb3b-2bf6-4c80-aa36-6d6318ab78fb false dbd0cccd-3123-49b0-b60b-848188d36737 438fde07-07e9-4bcd-a4d2-58a969ceace6 fa15d33c-e4c8-4a83-a714-ccbd2fff30db 0de9c448-1499-4f5e-9065-b836ae9d0e7f false f0486138-7397-4d33-8fa0-1cbd5bd99bc9 438fde07-07e9-4bcd-a4d2-58a969ceace6 fc3223c6-edb1-479a-9f5d-9561c2454185 8f00eb1b-44a8-44fd-a1a3-9ad9fd09c513 false b794ab23-de3a-4284-abeb-d80c550f6972 438fde07-07e9-4bcd-a4d2-58a969ceace6 ec178912-6dc6-41b8-ac64-92ed1f8747b4 6ed11227-fc2a-434c-b980-abc02fbedbd7 false 4714e08a-9df6-48ee-a696-f7e39bba8d0b 438fde07-07e9-4bcd-a4d2-58a969ceace6 38e84fd4-267a-40aa-a706-0c6e38747dcc d73b30eb-664c-4991-8ae2-e7579afc747f false bf45cee4-3f0c-4fc9-8df6-9a62edcc3fbb 438fde07-07e9-4bcd-a4d2-58a969ceace6 d386d2ae-893f-45c7-86fb-f617c93fc593 caad99d4-cdf6-4501-8be2-fa72b33910f6 false b0a7436b-6240-4d59-a501-e34cb44f8f42 438fde07-07e9-4bcd-a4d2-58a969ceace6 336b5a57-422a-4a1f-8b0a-19327dc2f09e 892e921a-9d4b-4a84-907e-61a682fa8077 false c3fcb6c3-7e31-4942-aa2c-ed7cbc025f2c 438fde07-07e9-4bcd-a4d2-58a969ceace6 7bb88979-38f0-4a9e-a2d1-26f151f4cf5e 2585c8be-6e4d-4012-bd3f-be6f2a733750 false 79989d64-8312-4418-8fbf-2abb8da30701 438fde07-07e9-4bcd-a4d2-58a969ceace6 e7f02c88-e50c-4c41-a23f-faab922fa0ef 451a6db1-c628-4262-aac2-bee45a5853b0 false 39f968d9-b2b2-4c20-a254-af0de983d386 CREATE VIEW [etl].[MapDeliveriesCountries] AS SELECT d.[DW_Id_Deliveries] DeliverySurrogateKey , c.[DW_Id_Countries] CountrySurrogateKey , c.[CountryNameLong] FROM [Delivieries] d JOIN [Countries] c ON c.[CountryOutline].STContains(d.[GpsCoordinatesGeometry]) = 1 144d9923-0f4b-4e7a-9ff7-dd79e92bb6ae 47a4da45-ab8c-4a1d-8160-5f1ca61fecca UpdateDeliveriesCountryIds false 001a63df-8042-44d2-acdf-cfd0b6c4acca 144d9923-0f4b-4e7a-9ff7-dd79e92bb6ae 07460371-2717-45ae-b9a6-f14e92fbcc74 946a9ec4-4b98-4507-bc98-eb0070278d0a PostScript 8633eace-4807-4c82-8a86-e4eed37d4c46 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 Dimension_Table false None false false true true false As_Project false As_Project None false false None false false 100000 0 false false false false Always NotUsed RoundRobin Automatic 6eed2106-125a-4699-8fad-b20df21cbf28 946a9ec4-4b98-4507-bc98-eb0070278d0a Dimension_Table false None false false true true false As_Project false As_Project None false false None false false 100000 0 false false false false Always NotUsed RoundRobin Automatic 43404892-a260-4aa7-920a-abfdd6df3d40 d9ccb26f-06e6-4925-abbf-e8289406bc31 Dimension_Table false None false false true true false As_Project false As_Project None false false None false false 100000 2 false false false false Always NotUsed RoundRobin Automatic f168c1d0-ed4d-4c99-8d4c-25c2137b1e91 47a4da45-ab8c-4a1d-8160-5f1ca61fecca dbo dbo 2 3b3af885-6720-4877-a23f-3b4a7dc6784a 47a4da45-ab8c-4a1d-8160-5f1ca61fecca etl dbo 1 e738ee30-ceee-4e50-a84e-a8041f55f6b7 39f968d9-b2b2-4c20-a254-af0de983d386 3b3af885-6720-4877-a23f-3b4a7dc6784a 98267ba8-5b60-4352-9dd4-74a412aa59a1 438fde07-07e9-4bcd-a4d2-58a969ceace6 b1ba22a8-a532-4a1b-a12b-d7458f1ac15b 2585c8be-6e4d-4012-bd3f-be6f2a733750 [GpsCoordinates] 1 1 1 e982f0cf-3656-420f-a2cc-fe119d84bc5c 438fde07-07e9-4bcd-a4d2-58a969ceace6 39f968d9-b2b2-4c20-a254-af0de983d386 946a9ec4-4b98-4507-bc98-eb0070278d0a [Delivieries] 7 2 1 f4ee2082-430e-4ba8-b252-59c227469760 438fde07-07e9-4bcd-a4d2-58a969ceace6 39f968d9-b2b2-4c20-a254-af0de983d386 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 [Countries] 7 2 2 34c67070-d50b-4588-a4bc-c0e3cf5fcd95 438fde07-07e9-4bcd-a4d2-58a969ceace6 39f968d9-b2b2-4c20-a254-af0de983d386 51a9975a-ebf1-47cf-bce7-1aaf31bfb0fb [CountryOutline] 15 1 3 aff98a70-3430-49d9-b2c5-07c6bf249b10 438fde07-07e9-4bcd-a4d2-58a969ceace6 39f968d9-b2b2-4c20-a254-af0de983d386 b24815ff-5d6f-4677-81ad-4ee92f23e80c [GpsCoordinatesGeometry] 15 1 4 79a4c5d1-2787-457b-bd2d-eab9c11b5cd7 438fde07-07e9-4bcd-a4d2-58a969ceace6 39f968d9-b2b2-4c20-a254-af0de983d386 355ea46b-c544-4b80-96e3-5eef6bdd8259 [DW_Id_Deliveries] 15 1 5 e02680a4-b2bc-469d-b036-2e53dc156342 438fde07-07e9-4bcd-a4d2-58a969ceace6 39f968d9-b2b2-4c20-a254-af0de983d386 5d5a172e-a6ad-424a-9b1b-42eb469c524d [DW_Id_Countries] 15 1 6 7b06438e-274b-4019-be7c-b1d5298bc0fb 438fde07-07e9-4bcd-a4d2-58a969ceace6 39f968d9-b2b2-4c20-a254-af0de983d386 0de9c448-1499-4f5e-9065-b836ae9d0e7f [CountryNameLong] 15 1 7 b01134be-1236-406c-b57c-aec6ccfd10d3 438fde07-07e9-4bcd-a4d2-58a969ceace6 144d9923-0f4b-4e7a-9ff7-dd79e92bb6ae 946a9ec4-4b98-4507-bc98-eb0070278d0a [Delivieries] 7 2 1 f1cc6b30-f3be-45b8-a582-c321c4a1d049 438fde07-07e9-4bcd-a4d2-58a969ceace6 144d9923-0f4b-4e7a-9ff7-dd79e92bb6ae 36f2aa9f-6992-4bf3-9688-96c6cf3749dc [CountrySurrogateKey] 15 1 2 f183c7f8-36fc-46fa-8fa3-fb2b3ab157af 438fde07-07e9-4bcd-a4d2-58a969ceace6 144d9923-0f4b-4e7a-9ff7-dd79e92bb6ae cc88822f-bda0-4227-b7c2-aeb900e18209 [CountryNameLong] 15 1 3 543461d0-8505-4160-918f-3fe2765609fa 438fde07-07e9-4bcd-a4d2-58a969ceace6 144d9923-0f4b-4e7a-9ff7-dd79e92bb6ae 39f968d9-b2b2-4c20-a254-af0de983d386 [MapDeliveriesCountries] 8 8 4 8502fbfb-a833-46df-b3ea-0f31236bf155 438fde07-07e9-4bcd-a4d2-58a969ceace6 144d9923-0f4b-4e7a-9ff7-dd79e92bb6ae 355ea46b-c544-4b80-96e3-5eef6bdd8259 [DW_Id] 15 1 5 2e94ce0e-0677-4942-896d-0abf6e140701 438fde07-07e9-4bcd-a4d2-58a969ceace6 144d9923-0f4b-4e7a-9ff7-dd79e92bb6ae c56bbe37-56a3-45c0-87fe-33382ee533be [DeliverySurrogateKey] 1 1 6 6abdec5d-f775-4f71-b82c-8f487fb48d5e 438fde07-07e9-4bcd-a4d2-58a969ceace6 144d9923-0f4b-4e7a-9ff7-dd79e92bb6ae 296391eb-ebd3-4a5c-9738-e2181024699d [CountryNameLongMap] 1 1 7 2ed6649c-279f-4b62-8ec6-3174c56952e1 438fde07-07e9-4bcd-a4d2-58a969ceace6 144d9923-0f4b-4e7a-9ff7-dd79e92bb6ae 7e292d68-88a6-4e0c-8605-ca9315adb54c [CountrySurrogateKeyMap] 1 1 8 e6ab6ed1-eaec-4d78-85da-2e8cc043b272 47a4da45-ab8c-4a1d-8160-5f1ca61fecca false 1 0 0 0 0 4054913c-d29a-4756-b104-421b8cf4e4f6 585d3855-2115-4b40-85dc-355e18ff3f38 1 56a8e907-a50e-4cb4-af52-c99aeb244391 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 1 59b6933b-5406-4742-a158-69dc8a534663 2f176a15-26d6-4e55-a816-a024b0add353 2 b6a8eff0-7dc3-457c-aa40-34ddac6f2b00 946a9ec4-4b98-4507-bc98-eb0070278d0a 2 1ee73b2a-083f-4651-803d-dbf92ff1c91c 39f968d9-b2b2-4c20-a254-af0de983d386 1 1331d534-61bf-4fc1-bd33-96bded7b0e09 d9ccb26f-06e6-4925-abbf-e8289406bc31 3 2ad36fd2-07a2-45fd-b3b3-715d738c502c 144d9923-0f4b-4e7a-9ff7-dd79e92bb6ae 1 befab451-fe35-4b4d-b3ba-3727240c112d 00b1be49-0f7d-4855-9150-e6e3dd25e470 cc88822f-bda0-4227-b7c2-aeb900e18209 Value false cb557ed5-f0ac-417d-acfc-54c75b0848ff dbae389e-edc0-426a-9db5-feb3d5706b4a 355ea46b-c544-4b80-96e3-5eef6bdd8259 None false 72ce5140-9b08-489c-8c70-33cf872310d6 d9ccb26f-06e6-4925-abbf-e8289406bc31 946a9ec4-4b98-4507-bc98-eb0070278d0a 249d3330-6315-4f2f-9ca5-910339f90381 f168c1d0-ed4d-4c99-8d4c-25c2137b1e91 Valid 9e40f3a8-94f2-4371-ba52-b0543207870d 3b3af885-6720-4877-a23f-3b4a7dc6784a Main e45e5a36-c1b1-4a7c-ad65-003911220455 0ce4e793-b43d-4bbf-b4ab-79abf768906c 1 4700b751-b4dd-48cc-a679-585ca84f2691 3b488b3c-a165-4c18-a6f0-2bea86f8ebe5 585d3855-2115-4b40-85dc-355e18ff3f38 1 e5cdcafa-d991-4d1d-ad6a-c7b99cb5bef3 946a9ec4-4b98-4507-bc98-eb0070278d0a 2f176a15-26d6-4e55-a816-a024b0add353 1 1c635e07-0d64-46a8-a33b-e536919936f1 438fde07-07e9-4bcd-a4d2-58a969ceace6 localhost KJmj5Ga3YVljL6Y5zV6A4FUcRoxyi86yrJZYlNryFvP8Z1jb+PkLoLV8Ahj3igpk 20000 100 100 1800 1800 1429f7e7-9dcc-448b-82a0-1d7f9b9716c4 e2146cf9-b0c5-4369-8ebf-1e0b0fc4c8df 1c635e07-0d64-46a8-a33b-e536919936f1 Geography Geography 2641e81c-ae8e-4374-9af6-ad0cf4307da0 12298332-5eb6-4693-9be1-dce435ad1278 1c635e07-0d64-46a8-a33b-e536919936f1 _EU EU 1494b6db-d17f-4aa8-960d-dd1ae39c99ae e50960f8-cd58-41c4-9e69-0514fb2a5367 1c635e07-0d64-46a8-a33b-e536919936f1 SpatialDemo SpatDemo 0ffa577e-4ecb-4a3a-8f50-1b732cb03412