Forum Discussion

Wikus's avatar
Wikus
Contributor
2 years ago
Solved

Transformation rules mappings

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

Thanks

Transformation
  • MarcusH's avatar
    MarcusH
    2 years 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

     

5 Replies

  • DanielWillis's avatar
    DanielWillis
    Valued Contributor
    2 years 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
      Valued Contributor
      2 years 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
      Contributor
      2 years ago

      Hi Daniel,

      Thank you for the reply, looks good to me.