If you set the drive to cable select then it matters. Never use cable select. Some drives have single master, master with slave, and slave jumper positions.
If using one drive on a three connector cable use the end connector. The two connectors that go to the drives are closer together, the far one goes to the motherboard.