Latest Answer: Data validation is to make sure that the loaded data is accurate and meets the business requriments.Strategies are different methods followed to meet the validation requriments ...
Latest Answer: hi venkateshdimension , measure, detail are objects type.data types are character, date and numeric ...
don't know
Latest Answer: consider,we are analysing a table with columns "NAME,AGE,DOB".suppose the key for this table be "NAME".So,as the "NAME" column was keyed, it was kept in the virtual memory for quicker retrieval.If the "name" containing ...
A cube can be stored on a single analysis server and then defined as a linked cube on other Analysis servers. End users connected to any of these analysis servers can then access the cube. This arrangement
Latest Answer: Hi All,Could you please let me know what is Replicate Cube & Transparent Cube?Thanks & regards,Amit Sagpariya ...
-
Latest Answer: meta data is stored in repository only not in dataware house .. but we r placing our repository in database in that way ur correct ,,but not directly stored in the dataware house plz check it mam ...
1.what is incremental loading?2.what is batch processing?3.what is cross reference table?4.what is aggregate fact table
Latest Answer: product informationstore time ...
Latest Answer: Diff b.w OLTP and OLAP :------------------------OLTP Schema :* Normalized * More no.of trans* Less time for queries execution* More no.of users* Have Insert,delete and update trans. OLAP (DWH) Schema :* De Normalized * Less no.of trans* ...
Latest Answer: By far, the best ETL tool on the market is Hummingbird Genio.Hummingbird is a division of OpenText, they make, among other things, connectivity and ETL software. ...
Latest Answer: Dimensional modelling consist of 3 stages1.conceptual Requirementshere business architect should be clear with facts and levels (data for Dimension table)2.Logical requirementshere he has to design dimension table with levels, and c=fact table with facts ...
View page << Previous 3 4 5 6 [7] 8 9 10 11 Next >>

Go Top