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 |
What is drilling across?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
Explain how are the dimension tables designed?
Tell me one example for multi valued dimension or bridge table?
2 Answers Accenture, CMC, IBM, Logica CMG, TCS,
what is parallel query?
Explain can report net connect multiple datasource at a time in report creation time?
Can you pass sql queries in filter transformation?
Can any one explain the hierarchies level data warehousing.
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
What is meant by metadata in context of a data warehouse and how it is important?
What is edw?
Explain where do we use semi and non additive facts?