Article has interview questions on ODS. Questions are constructed to ensure that the candidate if well versed in the ODS concept and has working knowledge on the same.
What is ODS?
An Operational Data Store (ODS) is an integrated database of operational data. Its sources include legacy systems and it contains current or near term data. An ODS may contain 30 to 60 days of information, while a data warehouse typically contains years of data.
- Tell us something about yourself which is not there in your resume.
- How long you are working on this domain? Despite of having so many domains in IT industry why only operational database management interested you?
- What are the experiences you have gathered from your previous organization? How will you utilize those experiences here? Give one instance.
- What is operational data store according to you? What is its importance in maintaining database of the systems?
- How will you differentiate between a relation and a relation schema? Which has more advantage and why?
- Do you have any idea on functional dependency on database management? If ‘YES’ then say when F (functional dependency) is said to be minimal?
- What is your idea regarding domain oriented calculus and tuple oriented calculus? Which is more beneficial while managing database and why?
- It is being said that operational data store is one of the important tasks in database management. How do you treat this task as?
- Do you have any project idea on operational date store? If ‘yes’ then can you implement it here or you need time to do so?
- What do you prefer to do in your leisure time?
- What is the salary you are expecting for this job?
|
bi & dw basics