Dynamically pick TPT operator

General
Enthusiast

Dynamically pick TPT operator

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

 

regards,

Kiran

 

 

Tags (3)
1 REPLY
Highlighted
Junior Contributor

Re: Dynamically pick TPT operator

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