Information Packages(IP) are advanced by some author as a way of building dimensional models - e.g. star schemas. Explain what IPs are and Give an example of it\'s use in building a dimensional model.
Latest Answer: No Tool testing in done in DWH, only manual testing is done. ...
Latest Answer: hierarchy is an ordered series of related dimension objects grouped together to perform the multidimensional analysis.Multidimensional analysis is a technique to modify the data,so that the data can be viewed from different perspectives and at different ...
Latest Answer: Data validation is generally done manually in DWH, in this case if source and TGT are relational you need to create SQL scripts to validate source and target data, and if source is Flat file or non relational database, you can use excel if data is very ...
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: Metadata is the Information about the Data which is being stored in DWH , Why its imp : 1. To know the flow of source data into Data
Warehouse, 2. In case if you have many star schema or many subject areas, knowing that which Area will contain which ...
1.what is incremental loading?2.what is batch processing?3.what is cross reference table?4.what is aggregate fact table
Latest Answer: The possible Data Marts in Retail Sales can be-1) Sales-Sales Order Management and Customer related.Accounts receivables2) Purchase-Purchase Order management and Vendor related.Accounts payables3) Finance-Containing the Consolidation of GL Accounts.General ...
View page << Previous 3 4 5 6 [7] 8 9 10 11 12 Next >>
Go Top
