Solved
Transformation rules mappings
Does anybody know in which table are Transformation rules mapping stored?
Thanks
This is the query I use for exporting maps (this does not include logical operators or expressions)
SELECT
Case Ruletype
WHEN 1 THEN 'OneToOne'
WHEN 2 THEN 'Composite'
WHEN 3 THEN 'Range'
WHEN 4 THEN 'List'
WHEN 5 THEN 'Mask'
END AS MapType
,RuleName
,RuleDescription
,Case Ruletype
WHEN 1 THEN RuleName
ELSE RuleExpression
END AS Source
,OutputValue AS Target
,Case FlipSign WHEN 0 THEN 'False' ELSE 'True' END AS FlipSign
,ExecutionOrder AS [Order]
FROM StageRuleGroups
INNER JOIN StageRules ON StageRules.RulesGroupKey = StageRuleGroups.UniqueID
WHERE RuleGroupName = 'MyRuleName'
ORDER BY RuleType, ExecutionOrder, RuleName