Hi,

I am wondering in the tMysqlOutput,  if we can dynamically set the 'Action on data' to either insert or something else depending on some flag - basically making that field a variable. 

My use case is this:

For the initial run, I want to use just the insert operation since the table is initially empty (I find that doing update else insert takes considerably longer time than straight insert operation).  This makes a difference when the volume of data, especially the initial run is huge.

I know there are ways to go about that.  For example, one job doing insert, another doing update else insert depending on a flag.  Or having 2 outputs in the tmap and stream to different tMysqlOutput based on flag.  However, they require maintenance on additional objects that are virtually the same except at the insert/update operation.

Thanks
Sarah