Hi, Everyone.
Im trying to use a dynamic parameter within a transformation task, but I cant make it work.
It doesnt matter how I input the Table Name, I always get the same message when executing the task: Table XPTO to calculate dynamic parameter Test does not exist (yet) - using default.
Ive used the table name with and without schema name, with and without quotation marks, even tried with the tables internal ID but nothing seems to work.
What am I missing?
Thank you for your help.
Joaquim
Page 1 / 1
Ive figured out that Dynamic Parameters, defined within a Transformation Job, only work if the table youre using is in the Global Schema.
Does anyone know how to make them work with tables in a specific schema?
Thank you.
Joaquim
Does anyone know how to make them work with tables in a specific schema?
Thank you.
Joaquim
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.