IF i connect with live connection is it directly hits the source database or cache server ? how live connection gets the data
It depends on how caching is configured. You can find your answer here:
Configure Data Connections
Retrieving data ...