TDM: What controls the order of the tables in PII Scan?
search cancel

TDM: What controls the order of the tables in PII Scan?

book

Article ID: 206592

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Does the order of the filters affect table scan order?? 

{"connProfiles":["RRMDM"],"classifierPacks":[5013,5295,15035,15043,15067,24881],"scanLevel":100,"storeSamples":false,"scanLevelSet":true,"storeSamplesSet":true,"dataSources":[],"isIncludeFilter":true,
"filters":[{"profile":"RRMDM","schema":"dbo","tables":["S*"]},{"profile":"RRMDM","schema":"dbo","tables":["W*"]},{"profile":"RRMDM","schema":"dbo","tables":["V*"]},{"profile":"rrmdm","schema":"dbo","tables":["Z*"]}],"origin":"audit","scanStringKeys":true,"scanNumericKeys":false,"scanStringKeysSet":true,"scanNumericKeysSet":true,

Environment

Release : 4.9

Component : CA Test Data Manager

Cause

N/A

Resolution

There is no order the results are brought back.

It just makes a JDBC query to the metadata. But is not using an order by in the query.