Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Data Masking with StreamSets

Our company will start using StreamSets. Wondering if masking databases (Oracle, SQL Server, db2 LUW, db2 zos, IMS) is doable. The requirement is that the masked tables go back in the source database. We need to apply custom functions, lookups, and hash-lookups. If yes, is it fast? One example: let's say we mask a field in a table of 20mill rows, 250M as csv, using a lookup table of 20 mill rows, 400 M as csv) . Our current tool takes hours; if we rewrite into stored procedure maybe 10 mins. Thanks in advance Teodora

Data Masking with StreamSets

Our company will start using StreamSets. StreamSets.

Wondering if masking databases (Oracle, SQL Server, db2 LUW, db2 zos, IMS) is doable. The requirement is that the masked tables go back in the source database. We need to apply custom functions, lookups, and hash-lookups.

If yes, is it fast? One example: let's say we mask a field in a table of 20mill rows, 250M as csv, using a lookup table of 20 mill rows, 400 M as csv) . Our current tool takes hours; if we rewrite into stored procedure maybe 10 mins. Thanks in advance Teodoramins.