Forum Discussion

Wikus's avatar
Wikus
New Contributor III
11 months ago

Transformation rules mappings

Does anybody know in which table are Transformation rules mapping stored? Thanks
Transformation
  • MarcusH's avatar
    MarcusH
    11 months ago

    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

     

DanielWillis's avatar
DanielWillis
Valued Contributor
11 months ago

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!

  • MarcusH's avatar
    MarcusH
    Contributor III
    11 months ago

    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's avatar
    Wikus
    New Contributor III
    11 months ago

    Hi Daniel,

    Thank you for the reply, looks good to me.