Hi, can someone tell me, is there any different or batter approach to test data in "STAGING TABLE"? Other than going by normal approach of DB testing, like Boundary analysis, Parameter validations, S-T flow etc

This is the discriptoin of the problem I am working on, In our company, we have marketing division, who come up with different marketing strategies to target customers. They develop these marketing strategies, with the help of a software, where in they use appropriate attributes depending on the customer group they r targeting and then they map that data into the appropriate action “staging table”(for example: If the marketing is to reduce the APR – then they will map that strategy to the APR staging table), before passing it on to the main DB.

How can we make sure that the mapping is done right? I mean in a testing perspective. Thanks in advance.