The water pump apllies pulses of water and or pressure. The displacement between the high pressure and the low pressure causes the "water Hammer".
I would not expect it to do it more than once when you hook up to city water. The water pressure is constant, (you do have your regulator on dont you?)
, especially through the water regulator.