i want load 1 table data 1 month starting 1 april 30 april in successive manner. i.e after loading data 1 april, date should automatically increment 2, load data , increment , on, till 30 april. also, data of 2 april depends on 1 april data. cannot give date range load randomly.
how can it? preferable loads done in single session run, instead of running session several times.
sort source data date , use transaction control transformation enforce commit every time date changes.
