5.Explain ODS ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to export mappings to the production environment?

576


Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

659


Explain meta data?

635


How many types of facts and what are they?

617


What is recovering sessions?

614






a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

2083


Give some difference between oltp and olap.

674


What is difference macros and prompts?

1807


Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

600


Explain which columns go to the fact table and which columns go the dimension table?

611


What is the difference between view filter and report filter?

605


Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

605


What are the key columns in Fact and dimension tables?

624


What is vdl (view definition language) explain?

722


what is parallel query?

1713