Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi Community,
I have couple of doublts on Partial load like below.
Ex :
Table
Dim1
1
2
3
Now
I have replaced 3 with the value of 4 in Dim1 like,
Table
Dim1
1
2
4
what should I use here
Hi,
You should just use the full load.
Partial load is used to add a new table in your datamodel, without loading other tables.
Regards,
Kaushik Solanki
Is it not possible to load only updated records with out loading another tables.
For that we need to maintain timestamp in source file to recognize which records are changed after last reload.
Something like this - Search 'QVD files and Incremental Load' in help, you will get more details
QV_Table:
SQL SELECT PrimaryKey, X, Y FROM DB_TABLE
WHERE ModificationTime >= #$(LastExecTime)#;
Concatenate LOAD
PrimaryKey, X, Y FROM File.QVD
WHERE NOT Exists(PrimaryKey);
STORE QV_Table INTO File.QVD;