Is it possible hashlov function mask the data from two different source?

[Ludmila Kozlova]

Hi
There are two different source DB, for example, MS SQL and Oracle. And is required one masking for the identical data in this different DBs. Is it possible use hashlov function for this case? Or maybe there are other desisions for the task?

Thanks in advance.

[Legacy User]

HASHLOV is exactly what you would use in this situation. Since a hash is deterministic (same input always equals same output) the hash function will create the same index into your seed list. So, as long as the same seed list is being used for both databases, you will get the same result. 

The only caution here is that you want to make sure that both DBs are storing the data the same way. If one of the DBs pads a field with spaces, or if they are not stored in the same case, they will not hash the same. i.e "Bob" is different from "Bob  " is different from "BOB".

[Ludmila Kozlova]

Brian, thank you for your explanation. And maybe you can tell me why there is no hashlov function for MS SQL Server for Transformation Map?

 

thanks in advance

[Legacy User]

Elka - That is an excellent question. I had thought it was present, but just went back and checked at the customer site I am on and did not see any HASHLOV functions for SQL server in TDM 3.8 transformation maps. If I can get over to a newer version, I will check there. I'll also take a look at FDM. 

 

Thanks,

Bri

[Ludmila Kozlova]

Brain - i looked for and didn't find HASHLOV for MS SQL Server for transformation map in TDM 4.2. I checked hashlov  in FDM for MSSQL and Oracle - all works properly. Thank you very match.