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 swot analysis?
Fact table is in normalized or de-normalized form?
What is degenerate dimension table?
what is data validation strategies for data mart validation after loading process
Explain is fact table?
why oracle is the best database for data warehousing?
Explain functional dependency?
Can decision tree be implemented using SQL?
What is static and local variable?
Explain what are non-additive facts in detail?
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
What are snapshots? What are materialized views & where do we use them?