We have this situation. We have table(s) to be loaded from different sources. Few SORs load huge data and few load very less rows, but multiple SORs use the same wf in informatica, which is either TPT load/update as part of the connection. Due to this, we have scenario where we are using these block level utilities for loading less rows.
Question is , is there any way we can decide and use ,either from Informatica/Teradata side, dynamically pickup the TPT operator based on the size of source data ? so that we use right operator for right sized data.
Appreciate your response and guidelines to solve the probelm
You can parameterize the operator type like anything else:
DEFINE OPERATOR MyOperator TYPE @OperatorTyp
And in your job variable file:
OperatorType = LOAD -- or UPDATE or STREAM or INSERTER