QVD Implement Load

[#1]

Hi All,

Can someone please tell me why my implement load keep failing? Even when I comment out the variable vLastRunTime and the QVDs to implement load on and just store small table QVDs....it still fails. I'm attaching my scripting for the QVDs.

Any help would be appreciated.

Thanks in Advance,

[satishkurra]

Hi

As we cannot reload the file, could you please help us in understanding what is the error it throws...

[#3]

Hi,

Thanks for the reply. It doesn't even reload the first table correctly.

[sunny_talwar]

Are you talking about Incremental load?

[Chanty4u]

please post ur error?

[sunny_talwar]

Check if this is a valid location

$(vQVDLocation) -> ..\Data

[#7]

Hi,

For the large tables I'm doing a incremental load but for the small tables I'm doing a regular QVD storage.

Even after changing the QVD location it still gives error.

[sunny_talwar]

Can you try this:

LET vLastRunTime = Date(Today(), 'DD-MMM-YYYY');

ODBC CONNECT TO ExcessionProd;

CustomerCuration:

SQL SELECT *

FROM "rbc_dw"."open".dim1customercuration

Where updatedate > '$(vLastRunTime)';

Concatenate(CustomerCuration)

LOAD *

FROM

(qvd)

where not exists (pkdim1customercuration);

STORE CustomerCuration INTO CustomerCuration.qvd (qvd);

This will save the QVD in the same location as your QVW. If this works, then I would check if you have write access to the other locations.

[satishkurra]

Hi

Please check manually if the below statement is returning any results from DB.

SELECT *

FROM "rbc_dw"."open".dim1customercuration

Thanks

Satish

[Kushal_Chawda]

try changing all store commands. Remove '\'

STORE INTO $(vQVDLocation)CustomerCuration.qvd;

if not working put the store path manually like below

STORE INTO D:\Data\CustomerCuration.qvd;