I have below requirement.Please help me how to resolve?
Picking the columns dynamically from sequential file and masking the data.
Example:
File contains 20 columns out of these 20 columns i need to mask the data for the columns 4,7,13,19. Next run same file contains 50 columns out of these 50 columns i need to mask the data 22,31,44.
You can dynamically read the file using a Schema File and Runtime Column Propagation.
The dynamic masking is rather trickier. For starters, what you do you actually mean by "masking"? Essentially I'd try splitting the data stream into two, one containing just the columns to be masked and the other containing the other columns. Possibly use parameterised Modify stages for this logic. Then all you are left with is to figure out how to mask all the columns in the first stream, before re-uniting them with a Funnel stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I put the word masking in quotes for basically the same reason, wondering what exactly it meant here. We've had several conversations over the years here when people were mixing it up with other techniques like redaction and even encryption at times.
-craig
"You can never have too many knives" -- Logan Nine Fingers