Hello experts,
I am getting below in my test environment and it is working in Dev.
Inserts:
LOAD *
FROM
$(Vqvxpath)dim_account_inserts.qvx(qvx);
date_dim_account:
LOAD Max(account_record_updated_datetime) as dim_account_Maxdate
Resident Inserts;
LET VDate_dim_account = Peek('dim_account_Maxdate',0,'date_dim_account');
DROP Table date_dim_account;
STORE Inserts into $(Vqvdpath)dim_account.QVD(qvd);
DROP Table Inserts;
Updates:
LOAD *
FROM
$(Vqvxpath)dim_account_updates.qvx(qvx)
Where (account_record_updated_datetime >'$(VDate_dim_account)') ;
Concatenate
LOAD *
FROM
$(Vqvdpath)dim_account.qvd(qvd)
Where not Exists(account_key);
STORE Updates into $(Vqvdpath)dim_account.QVD(qvd);
DROP Table Updates;
Can anybody help me this one.
Regards,
kumar