DSXchange

Hi,

I have a requirement in the below manner.
I need to mask some values in 18 byte data sent to me .
The value is read in 1byte to 9 byte .
Few values need to be masked the data extracted is numeric but after masking they result in numeric and non numeric values.
req
123456789
output
1M3AXSD89

Could you please suggest me on this
We can use a stage variable and look up to do this .
We are not allowed to use routinees to implement this logic.
Is their any other way to implement this logic as the alphabets masked values comprise of alphabets A-Z.

Thanks
Sunitha

If the input is

123456789

,

you are expecting the output exactly as shown below?

1M3AXSD89

OR Any numeric input value should be masked based on some logic?

Hi,
The numeric input has to masked .
No bussiness logics applied.

Thanks
Sunitha

Refer formatting functions in Server job developer guide. I don't have access to the tool right now & so, i can't talk about those functions in a PX job.

Whatever option used for masking must be used for unmasking. Otherwise, the data will be messed up.

Ask your vendor about Optim Data Masking. There's even a Data Masking stage (that uses Optim technology) in DataStage version 8.7.

Hi Ray,

We are using DS 7x parallel jobs for our developemnet.

Could you advice me on this.

Thanks
Sunitha

Have you been given a masking algorithm, or don't they care and are allowing you to invent one? Does it simply have to mask, or does it have to be difficult to decode too? It's easily possible, but you need C++ programming skills to create a parallel routine. Do you have these?

Hi Ray,

We have got the scramble algorithm.

Thanks
Sunitha

There were three questions.