Sample Header Ad - 728x90

Can data streams from Informatica to SQL Server be multi-threaded?

2 votes
1 answer
179 views
Suppose we have a database server, with SQL Server on it. And we are moving data from another database server, through our Informatica server, and onto that SQL Server database server. And our SQL Server database server has four processors. Is it possible to force the connections to be multi-threaded so it sends data quicker? How can this be done? Right now, only one of the processors is being used on the SQL Server database server.
Asked by JustBeingHelpful (2116 rep)
Jul 21, 2015, 08:30 PM
Last activity: Nov 6, 2024, 10:14 PM