I am using PD 16.5 SP03 PL03. I am reviewing a table in a physical model that has 100 columns. The column names given are all cryptic and do not meet standards. I am in the process of Changing the column names to more meaningful names. But we have a ETL mapping already defined for this table using the existing non-standard columns. So it is important for me to remember what I have changed so I can apply the same changes to the etl mapping document.
My question is, Is there any way I can create a hidden column in PD for the table (in fact to all the tables in the model) and run a script to copy the current Code to this hidden column. This way once i change the name, I can produce a listing (with the help of hidden column), old name and new name.