You SHOULD not, you MUST.
PowerCenter (the technology which is used by TDM to perform the actual masking, subsetting, or generation tasks) relies on source and target structures to exist. It never creates any target tables on its own.
That means: if you have a relational target, then this target table MUST exist in the target DB before you run the masking plan.
The sole exception are CSV-formatted target files. They will be created regardless of whether they already existed or not.
Thanks for your response Nico,
I have two doubts:
1. So, I create a table in the target database with only the column names with no data or some data must be present?
2.In Plan Settings in TDM, I do not have the option to select table name in TargetConnection. So it still posts data if the same tableName is present in target?
Kindly help me understand this.
Q1: to PowerCenter it doesn't matter whether the table already contains data or not. If PowerCenter shall write records with already existing primary keys, then the target DB should reject those records, and this should reflect in the counts shown by the TDM console (as "number of rejected records" or something similar).
In short: the table must exist, whether it contains data doesn't matter to TDM.
Q2: Yes. The table name is automatically taken from the name of the target definition (to speak in PowerCenter terms). In TDM, if memory serves me right (haven't worked with it for years), it's the name of the imported target entity and hence is identical to the name of the entity to be masked (because source and target table names must be identical in TDM).
Thank You Nico