Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

INCREMENTAL LOAD AND CONCATENATE

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

2 Replies
swuehl
MVP
MVP

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

Not applicable
Author

Yup Thanks Sir