37a6aeb0-4ebf-4623-94ec-a0615880bc63 4c3badc0-d082-461a-8fbe-a0615880b1eb 1 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false a3bb44d7-c3c4-43d5-ae12-a0615880bd53 4c3badc0-d082-461a-8fbe-a0615880b1eb 2 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false bc1ea975-57c0-43ed-a8bf-a0615880bda3 4c3badc0-d082-461a-8fbe-a0615880b1eb 3 DW_SourceCode DW_SourceCode varchar(15) DW_SourceCode varchar varchar(15) 15 0 0 true true false true true None 0 DW_SourceCode false false c772218f-e9f5-4502-85a4-a0615880bdcb 4c3badc0-d082-461a-8fbe-a0615880b1eb 4 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false cbfffcd2-fa31-49f4-8109-a0615884a38d 82a73f4d-b768-4c6b-9b1d-a06158849cfd 1 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false ca6008e3-00b5-4920-88e8-a0615884a38e 82a73f4d-b768-4c6b-9b1d-a06158849cfd 2 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false f8173d3c-d180-4b37-a185-a0615884a3b5 82a73f4d-b768-4c6b-9b1d-a06158849cfd 3 DW_SourceCode DW_SourceCode varchar(15) DW_SourceCode varchar varchar(15) 15 0 0 true true false true true None 0 DW_SourceCode false false 7cbd1c78-2e1c-4e53-be58-a0615884a3b6 82a73f4d-b768-4c6b-9b1d-a06158849cfd 4 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false 387c344a-a2da-4449-b595-a061588b4c8b 82a73f4d-b768-4c6b-9b1d-a06158849cfd 5 DimID DimID varchar(50) DimID varchar varchar(50) 50 0 0 true true false true true None 1 false false eba23322-5be8-457b-85cd-a061589a4803 4c3badc0-d082-461a-8fbe-a0615880b1eb 5 AccountNo AccountNo varchar(50) AccountNo varchar varchar(50) 50 0 0 true true false true true None 1 false false 7bbe178f-4c85-463b-91ad-a06158e5e6eb 003a9034-e481-461d-90fe-a06158d22453 1 AccountDim varchar(101) AccountDim varchar varchar 101 0 0 true true false false false None 0 false false 4c3badc0-d082-461a-8fbe-a0615880b1eb b77fbea4-7214-46ad-b8c3-a061587c530e Accounts dbo Accounts true 1 DataWarehouse AsProject AsProject false false true true false false 82a73f4d-b768-4c6b-9b1d-a06158849cfd b77fbea4-7214-46ad-b8c3-a061587c530e Dims dbo Dims true 2 DataWarehouse AsProject AsProject false false true true false false 003a9034-e481-461d-90fe-a06158d22453 b77fbea4-7214-46ad-b8c3-a061587c530e vAccountDims dbo vAccountDims vAccountDims false 0 DataWarehouse AsProject AsProject false false false 003a9034-e481-461d-90fe-a06158d22453 false 11dc47b2-d845-464a-bdc9-a061587605ed Account Dim Join false Normal 0 true false false 4.5.34.32 4.5.34.32 0 9999-12-31T23:59:59.9999999+01:00 Error true true false UqgyByzaFVJeaIc+gmUJOFSFsqq/BrySvAm5ae8SLvJ8RGtm2ASwfEpdy257KnxZQCUIon2p2LlhiavY1ffYUbyy0jMZKWVFDP7yVmFam14bgvqUOR7tlS5bWmfJe3hAhWtv2D4eywjbzv1ONqSxiZGqnuUUEJt6zMXSaPs2fECsGQZwIcscNSOOTi8Rb1a9XxPchYNZOmTkgdNJq4sEQHKskJVXU/shrZ0rAdo4rdybuKRzLREBckyc+Rs0cr05DaYVSroFKOJbG5Uz3kiJjGQuTNfbzvjYzFJ4QfFT+R0eZB1Vr42twoCgBDvNQ+nu false Error false 1eaba770-e9eb-473f-a37e-a061587c517e 11dc47b2-d845-464a-bdc9-a061587605ed DW false 1 7bbe178f-4c85-463b-91ad-a06158e5e6eb 003a9034-e481-461d-90fe-a06158d22453 b77fbea4-7214-46ad-b8c3-a061587c530e 1eaba770-e9eb-473f-a37e-a061587c517e 00000000-0000-0000-0000-000000000000 false . true QmEvtm671whyw2kZhSr/xw== DW 100 15 As_Parent 0 Not_Set 003a9034-e481-461d-90fe-a06158d22453 CREATE VIEW [dbo].[vAccountDims] AS SELECT [AccountNo] + '-' + DimID AS AccountDim FROM [dbo].[Accounts_V] A, [dbo].[Dims_V] ff7fab67-b226-4b46-ae2b-a061589476a3 82a73f4d-b768-4c6b-9b1d-a06158849cfd <NewDataSet><Dims_CustomData><DimID>10</DimID></Dims_CustomData><Dims_CustomData><DimID>20</DimID></Dims_CustomData><Dims_CustomData><DimID>30</DimID></Dims_CustomData><Dims_CustomData><DimID>40</DimID></Dims_CustomData><Dims_CustomData><DimID>50</DimID></Dims_CustomData><Dims_CustomData><DimID>60</DimID></Dims_CustomData></NewDataSet> a085cfed-1501-4015-9e27-a061589f73eb 4c3badc0-d082-461a-8fbe-a0615880b1eb <NewDataSet><Accounts_CustomData><AccountNo>1410</AccountNo></Accounts_CustomData></NewDataSet>