pls answer this.. For incremental load this is used only in case of .txt file update.why this is not used in case of incremental load for db insert or update and delete ??
@@AbhishekAgarrwal Note that the incremental option can only be used with LOAD statements and text files and that incremental load cannot be used where old data is changed or deleted!
Very good explanation.
pls answer this..
For incremental load this is used only in case of .txt file update.why this is not used in case of incremental load for
db insert or update and delete ??
using the txt file is not a requirement for incremental load. You can use the database tables as well.
@@AbhishekAgarrwal Note that the incremental option can only be used with LOAD statements and text files and that
incremental load cannot be used where old data is changed or deleted!