topic how to load huge data from oracle with insert and update !!! in QlikView

how to load huge data from oracle with insert and update !!!

qliklearnervir — Sat, 16 Nov 2024 20:32:45 GMT

Hi,

I have over 150 millions rows daily to make insert or update scenario .

is there any best way to handle these things in qlik or similar to SQL , we can use Update syntax.

Re: how to load huge data from oracle with insert and update !!!

Brett_Bleess — Mon, 29 Jul 2019 21:22:40 GMT

We do not recommend using QilkView for updating of backend data sources, we are primarily an analytics tool, not a database update tool, so not really sure what you are attempting to do, but I would believe it is likely best done using straight SQL in the DB side. If you can provide further information regarding the full use case here, we may be able to provide a better answer, but this is the best I can do at the moment.

It is possible to make SQL Execute and other calls from our script editor, but you must enable the setting in the attached screenshot in that case, but again, this is not something we recommend doing.

Regards,
Brett

Re: how to load huge data from oracle with insert and update !!!

ramasaisaksoft — Tue, 30 Jul 2019 05:39:44 GMT

Hi Vir,

As you know we (QlikView) will create Reports with the help of existing Data base /Tables and we have the capability inbuilt ETL (Extraction, Transformation, Loading)process in QV.

But we will support this a very little bit like Creating Incremental Load ,Simple Joins,Concatenation...etc.

So my recommendation to you is, Request either DB team/ETL team to finish the update things at DB level and get the data from that updated DB tables into QlikView script.

UPDATE Syntax

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

Note: Be careful when updating records in a table! Notice the WHERE clause in the UPDATE statement. The WHERE clause specifies which record(s) that should be updated. If you omit the WHERE clause, all records in the table will be updated!