We're replacing our target database to Teradata from Oracle and we're planning to use Informatica together with FastLoad and MultiLoad. As far as I know FL can be used for InitialLoad and ML can be used for Ongoing load. Can I use MutiLoad for both Initial load and ongoing load? Or what is the best way to handle? We are planning to use Loader connection.
ML can be used for both Initial load and ongoing load, when we use ML for Initial load the performance is low while comparing with FL. Moreover FL is exclusively built for Initial load, so it is always better to use FL for Initial load and for any ongoing load can be done with ML.
If you still have doubts, you can always refer ML and FL manuals.