Latest Answer: Dimensions mainly 11 types. They are1. Changing Dimensions: At least one attribute value would change over the time.2. Slowly Changing Dimension: Attributes of a dimension that would undergo changes very rarely and commonly over the ...
What is the difference between database and data warehousing?What is the main advantages of data warehousingWhat is mean by data stageWhat is the famous tools used for data warehousing?What is the architecture of data warehouisng model?
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: SAS gets adopted by the business groups that do not have a large IT support staff as SAS provides the complete DW environment including ETL and reporting in one easy to manage package. See http://www.dwoptimize.com/2007/02/latest-data-warehouse-industry-trends.html ...
Latest Answer: Context is basically used when we will have conformed dimension in the loop........ ...
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
Latest Answer: Data cleaning is a self explainatory term. Most of the data warehouses in the world source data from multiple systems - systems that were created long before data warehousing was well understood, and hence without the vision to consolidate the same in ...
Latest Answer: STAR SCHEMA HAS fact table linked with dimension table directlywhile in snow flake schema the dimension tables can have futher hierarchies between them .it means in snow flake schema the tables are normalised.one shoula use star schema simply it is easy ...
Latest Answer: It is a column, which we when update the OLTP ...
Latest Answer: It Supposed to be Numeric Its Like Serial Numbers ...
View page [1] 2 3 4 5 6 7 8 9 Next >>

Go Top