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 |
How to eliminate duplicate rows from flat file?
what are the major three types of modeling used?
0 Answers InfoAxon Technologies,
What is difference between Mapplet and reusable transformation?
Explain is olap databases are called decision support system true/false?
What are non-additive facts in detail?
Is there any difference in testing database and data ware housing?
Why facts table is useful in representing the data?
Database in use is oracle?
Explain the difference between view and materialized view?
Explain what is cost benefit analysis (cba)?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?