5.Explain ODS ?
Answers were Sorted based on User's Feedback
Answer / amar bandhu
ODS(Operational Data Store) - This has a broad enterprise
wide scope, but unlike the real entertprise data warehouse,
data is refreshed in near real time and used for routine
business activity.
Is This Answer Correct ? | 16 Yes | 0 No |
Answer / nrkreddy
ODS--> Operational Data Store
A database structure that is a repository for near real-
time operational data rather than long term trend data.
the ODS furthur become the enterprise Shared Operational
Databse
to use the ODS as there operation databases
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / dirasanchu
Some times called as staging area. which stores the current
data but not static data....
Is This Answer Correct ? | 4 Yes | 8 No |
Explain normalization?
if you use oracle sql*loader , how do you transform data with it during loading?
Explain difference between snow flake and star schema.
What is Snow Flake Schema design in database?
What is Time Series algorithm in data mining?
What is a cube in data warehousing concept?
Explain hybrid slowly changing dimension?
What is a linked cube?
What is the difference between agglomerative and divisive hierarchical clustering?
What is real-time datawarehousing?
Explain a relation schema and a relation?
Explain what are the basic needs to join two sources in a source qualifier?