Hello,
I have created a new column in query transform and mapped it to NULL.
Then I connected the query transform with table comparison transform. After importing the table name, I found that newly created column was not getting displayed in Generated_key_column dropdown.
Here E_ID is the surrogate key which I added in query transform.
Please help.
Thanks,
Rajan