Transformation rules mappings

[Wikus]

Does anybody know in which table are Transformation rules mapping stored?

Thanks

[MarcusH]

The maps are held in the table StageRules.

[DanielWillis]

Often joined with StageRuleGroups, e.g., to get a list:

SELECT 
    Case Ruletype
        WHEN 1 THEN RuleName -- 1:1
        WHEN 2 THEN RuleExpression -- composite
        WHEN 5 THEN RuleExpression -- mask
    END AS Source,
    OutputValue AS Target
 FROM StageRuleGroups
 INNER JOIN StageRules ON StageRules.RulesGroupKey = StageRuleGroups.UniqueID
 WHERE RuleGroupName = 'MyRuleName'

Just grabbed this from somewhere without checking but it looks right!

[Wikus]

Hi Daniel,

Thank you for the reply, looks good to me.

[MarcusH · Accepted solution]

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

[Wikus]

Thank you Marcus this will work for me.