InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Compare No Cache Mode With Partial Cache Mode? |
|
Answer» Upon adding the new rows, the SSIS start analyzing the database. The rows are only considered or allowed to ENTER only if they match with the currently existing data and sometime it creates issues when the rows comes INSTANTLY one after one. On the other side the No Cache Mode is a situation when the rows are not generally cached. Users can customize this mode and can allow the rows to be cached. However, this is one after one and THUS CONSUMES a lot of time. Upon adding the new rows, the SSIS start analyzing the database. The rows are only considered or allowed to enter only if they match with the currently existing data and sometime it creates issues when the rows comes instantly one after one. On the other side the No Cache Mode is a situation when the rows are not generally cached. Users can customize this mode and can allow the rows to be cached. However, this is one after one and thus consumes a lot of time. |
|