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. ...
How Many different schema's or DW Models can be used in Siebel Analytics. I know Only STAR and SNOW FLAKE. Any other model that can be used??
View page << Previous 3 4 5 6 [7] 8 9 Next >>
Go Top
