Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Can someone please help me with the Concatenate and incremental Load for Insert only.
As per my understanding incremental load is like SQL insert /Update statement, if wrong please correct
Kindly go through the example given below
INITIAL LOAD
TEMP1:
Load
EmpID,
Name,
Designation
FROM
…….TAB1
STORE TEMP1 INTO TEMP1 QVD;
TEMP2:
Load
EmpID,
Name,
Designation
FROM
…….TAB1
Now table TEMP1 contains EmpID record from 1-8 and table TEMP2 contains EmpID record from 9-15,The Stored qvd TEMP1.qvd contains he record of both the table….i understood both the tables got concatenated how will i differentiate it from Incremental load.
Thanking You
Vinayagam
I would suggest that you download the QV cookbook from Rob's download page, where you'll find a detailed and commented script for all kind of incremental loads (also insert only type).
robwunderlich.com/downloads/cookbook_v10c_PE.zip
Yup Thanks Sir