Hi,
I was just curious if there is a parallel stage that is similar to the server stage "MS SQL Server Load".
Thanks - - John
Question on MS SQL Server Load stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Does not the SQL Server Connector stage have a "bulk load" capability?
This stage type only exists if DataStage engine runs on Windows Server; otherwise you can use the ODBC Connector, but it does not have a bulk load capability.
This stage type only exists if DataStage engine runs on Windows Server; otherwise you can use the ODBC Connector, but it does not have a bulk load capability.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Actually the Connector does have bulk load capability - if you enable "bulk load" in the ODBC driver definition. I'm using that capability right now (literally, since we are loading our data warehouse with the initial data contents as I write this) and the performance gain compared to the normal insert mode is very significant, two orders of magnitude.
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am