All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.
Could we have a mechanism to create a st table (st package) that that does not include all of the columns specified in the Source System Type for that table. i.e. only create the st table with reference to the fields that are active in Map, Target Sources > Target Source Schema.
When a st package is being created the values in the field SourceSQL column in the AutoGen.dbo.webAETargetSourceBuildCranPortSel view drive the Assemble package creation. The SourceSQL column is produced by the AutoGen.dbo.boaGetCranPortSelectColumnList scalar function. That function seems to just include every column listed on the Target Source Schema page in Map. There is no filter on the [Active] column.
A simple, yet effective change, of customizing the AutoGen.dbo.boaGetCranPortSelectColumnList scalar function to filter on [Active] = 1 will ensure that the st is created with only those fields that are active on the Target Source Schema page in Map.
See Syniti Support ticket #18754 for more details and thanks for Ben Bauer for helping with the potential solution.
Cheers,
Nav
Navdeep Rauli
