Skip to Content

Sql Transform nolock vs Views ?

Mar 16, 2017 at 04:54 AM


avatar image
Former Member

Hi all ,

In my project I need to stage the data from OLTP system to the staging database.

I have seen that in SQL transform we can keep with (no lock) and run the job.

So my question is , is it better to create views and get the data from that or is it better to user sql transform with (no lock) ? Which one is recommended out of these two.

More over if we use the SQL transform do we have my performance issues ??


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Magesh Subramanian Mar 16, 2017 at 08:29 PM

Using SQL transforms in the job may not result in performance issues. But it has some serious drawbacks such as not having the ability to do the impact lineage analysis. Usage of SQL transforms are not recommended , instead use other built-in transform to perform the extractions.After all Data Services is an ETL tool :)

10 |10000 characters needed characters left characters exceeded