InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
If Add The Buffer Command Before Each Load Statement Pulling From Dbms, The First Execution Pulls From The Db But All After Are Incremental Loads Pulling From A File System Created Batch Of Qvds? |
|
Answer» The BUFFER prefix does not provide incremental load when LOADING from a DBMS. SUBSEQUENT reloads will load from the buffered file system QVD, but NEW rows will not be fetched from the database. When used with a load from txt files, BUFFER will provide automatic incremental load. Subsequent reloads will ADD new DATA from the file to the buffered QVD. The BUFFER prefix does not provide incremental load when loading from a DBMS. Subsequent reloads will load from the buffered file system QVD, but new rows will not be fetched from the database. When used with a load from txt files, BUFFER will provide automatic incremental load. Subsequent reloads will add new data from the file to the buffered QVD. |
|