Latest Answer : Validation Strategies Data validation strategies are often heavily influenced by the architecture for the application. If the application is already in production it will be significantly harder to build the optimal architecture than if the application ...
How can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause whenever u select the source data in informatica it shows it can take only character data
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?
Hi I urgently need some precise infos to the following questions..What kind of data will be stored in a big mortgage company data warehouse?What is the size of tables(number of row, column), number of records?Also how do you conduct a dta warehouse testing? steps of warehouse testing?Thanks
Latest Answer : In DWH loops may exist between the table. If loops exist, then query generation will take more time, because more than one path is available. It creates ambiguity also. Loops can be avoided by creating aliases of the table or by context.. i.e. defining ...
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 ...
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?
1. What is galaxy schema?2. How many types of hirarechies in datawarehousing concept level?3. How to test report in Business Objects?
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. ...
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 ...
