![]() |
| 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 Answered by Laxmi on 2005-05-13 16:42:53: Staging area is place where you hold temporary tables on data warehouse server. Staging tables are connected to work area or fact tables. We basically need staging Latest Answer : The staging area is:- One or more database schema(s) or file stores used to “stage” data extracted from the source OLTP systems prior to being published to the “warehouse” where it is visible to end users.Data ... Answered by kiran on 2005-05-08 09:27:46: Power Mart is designed for: Low range of warehouses only for local repositories mainly desktop environment. Power mart is designed Latest Answer : Power Center is designed for:High-end WarehousesGlobal as well as local repositoriesPower Mart is designed for:Low-end WarehousesOnly for local repositories ... Latest Answer : ETL tool is used for Extration ,Transformation(filtering) and loading the data into data warehouse .OLAP tools are used to analitical purpose basically for report generation i.e to retrieve the data from dataware,OLAP is multidimensional model. ... Read Answers (9) | Asked by : anil rao Latest Answer : The full form of ODS is Operational Data Store.ODS is a layer between the source and target databases..ODS is used to store the recent data.Staging layer is also a layer between the source and target databases..Staging layer is used for cleansing purpose ... Read Answers (2) | Asked by : nagireddy In What scenario ETL coding is preferred than Database level SQL, PL/SQL coding? What is the methodology and process followed for ETL testing in Data warehouse environment? Develop a mapping to extract the employee drawing maximum salary where deptno = department drawing... If LKP on target table is taken, can we update the rows without update strategy transformation? How you capture changes in data if the source system does not have option of storing date/time field... What is the Difference between Read Answers (1) | Asked by : srihari
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||