What are the dis advantages of using the external loader for informatica? I can see that . it will make the loading faster that writing sql against target.
But is there any dis advangates of external loading ?
One of the issues we encountered is that it writes database password in text format to control file at run time which could become a security threat. So make sure to secure the directory where file is being created.