In a DSLR camera,which sensor is important?cmos or ccd?

I am trying to buy a DSLR camera but new point and shoot cameras use ccd sensors too. I want to know what is the trade off of buying a DSLR camera.