Quote Originally Posted by balajiyes
Having a CHECK constraint, will it impact my temp table. If yes, how much?
Will it impact performance? Certanly.
How severely? Hard to say, but I would speculate that it will be barely noticable.

Instead of guessing, why don't you simply try it? Get a sample of your data and load it - once with a constraint in place and once without it.