Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
suppose i have five tables to load in the application. Among the five table there is one table on which i want to aply incremental load..
Now i want such technique so that the rest four tables must be loaded for the first time load.. when i try to aply the incremental load on fifth table the rest four table should not load again and again...
How can i solve the above said problem..
Thanks in advance
Hi,
Create a script just for loading those four tables and store the resulting data in qvd files. Then, in another qvw document, load qvd data and create a query for updating only the fifth table.
Hi Medina,
How could we store the four table in qvd file as qvd file can only store single table..
And how can i used two or multiple qvd file in single application.
Thanks
you can store single QVD of four different table by performing join operation.
you can use multiple QVD in single application by linking QVD.
Hi,
First create a qvw file, which will only read the four tables from database and store each one in a different qvd file.
Then, in another qvw file you have to read those qvd files in the way:
Load A,
B,
C,
....
file1.qvd
(qvd);
Load A,
B,
C,
....
file2.qvd
(qvd);
and so on.
You can use the wizard for importing qvd files
Hi,
Create a varibale named "v". From Settings->Variable. set value 0.
Copy below Script to your script.
if $(v) = 0 then
LOAD * INLINE [
Data, Min, Max
A, 0, 10
B, 1, 20
C, 2, 30
D, 3, 40
];
ELSE
LOAD * INLINE [
Data1, Min1, Max1
A, 0, 10
B, 1, 20
C, 2, 30
D, 3, 40
];
let v = 1;
end if
Also have a look at the attachment.
Regards,
Kaushik Solanki