New Data

[Nagaraju_KCS]

HI All,

Can we get New data without Incremental load.

like use last execution date..

I have million's of records.. How can we reload only new data?????

Like

Let vLastReload=  ReloadTime();

Load CategoryID,

        CategoryName,

        Price,

        Model

From Category;

Can we use variable in where Condition ??

Thanks in Advance...

[Nagaraju_KCS]

If i am using without date format

Maxdate:

Load Max("Date") as Maxdate

from Tablename;

LET vIncrementalExpression = 'WHERE DateField>=' & peek('maxdate');

It showing error..

"Convertion failed when converting date and/or time from character string"

where "Date">'42457.957986111'