Skip to Content
author's profile photo Former Member
Former Member

Scrambling records limit

Hi Experts,

If I want to scramble one table field say "LFA1- Name2" , is it going to scramble all records in the target system? if yes, how can I limit to certain records only of the able field say 500 records to be scrambled.

Please let me know how to do it and share screen shots if any?

Appreciate your help

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 31, 2013 at 04:55 PM

    Hi Amr,

    You can use condition sets to scarmble the limited records.

    Condition sets are used to filter the table records to be used for scrambling.

    It is always applicable to just scramble the primary table maintained in the rule. You can use the result set to scramble the other tables in the rule.

    You can set simple or complex condition set on single or multiple fields of the primary table.

    From the Data Scrambling Workcenter, choose new to create a scrambling rule.

    Switch to the expert mode and the Condition Set tab will be visible. You can provide the following condition to get your record scrambled: BT, CP, GT, EQ, GE, LE, LT, NB, NE, NP

    You can find more details on condition sets in the scrambling guide.…

    Best Regards,


    Capture.JPG (32.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Amr,

      Your original question:

      How to limit the scrambling to 500 records ?

      When you write a rule to scramble LFA1 - NAME2, it will scramble the entire LFA1 table unless and untill you specify a condition. What I mean here as a condition , can be any exit criteria (or) a condition set to limit the data that is getting scrambled.

      For option a ) exit criteri : You can use a global counter in your top include and increment it from your sub routine . When this reaches 500 , can write code to just continue without scramblling. This will ensure that you scramble only 500 records.

      For option b) condition sets : you can maintain a condition set based on any filed in the primary table field . This will also help you in acheiving the same , however when you re-execute the same rule for the next 500 entries , you need to modify the condition.

      If after defining condition sets , it is not working as expected, please raise a message in component CA-TDM-SCR and we will look into the system for the same.

      Farheen's statement 'You can use the result set to scramble the other tables in the rule' means that in the same rule you can have multiple tables, but the condition sets that you have deifined will work on all the tables.

      Hope this clarifies the scenario.

      Best Regards,

      Uma Tharmarajan

  • Posted on Dec 31, 2013 at 01:33 PM

    I would guess that you would leverage the BPL to limit your transfer to the 500 records that you require and then run a data scramble package after the BPL process has completed.

    Also I'm not sure what the field Name2 contains without looking, but if that information is dependent for other fields/tables you may run into consistency issues; the best example for this would be address information assigning a USA state to the country of Germany as an example. Chances are there won't be any issues, but something to verify.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.