Hi, I use DI Studio to build jobs and run data loads. From time to time, I get error messages about the data set is locked by another process and preventing my jobs to update the data set.
My questions are,
1. Is there a way e.g. in the table loader transformation to have exclusive rights or lock over the data set so that I can load the data like in Teradata, there is a row access locking statement to implement?
2. If I create/load a table as a view in DI using a source data set and if some one is using the view, will it prevent me from updating the source data set?
Thanks,
Lobbie
... View more