on 2016 Aug 14 6:33 PM
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
Request clarification before answering.
Hi Rajan.
In the Table comparison, the settings are against column that exist in the table selected for comaparison. Not from them Input schema.
Therefore, to help you further, please add the column to the metadata first ( by reimporting after a structural change in the database where you have that table) and then you will be able to select it
Regards,
bogdan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
30 | |
10 | |
8 | |
8 | |
7 | |
6 | |
6 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.