NEVER put a hole in a joist, especially if the joist is also the bottom part of an engineered truss.
OK, there are exceptions, especially with TJI's. It's still best to avoid, unless you have no other choice. Even then, make sure to makethe hole round, and as small as possible, and place it where it does the least harm.