Latest Answer: Hi,
Slicing and Dicing is a feature that helps us in seeing the more detailed information about a particular thing.
For eg: You have a report which shows the quarterly based performance of a particular product. But you want to see it ...
Explain the flow of data starting with OLTP to OLAP including staging ,summary tables,Facts and dimensions.
What are the various attributes in time dimension, If this dimension has to consider only date of birth of a citizen of a country?
Latest Answer: Source qualifier is a transformation which extracts data from the source. Source qualifier acts as SQL query when the source is a relational database and it acts as a data interpreter if the source is a flatfile. ...
Latest Answer: A surrogate key is a substitution for the natural primary key. We tend to use our own Primary keys (surrogate keys) rather than depend on the primary key that is available in the source system. When integrating the data, trying to work with ...
Latest Answer: BO is a ROLAP Tool,Cognos is a MLAP Tool and MicroStrategy is a HLAP Tool ...
What is the difference between star schema and snow flake schema ?and when we use those schema's?
What is cube and why we are crating a cube what is diff between etl and olap cubes any budy ans plz?
Latest Answer: ODS: this is operational data stores, which means the real time transactional databases. In data warehouse, we extract the data from ODS, transform in the stagging area and load into the target data warehouse.I think, earlier comments on the ODS is little ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>

Go Top