Details
-
Bug
-
Resolution: Done
-
Major
-
8.1
-
None
Description
Created a simple PARTS transformation and ended up with extra column mappings in transformation mapping root. Below is XMI segments from a correct 7.8 generated model and the latest 8.1 Designer version.
Use the following steps to replicate the this issue for both 7.8 and 8.1 Designer
- Import the attached model project set (zip)
- Open PartsViews.PartsInfo transformation editor
- Paste the following SQL and click "Validate"
- SELECT * FROM PARTS
DESIGNER 7.8 PARTS TRANSFORMATION
<transformation:TransformationContainer xmi:uuid="mmuuid:89b583e1-e6b7-4283-be29-24e4f0455e8c"> <transformationMappings xsi:type="transformation:SqlTransformationMappingRoot" xmi:uuid="mmuuid:f03d3a01-d558-40be-b2bb-ffb5f7aeefd3" outputs="mmuuid/12e1b573-7e75-4f51-8a8c-651d69da13e9" target="mmuuid/12e1b573-7e75-4f51-8a8c-651d69da13e9"> <helper xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:43e8a59f-fed6-433a-9c61-54945908dc42"> <nested xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:a110b2a5-1e8b-4db4-958a-a0f724f8f7d6" selectSql="SELECT * FROM PARTS"/> <aliases xmi:uuid="mmuuid:c968c6cc-8ba5-451e-b019-b3349942ca5a" alias="PARTS"> <aliasedObject href="PartsSupplier.xmi#mmuuid/d4ea0540-d7a9-4346-ae27-dcb72b7c33e6"/> </aliases> </helper> <nested xsi:type="transformation:TransformationMapping" xmi:uuid="mmuuid:b16d05f4-007d-44c7-b757-aa906529de3e" outputs="mmuuid/31e4e23b-b485-4c03-b286-37929ccbc6cf"> <inputs href="PartsSupplier.xmi#mmuuid/ba980e0a-6e5f-466b-9e15-9896359c640a"/> </nested> <nested xsi:type="transformation:TransformationMapping" xmi:uuid="mmuuid:62dd2443-2645-4253-865d-4bcdd1e5cd57" outputs="mmuuid/cbc42fa2-4756-4331-a5cb-aa516652a8f5"> <inputs href="PartsSupplier.xmi#mmuuid/1a4b789f-fb2b-4399-8876-43f4309fc402"/> </nested> <nested xsi:type="transformation:TransformationMapping" xmi:uuid="mmuuid:ffd15dbb-7d8b-4a06-9161-9176fdff42ed" outputs="mmuuid/9e021667-6be4-491f-9cd2-0e7652d159d8"> <inputs href="PartsSupplier.xmi#mmuuid/971ff0ca-5f87-4414-a534-40b05f648fe9"/> </nested> <nested xsi:type="transformation:TransformationMapping" xmi:uuid="mmuuid:dcc6cb92-a245-4b2b-83cd-4545144a5cad" outputs="mmuuid/b9f763f6-9f79-4de1-984e-6932a02c3263"> <inputs href="PartsSupplier.xmi#mmuuid/baa98663-8d22-43d0-a6bc-7feca47827b5"/> </nested> <inputs href="PartsSupplier.xmi#mmuuid/d4ea0540-d7a9-4346-ae27-dcb72b7c33e6"/> </transformationMappings> </transformation:TransformationContainer>
DESIGNER 8.1 ALPHA 1 PARTS TRANSFORMATION
<transformation:TransformationContainer xmi:uuid="mmuuid:faa98ced-0d3a-40a7-afde-37352988a466"> <transformationMappings xsi:type="transformation:SqlTransformationMappingRoot" xmi:uuid="mmuuid:39f8ced6-cc17-4e2d-9d2c-dfa006d58ead" outputs="mmuuid/fa1e3689-242e-4f9b-b1ef-f598be02d3bf" target="mmuuid/fa1e3689-242e-4f9b-b1ef-f598be02d3bf"> <helper xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:6e4ead08-bd8c-4719-b283-d976c9574b00"> <nested xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:ebea36b9-e6d8-4564-bece-9d3556a45091" selectSql="SELECT * FROM PartsSupplier.PARTS"/> <aliases xmi:uuid="mmuuid:9bb6640e-4ec7-4e97-9e39-261ddf670b92" alias="PARTS"> <aliasedObject href="PartsSupplier.xmi#mmuuid/a8a006a7-f161-4f3f-9a93-0e82d07842d6"/> </aliases> </helper> <nested xsi:type="transformation:TransformationMapping" xmi:uuid="mmuuid:cc9d1ffc-1c50-45f3-8bde-e47445461b51" outputs="mmuuid/2a85e933-dfe5-46ca-aec1-619cc2623cc0"> <inputs href="PartsSupplier.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/> </nested> <nested xsi:type="transformation:TransformationMapping" xmi:uuid="mmuuid:522e21d2-897b-47ea-b303-09ef300856f0" outputs="mmuuid/0d15c3f6-5309-4245-8fb2-38384b4d8c37"> <inputs href="PartsSupplier.xmi#mmuuid/dde8eecd-48b8-4646-8a74-d285aef420b2"/> <inputs href="PartsSupplier.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/> </nested> <nested xsi:type="transformation:TransformationMapping" xmi:uuid="mmuuid:2e20a65b-3415-4be7-bc57-5e955b6577e0" outputs="mmuuid/1fbf99b0-d787-4978-b7c3-a63e0fda8d75"> <inputs href="PartsSupplier.xmi#mmuuid/dde8eecd-48b8-4646-8a74-d285aef420b2"/> <inputs href="PartsSupplier.xmi#mmuuid/d26aae8c-c727-4f1d-ba9f-c99b52190a31"/> <inputs href="PartsSupplier.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/> </nested> <nested xsi:type="transformation:TransformationMapping" xmi:uuid="mmuuid:23fd17a2-a69f-485b-b4db-28788c4c3aa5" outputs="mmuuid/08109639-899d-4239-a174-6bd35405f021"> <inputs href="PartsSupplier.xmi#mmuuid/dde8eecd-48b8-4646-8a74-d285aef420b2"/> <inputs href="PartsSupplier.xmi#mmuuid/d26aae8c-c727-4f1d-ba9f-c99b52190a31"/> <inputs href="PartsSupplier.xmi#mmuuid/753efe1d-ef28-4389-8d24-4fa14c7dd917"/> <inputs href="PartsSupplier.xmi#mmuuid/a82fa733-bce0-4b20-bb2c-3a8108c091ec"/> </nested> <inputs href="PartsSupplier.xmi#mmuuid/a8a006a7-f161-4f3f-9a93-0e82d07842d6"/> </transformationMappings> </transformation:TransformationContainer>