Sample Header Ad - 728x90

Multi-thread Informatica connections to use different processors on target database server

1 vote
1 answer
1694 views
See this question for reference. https://dba.stackexchange.com/questions/107680/can-data-streams-from-informatica-to-sql-server-be-multi-threaded I've got most of my problem figured out. I've split up the one large table into four smaller tables. I'm now moving the data from the four source tables to four target tables. Each in their own mapping. In Workflow Manager, each mapping is a separate session, inside of its own workflow. And then I have a master workflow with four command tasks calling the four workflows. How do I isolate the connections so that each command connects to the target SQL Server database, so that each runs on a different processor? enter image description here EDIT: Informatica also has functionality called "Partitioning", which does exactly what I did here. It splits the data up however you want. But there is some Informatica server level setup for this to work.
Asked by JustBeingHelpful (2116 rep)
Jul 24, 2015, 02:59 AM
Last activity: Aug 20, 2015, 08:59 PM