Skip to Content
avatar image
Former Member

Sql Transform nolock vs Views ?

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 ??

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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 :)

    Add comment
    10|10000 characters needed characters exceeded