The Apple TV works with an internet connection only. Cable only plays a part if you are using your cable subscription to log in to some apps that require it
Otherwise, it will work just fine with just an internet connection.
Apps like Netflix, the iTunes Store, Hulu, and several others do not require a Cable subscription login.