AnsweredAssumed Answered

PART_HASH function in Teradata subset masking scripts

Question asked by Swapnil_Rasane on Jul 27, 2018
Latest reply on Aug 10, 2018 by Sean-K-CA



I am using GTSubset for Teradata masking scripts wherein I am using Teradata Scrambled windows export/load option to prepare the masking scripts. 


While masking First name column, I have selected HASHLOV function for masking using Datamaker tranformation map and running the bat file under TPT\exportandload so that the masked data will get directly loaded into my Target instance.


However, I am getting error while running the script. I have also observed that the script is using some PART_HASH function for masking. Please explain what this function is for? Is it Teradata in built function?


The error is: EXPORT_OPERATOR: TPT10508: RDBMS error 5628: Column C4Z1TARP not found in Y2, Y1.



I have attached the TPT script which is running once I invoke bat file.