I need to find the best way to change the name of a table that is referenced in some sql transformers
Page 1 / 1
Hi,
I usually use the Workspace Search for find out where the name is present, open the transformer and copy the new value.
Hi,
I usually use the Workspace Search for find out where the name is present, open the transformer and copy the new value.
Hi Itay, thans for your answer
That way I need to search one by one, Is there a way to search globally?
Hi Itay, thans for your answer
That way I need to search one by one, Is there a way to search globally?
Not that I know of. You could open the workspace via Notepad and do a search and replace, but beware it can corrupt the workspace...
It probably won't help you in the immediate term, but I like to use private parameters for things like this that get referenced by multiple transformers. That way, when it needs to be updated, all you need to do is change the parameter value. Additionally if you right click on the parameter and select Show References, it will list all the transformers that reference that parameter.
It probably won't help you in the immediate term, but I like to use private parameters for things like this that get referenced by multiple transformers. That way, when it needs to be updated, all you need to do is change the parameter value. Additionally if you right click on the parameter and select Show References, it will list all the transformers that reference that parameter.
Totally agree @jdh