Most car problems are constant. Brake pads are worn or they're not. An oxygen sensor is dead or it's working. The technician can test for the condition and find it. Intermittent faults exist in a different category: the problem only appears when a specific combination of temperature, vibration, load, or time is present. Remove any one of those variables — like towing the car to a cool shop and running it for 20 minutes at idle — and the fault disappears.
The physical cause is usually a connection that's marginal. A wire that's 95% intact with a few strands broken. A connector that looks fine but has developed a layer of oxide on one terminal. A solder joint inside a module that's cracked just enough to lose contact when heat causes the board to expand. Under the right conditions, it conducts. Under slightly different conditions, it doesn't.