Duplicate rows in qvd

[#1]

Hi,

Does the qvd allow to store duplicate rows?

Thanks

Puni

[MK_QSL]

Yes.. .Try below...

Sales:

Load * Inline

[

  Customer, Sales

  A, 100

  A, 100

  A, 100

  B, 120

  B, 120

  C, 140

];

Store Sales into Sales.qvd(QVD);

[#3]

Thanks Manish.

I just got to know QVD allows to store duplicate rows, but when we concatenate the qvd data with inline data (contains same data as qvd) removes duplicate

Gone through the following thread

Concatenation - De - duplication of Rows

Thanks

Puni

[MK_QSL]

Kindly clarify little more on you requirements... Thanks

[ashfaq_haseeb]

Hi,

have a look at attached application.

Its works and stores duplicate data too.

Regards

ASHFAQ

[#6]

Hi,

In my IL script testing , I concatenate the data from qvd and data pulled from sql db. I noticed that record count is not in sync between full load and incremental load. I wondered does the qvd stores duplicate record or not.

Now i got clarified that in full load qvd contains all rows though it is duplicate. But in incremental load duplicates are eliminated as i have used CONCATENATE, so qvd contains less rows than full load qvd.

Thanks

Puni