When is it that we need to go for direct query? I know when the data is large,but what is the approximate size limit for import mode?
Below link provide information on when Direct Query shall be used.
Also, find some differences in below link
Let me know if you have any specific question regarding this.