Increase D_Date beyond 18 May 2027

ivylabs / suitecrm-data-integration

6 stars 5 forks source link

Increase D_Date beyond 18 May 2027 #22

Closed fraserward closed 4 years ago

fraserward commented 4 years ago

10,000 row from 01.01.2000 meaning D_Date ends on 18.05.2027.

Side note: When updating D_Date consider counting rows and adding ETL 'evaluate rows number in a table' to equal rows in D_Date to ensure table is always correctly populated.

fraserward commented 4 years ago

fixed Date Dimension transformation & ETL evaluate rows set to equal 30000