user09742

Discussions

Snapshot Historical Data
I'm appending daily data for historical use. Because of the size I don't want store all of the history. I just want the last 8 days only and remove the other dates. How can I do this in ETL? I can filter for the last 8 days, but it still stores other dates data.
number of days in a month
I have a monthly amount that I need to spread equally over the number of days in the month. The data looks like this: Month Value 01-Jan-2012 100000 01-Feb-2012 121002 01-Mar-2012 123123 01-Apr-2012 118239 I have to spread the Jan amount over 31 days, the Feb amount over 29 days and the March amount over 31 days. So I can…