To give you a proper answer you need to ask a more specific question, when you say "how effective can affiliate marketing be" you need to mention effective at what. For example, affiliate marketing is not very effective for making pancakes, because pancakes require batter and batter doesn't travel through the internet very easily.