You are not logged in.
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.
It is impossible to set dynamically the action on data, it must be choosed at the design time. The examples you list are the proper solutions so far.