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,

[sunny_talwar]

Without any where statement it is only giving you 184 rows? I thought the database was 295k total?

[#3]

Yes the original QVD if I reload it returns 295K.

[sunny_talwar]

Now using the QVD that you have just created, can you try an incremental reload?

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);

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

[#5]

Thanks for all the help you're providing Sunny. The script works but it's still not totaling 295K.

[sunny_talwar]

The only think I can think of is that the your field pkdim1customercuration is not a uniquely associated with an individual row from your database

[#7]

Do you think the variable vLastRunTime = Date (Today(), 'DD-MM-YYYY') might be an issue? It shows 132 new lines.

Thanks again

[sunny_talwar]

It could be. This variable is determining how far back you want to pull the data from your database. May be you want to go back a month:

vLastRunTime = Date(AddMonths(Today(), -1), 'DD-MM-YYYY');

But whatever new is pulled in, your QVD will exclude old unique identifier field where it matches with the new pull (using the Where statement).

[#9]

Hi All,

Does anyone know why I'm getting this error?

Thanks,

[sunny_talwar]

I think the date format seems to be the issue. Right now it is DD-MM-YYYY, whereas it should be DD-MMM-YYYY

[#11]

Thanks but isn't the date format already in the correct format as you've suggested above.