Forum Discussion

ckrussel's avatar
ckrussel
New Contributor
4 days ago

Best Practice for Managing Outdated Members in Transformation Rules?

We have recently received feedback from several entities regarding outdated account members that still exist within our Transformation Rules.

Before making any changes, I wanted to gather input on best practices for handling these scenarios. Specifically, I’m unsure whether it is appropriate to remove or delete these members, or if they should be retained and continue to be mapped for historical reporting purposes.

If anyone has guidance or experience with managing outdated members in Transformation Rules, your insight would be greatly appreciated.

3 Replies

  • NN's avatar
    NN
    Contributor

    Can add to SimonHesford​ information that if you have a lot of mapping like one-to-One, composite in the transformation rule it's impacting the performance when validating the import so try to keep them sort if performance is in focus.

  • SimonHesford's avatar
    SimonHesford
    Contributor II

    This is really a matter of preference or ease of maintenance. Leaving redundant account maps in the Transformation Rules has no material impact as data related to those accounts will not be imported into OneStream anymore. You don't really need them for historical reporting purposes as you likely won't be loading historical data again and you don't need the transformation rules for any drill down capability as the historical datasets are already stored in the Stage tables. I would say the main reason for deleting them is if they are adding too much noise in the ongoing maintenance transformation rules due to the volume of redundant entries in the rule groups. If you are still circumspect about deleting entries you can always take an export of the relevant transformation rule groups prior to any mass deletion to provide a backup snapshot in case there was ever a need to rollback or reinstate certain mappings  

    • ckrussel's avatar
      ckrussel
      New Contributor

      Thanks, this confirms a lot of my assumptions.  Appreciate the feedback!