Grokking the Data Engineering Interview
Vote

0% completed

​

Daily Reporting Pipeline: Requirements and Model

A family buys two tickets on day 1 for a film that starts at 00:15, right after the evening shows of day 5, which makes it day 6 by the clock. On which day should a cinema chain's daily report count those tickets? Three answers are possible: day 1, when the money was paid; day 6, the calendar day of the show; or day 5, the evening the cinema staff worked.

Each answer gives different totals. A pipeline that builds a fixed set of tables once a day, by a stated time, is a daily reporting pipeline

.....

.....

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%

Vote for new content