How can I rename columns in the table while exporting
On the latest version 12.5.1, upon exporting the table/columns of your choice you can choose between the ‘Database names’,‘Labels’ or ‘No header’ as Column headers. Once you have exported them, you can load the .csv/.xls/.txt file into a plan with a Text File Reader and Text File Writer. Once you load your data into your plan you can edit the metadata and rename the columns to your liking.
I hope this information helped you out.
Thanks for your reply. But currently I am using ataccama 12.4.1ga. Is there any option available there?
I just double checked and yes this option is also available for version 12.4.1.