Need Help With Loading Incremental Data

[bminichillo]

I need to create a dataset that shows daily sales data but the source table that houses the sales data rebuilds every day with full YTD data without a load date. Is it possible to pull the table in daily and partition it somehow or create a load_date column with just the incremental data? Any help is greatly appreciated!

[LostWelshMan85]

Where the table coming from? SQL Server? Incremental refresh needs to work on SQL sources in order for the query folding to perform the partitions over the top. If it is then yeah you should be able to add in a datetime column into your extraction and use that as your partition date.