Logic to implement

sunitha_cts · Post by **sunitha_cts** » Tue Feb 07, 2012 12:35 am

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

kandyshandy · Post by **kandyshandy** » Tue Feb 07, 2012 1:08 am

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?

sunitha_cts · Post by **sunitha_cts** » Tue Feb 07, 2012 2:28 am

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

Thanks
Sunitha

kandyshandy · Post by **kandyshandy** » Tue Feb 07, 2012 2:42 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 07, 2012 3:12 am

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

sunitha_cts · Post by **sunitha_cts** » Tue Feb 07, 2012 3:32 am

Hi Ray,

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

Could you advice me on this.

Thanks
Sunitha

ray.wurlod · Post by **ray.wurlod** » Tue Feb 07, 2012 5:30 am

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?

sunitha_cts · Post by **sunitha_cts** » Tue Feb 07, 2012 5:56 am

Hi Ray,

We have got the scramble algorithm.

Thanks
Sunitha

ray.wurlod · Post by **ray.wurlod** » Tue Feb 07, 2012 7:49 am

There were three questions.