Do Not Forget to add Business and Flow control to your ETL


Suppose your ETL worked fine at the night window but the users calls you at 08:30 and tell you that the numbers does not figure. Well, there are several reasons for this problems: the data came badly from the OPERATIONAL SYSTEM, something happened to you ETL, or the sales for example where real bad. In order to eliminate the first two you must build control process that decides whether the data are good enough for the users. There are two controls you should have: business control and flow control. The first check the sum, avg… in comparison to the...
אין תגובות