Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have done incremental load.N can one can tell me how to get the data for the last one day or two days for a month.I mean if i have 30 days of data i need the last two days of data.
Can anyone tell me how to do this if possible pls attach ur copy.
Regards,
Bharat
do you mean that you always have to load the application with the data for the last two day of the month? If so, then create variables which would identity the last day and last but one day of the month for which you are loading the data and use these variables in the where condition of the SQL statement. So, whenever the document is reloaded, only the last two days' data for the corresponding month will be loaded.
Cheers,
Haneesh