Transformer between Dataset and Multiload

[gsherry1]

Hello Forum,

If my dataset has all the transformation already necessary to meeting my loading requirements, is there any advantage of placing a dummy transformer between the Dataset and TDML stages.

For example,

DS-->T-->TDML

Versus

DS-->TDML

Any performance and/or reject handling differences?

Thanks in advance.

Greg

[ray.wurlod]

No advantage whatsoever. A Copy stage would be much less impact as a placeholder, and also give you the ability to suck out a few rows (for audit/sampling) to a second output link. Indeed, if it's a straight through copy, the Copy stage is likely to be "optimized out" when the job is compiled.

[kumar_s]

However, If need to have a reject handling based on the given business logic even in future, you can add a transformer. If there is no functionality required, its better to remove, because it will always consume its own resource.