Are you asking if you fainting means you got pregnant from the sex yesterday? No. If the sex yesterday caused a sperm to meet an egg, it would not cause you to faint today. They would still be floating around in your fallopian tubes.
If you are asking if fainting can be an early symptom of pregnancy, yes it can. But not that early.