I have a qvd file in which I want to delete some specific row without the using of 'where' clause. Because if I use the where clause that time I have to load the full data I did not want that.
If you want to do any operation on a qvd you have to load it all ... there are not other options unfortinately.
Hope it helps
You can delete rows by using Transformation Step while loading the QVD.
As you can see in the screenshot, row no.6 is selected.
After that on clicking the "Delete Marked " button on the left side, Row no.6 will be deleted.
Thank You all of you for the response. Actually I want to update the qvd. Suppose I want to insert some new row, modify the existing row and want to delete some row. Please suggest what to do?
it sounds very much like you'll have to implement an incremental load here.
There are plenty of resources here in the community to steer you in the right direction, but in summary your load would look something like this:
SQL SELECT [fields]
FROM [existing QVD]
WHERE NOT EXISTS (keyfield) //this covers the modified records
AND NOT (deletion clause); //this covers the deleted records
STORE Facts INTO [existing QVD];