Discussion board where members can get started with Qlik Sense.
I am having a Oracle table on which my incremental app is running (insert/update both)
I am missing records which are getting updated at time when qlik is reading the database.
Is that Qlik locks the database while reading and not able to pick up records which are inserted during the readtime?
QV only passes through the SQL SELECT to the ODBC driver. The ODBC driver and the target DBMS control locking.
Does Qlikview lock tables during load??
It does, but you can use NOLOCK option in your SQL.