PDA

View Full Version : Kettle Project: Variables for connection sql tab



Igorz
05-18-2007, 08:32 AM
Not possible add variable into connection sql tab. We have many same tables in different Oracle user schemas and we need transform all these tables with one connection and dynamics variables.
Example:
alter session set current_schema = ${dyn_user_schema}
or
alter session set current_schema = %%dyn_user_schema%%


Reference: http://forums.pentaho.org/showthread.php?t=54038

Thanks.