Until now, we were informed to look for DE_IDENT_IND = 'P' as an indicator/flag to verify if any column is previously de_identified or not.
However, after recent updates in the build for FDM (#102), the flag is showing 'S' for a few tables that we masked.
Is this a new kind of 'flag'? What does it indicate?
Can you provide some more clarification about this?
TDM Portal 4.9.X
Component: CA Test Data Manager
when masking completes restart column will have two states S and P where P refers to rows that were masked during the run and S where rows where processed but not masked (one reason for not masking are null values )
if you run a query such as:
select count(de_ident_ind), de_ident_ind from TABLENAME group by de_ident_ind
You might see other values U or N in the results:
because you can have multiple threads processing different columns for the same row.
It is not possible to update the restart column with S and P.
thread 1 updates restart col with S after processing columnA in row number X.
thread 2 will then not be able to process row X as restart col was set to S
to get around these timing issues, we used U and N as temporary values for masked and not masked.
when the job completes all N and U entries will be updated to S and P