Scenario 1: Once Dataset design is done, we import dataset in Mapping which creates Target table in SSMS. Now at a later stage we realize want to add more fields for mapping.
1. In Dataset Design>Edit Mode>Tab: Tables and fields>Particular field that we want to add for Mapping, we turn the toggle on Data Active.
Now we go to Mappings>TargetPanel>Edit Mode>Build Table.
Expectation: New field should reflect in Target Table : <prefix>_MARA_T in SSMS. This is happening as per expectation
Scenario 2: Now at later stage we want to remove field from Dataset Design>Tables and Fields> Turn toggle off for Data Active
Now we go to Mappings>TargetPanel>Edit Mode>Build Table.
Expectation: New field should be removed in Target table ::<prefix>_MARA_T in SSMS. This is not happening. In case of removal, Build table is not creating the table from changed Dataset design.
Solution is to drop in SSMS and then Build table from Mappings>TargetPanel>Edit Mode>Build Table.
But this is an overhead. ADMM 'Build Table' feature should support removal of fields also.
Could you please let me know why is it not supporting Scenario 2?
Comments
2 comments