Multi-thread Informatica connections to use different processors on target database server
When the "Max Degree of Parallelism" configuration in SQL Server (server properties > Advanced) to 0, the server will split up the connections to use as much of the server as it can.  With the way I set up the commands in Informatica, there are four separate processes.  When I tested on a 2 core server, it used two cores.  When I tested on a 4 core server, it used 4 cores.  Everything was running in parallel, or asynchronously.  It made the ETL process fly!