11) State some of the benefits of data ware housing?
These are some of the benefits of data ware housing they are: -
1) Regardless of the data source it provides common data model this feature makes analysis of data much easier.
2) Inconsistency is identified during the loading process.
3) In case there is a crash of the database, database programmer can feel comfortable because it is stored in the data ware housing.4) It is very efficient and will not slow down the operational system.
12) What do you think about the future of data ware housing?
Data ware housing will be used by organizations to analyze their huge pool of data.With the development of various data ware house appliances performance of data ware housing applications can be improved. There would be many more apps working in accordance with the Gartner Group report which makes it much user friendly and reliable.
13) State two major differences between a data ware house and operational data ware house?
There exist two major differences they are: -
1) It integrates information from a pre existing source database
2) It is used for analysis usually for OLAP where huge amounts of data occur frequently.
5) Explain about the integrated data ware house stage?
At this stage data ware house gets updated every time a transaction occurs. The transactions performed during this time are passed back to the operational systems which records the transactions.
6)These are some of the questions make sure that you learn many more questions.
read more on : http://www.tipsoninterview.in/data-warehousing-interview-questions
These are some of the benefits of data ware housing they are: -
1) Regardless of the data source it provides common data model this feature makes analysis of data much easier.
2) Inconsistency is identified during the loading process.
3) In case there is a crash of the database, database programmer can feel comfortable because it is stored in the data ware housing.4) It is very efficient and will not slow down the operational system.
12) What do you think about the future of data ware housing?
Data ware housing will be used by organizations to analyze their huge pool of data.With the development of various data ware house appliances performance of data ware housing applications can be improved. There would be many more apps working in accordance with the Gartner Group report which makes it much user friendly and reliable.
13) State two major differences between a data ware house and operational data ware house?
There exist two major differences they are: -
1) It integrates information from a pre existing source database
2) It is used for analysis usually for OLAP where huge amounts of data occur frequently.
5) Explain about the integrated data ware house stage?
At this stage data ware house gets updated every time a transaction occurs. The transactions performed during this time are passed back to the operational systems which records the transactions.
6)These are some of the questions make sure that you learn many more questions.
read more on : http://www.tipsoninterview.in/data-warehousing-interview-questions
No comments:
Post a Comment