Is it training affect or training effect?

Affect is a verb. Effect is what a cause does. Training is a cause, therefor the effect is losing weight. And you are affecting your health positively.