It started with a 30-minute call with a recruiter who wanted to hear about my career. The next stage was a Zoom meeting where I was asked to describe in detail some components I developed in the data platform I worked on and eventually, I was asked regarding a use case.
Preguntas de entrevista [1]
Pregunta 1
How would I deal with a case in which the data is not fully enriched during the last 7 days in the target fact table?
The expected answer was creating 2 tables; one for the history and one for the last 7 days which will be updated by the increments.
The users will query the union of both.