Your body is going through quite an adrenaline rush. Your excited condition and your anxiety about the anticipated pain may trigger a fainting spell. It will help if you are not there on an empty stomach. Don't forget to breathe and relax. The outline is usually the most painful part for most people.
Some people try to distract themselves by trying to talk with the artist.
While some will like to talk with you, others would rather concentrate on the work you're paying them to do. Often, they'll talk during easy parts, and less during complex work. Just relax and don't worry about it. Most people can sit through over an hour of work, but if you get uncomfortable, just ask your artist if you can take a break. Once the tattoo is finished you will get to look at it, then it will be bandaged up and after-care will be discussed.