1 Reply Latest reply: Jun 10, 2016 3:46 AM by Максим Рыбалко RSS

    reload from database interrupted

    Andrzej Mykowski



      I'm reloading data from Oracle database. It returns normally ca. 500k records. So with the transformations QV loads it for about an hour.

      Today I started the reload at t, and after 0,5 hrs someone truncated the database table [so in the middle of the reload process].


      My question is: if the QV started to process "SQL Select" part will I get all the data [500k]?

      General question: does QV first executes the SQL SELECT and then stores all data from the query [how] and then transforms it or does it do it in parts [get 1 ->transform 1 ->get 2 -> transform 2 -> concatenate .....]?






      the data came through complete so i assume that first the SQL SELECT is executed as a whole, if someone could confirm it would be nice.