I want to generate records with row over row effective valid beginning date and effective end date dependencies
The first record would have an effective date of 1900/01/01 and an effective end date of a random date value.
Then each subsequent record would have an effective begin date that would be the effective end date from the previous record.
The last version of a row of a specific ID would have an effective end date of 9999/01/01.
The number of iterations for a given ID is variable.
File could look like that.
Is this something possible with Mokaroo?
ID EFF_BEGIN_DATE EFF_END_DATE
1 1900/01/01 2015/02/18
1 2015/02/18 2016/05/12
1 2016/05/12 9999/01/01
2 1900/01/01 2012/03/13
2 2012/03/13 2014/05/12
2 2014/05/12 2015/01/23
2 2015/01/23 9999/01/01