Hi,
I have a flatfile which has to be loaded daily.
In this flatfile there are two columns corresponding to time characteristics. one is calender month and the other calendar day.
Trasactional data never changes and everyday i need to change the day values to todays date and need to upload to BI system.
and if the month changes then i need to change the month (and day ofocurse) and do the upload again.
is there any autmozing process for conversion of these day values to todays value before uploadig?