Hi Jagadeesh,
You should be able to accomplish this scenario with Fast Data Masker (FDM). You will just need to make sure you meet all the requirements for masking with Netezza.
Supported Data Sources - CA Test Data Manager - 4.1 - CA Technologies Documentation
Fast Data Masker System Requirements - CA Test Data Manager - 4.1 - CA Technologies Documentation
- Ensure that you can create external tables; that is, create external table privileges for the login user.
- Increase the commit size to at least the size of the largest table to be masked.
- PARALLEL option is not supported for Netezza, as only one external table can be created at a time.
- If PTS is being used, this has to be run on the Primary.
- NPS client needs 1 GB of memory per million rows being masked; this is an approximate estimate. The memory requirement depends on the size of the table to be masked (row count) and the number of columns being masked.
- Copy the nzjdbc.jar file to the ..\Grid-Tools\FastDataMasker\lib folder.
You can run a masking job remotely with a script/from command line. You can read more about it here: Fast Data Masker Best Practices - CA Test Data Manager - 4.1 - CA Technologies Documentation
If you would like help implementing masking from a command line using Netezza, I would suggest reaching out to your CA Account Manager. They will be able to find you a resource from pre-sales or services to help implement this scenario in your particular environment. If you do not know who your account manager is, you can call CA Customer Care here and they will be able to tell you: Contact CA Support - CA Technologies
Best regards,
Taylor