The optimal texture depends on your own preference -- but generally, you want the lentils to almost fully disintegrate into a mushy, creamy texture. Some people like dal quite soupy, while others like a thicker puree. You can always add more water to loosen it up if you like! Additionally, when lentils cool, they will thicken so you may need to add more water later on (or if reheating the dish).