It is attached on a Motherboard to connect RAM( Random access Memory) which is used by the the processor to store data in realtime processing.
DIMM comes in various types depending upon the type of Memory it is supporting, for example RAM are of different types like DDR1, DDR2, DDR3.
And it lets you easily replace or upgrade your personal computers RAM.