 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 ... Latest Answer : Client:-* GUI/Presentation logic* Query specification* Data Analysis* Report formatting* Data accessApplication/Data Mart Server:-* Summarizing* Filtering* Meta Data* Multidimensional view* Data accessDW Server:-* Data logic* Data services* Meta 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 ... Answered by kiran on 2005-05-08 09:20:30: Informatica Metadata contains all the information about the source tables, target tables, the transformations, so that it will be useful and easy to perform transformations Latest Answer : Metadata is simply documentation for a digital geospatial dataset. It is a text document that describes the who, what, when, where, why and how questions about the data, so that a potential data user can decide whether or not the data is appropriate for ... Tags : Metadata Latest Answer : You cannot use Informatica to extract data from SAP via ABAP. Only the SAP/Business Objects Data Integrator product can do this.Informatica uses a data dictionary interface, with clear SQL instructions, example...select BUKRS, BELNR, GJAHR, BUZEI ... Latest Answer : ODS is nothing but operational data source. It contains most recent data .it contains around 30-60 days data It is placed in between source system and staging area.. reports can also be taken in ODS . ... Read Answers (7) | Asked by : kumar What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA. Read Answers (3) | Asked by : Andy I'am new to SAS, can anybody explain the process of extracting data from source systems,storing in ODS and how data modelling is done.RegRam Latest Answer : By enablign sorted input property in Aggregator Properties ... Read Answers (1) | Asked by : srujen How you capture changes in data if the source system does not have option of storing date/time field How you capture changes in data if the source system does not have option of storing date/time field in source table from where you need to extract the data? The DW database can be Oracle or Teradata. The requirement here is to pull data from source system and ETL need to device a mechanism to identify the changes or new records. The source system can be a Read Answers (1) | Asked by : GeekNo1
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
