Welcome, Guest
Username: Password: Remember me
Data Warehousing and Data integration
  • Page:
  • 1

TOPIC: Multiple Writers in Transformation

Multiple Writers in Transformation 2 months 1 week ago #19599

I am curious...

If you have multiple writers in a single Transformation (in our case SQL Server tables) would these be managed in a single transaction? I know there are alternative approaches such as calling a Stored Proc that then sets up the commit block but I was wondering if it was possible to avoid a stored proc.

cheers

Please Log in or Create an account to join the conversation.

Multiple Writers in Transformation 2 months 1 week ago #19602

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7736
  • Karma: 33
  • Thank you received: 450
If you have multiple writers in a single Transformation (in our case SQL Server tables) would these be managed in a single transaction\

It would be multiple transactions plus data can be submitted in batches every batch is a separate transaction.
Mike
The following user(s) said Thank You: bruce.gibbins

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 326 guests and one member online