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
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...