|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions 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 ... Read Answers (20) | Asked by : narasimha 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 ... Read Answers (1) | Asked by : rajanikanth How can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause 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 Read Answers (2) | Asked by : tapas 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? Read Answers (20) | Asked by : s.Narasimma subramanian Any one help and answer me for the following question?Question : One employee is working in three different locations. Frequently, the employee changes his work location. Using n-n relationship, how to identify the employee's current location? or how to draw fact table and dimension tables relationship for this concept? Read Answers (3) | Asked by : palani 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 View Question | Asked by : damd 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 ... Read Answers (1) | Asked by : lude 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 ... Read Answers (1) | Asked by : sebastian 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 ... Read Answers (2) | Asked by : ravindra kumar 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? Read Answers (13) | Asked by : naveenreddi
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
