Can you discuss what is meant by an operational data store and how it works?

An interviewer will ask you this question to continue to probe your knowledge of data migration and learn how you use this particular technique in managing a data warehouse environment. As the conversation continues, you'll notice links between the questions previously asked and the ones you are being asked currently. Make sure you are consistent in your answers throughout the interview.

"An operational data store or ODS is where the data is depository between the staging area and the data warehouse. The ODS acts as a temporary data warehouse allowing operators to analyze the business data before fully populates the tables in the data warehouse. Data can remain in the ODS anywhere from minutes two weeks, depending on the need for the data and the operational characteristics of the organization."