Latest Answer: Core Dimension is a Dimension table which is used dedicated for single fact table or Datamart. Conform Dimension is a Dimension table which is used across fact tables or Datamarts. ...
After we create a SCD table can we use that particular Dimension as a dimension table for Star Schema.
Suppose your filtering the rows using a filter transformation only the rows meet the condition pass to the target .Tell me where the rows will go that doesnot meet the condition.Thanks in advance
1. What is galaxy schema?2. How many types of hirarechies in datawarehousing concept level?3. How to test report in Business Objects?
1).briefly state different between data ware house & data mart?2).How are u going to consolidate customer infromation in dataware house from the three different back end OLTP applications?3).What is meta data?
Latest Answer: Here's a different way to look at dimensional modelling:Consider data to be a flat table for now. It would have some columns that contain numbers that need to be used in calcualtions later (e.g. basic salary). It would also have some columns that ...
Latest Answer: Cache are stored in Repository. ...
Latest Answer: Interview questions for Data Quality Analyst are as follows:1. How can you say there are no duplicate records in Data warehouse?2. Whether the ETL job accepts known accept records?3. What are the Data Quality Tools? e.g. BO Data Quality, First Logic..etc ...
Latest Answer: In Business Objects Universe Designer you can open Table Browser and select the tables needed then insert them to designer. ...
Latest Answer: Drill across corresponds to switching from 1 classification in 1 dimension to a different classification in different dimenstion. ...
View page << Previous 4 5 6 7 [8] 9 10 Next >>
Go Top
