Partial Load

[#1]

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

[kaushiknsolanki]

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

[#3]

Is it not possible to load only updated records with out loading another tables.

[Digvijay_Singh]

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;