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:32:14: An active transformation can change the number of rows as output after a transformation, while a passive transformation does not change the number of rows and
Latest Answer: Active transformation is nothing but it will change the no of rows passing through it (example) Filter transformation .In it when we have 1000 rows as input after filter transformation according to the condition the output will be modifiedPassive ...
Latest Answer: informatica power center 8.5 ...
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. ...
Latest Answer: 1)ETL Tools IBM Websphere Information Integration(Ascential Datastage) Ab Initio Informatica2)OLAP ToolsBusiness ObjectsCognosHyperionMicrosoft Analysis ServicesMicrostrategy3)Reporting ToolsBusiness Objects(Crystal Reports)CognosActuate ...
Latest Answer: can u plz send the detailed description of each transformationthanx ...
Latest Answer: Hi!Lookups are two types: 1) Connected 2) Unconnected
Connected is further two types 1) Static 2) Dynamic connected lookup is used while returning single or multiple returning values, but unconnected can return only single return value. static and dynamic ...
Lets suppose we have some 10,000 odd records in source system and when load them into target how do we ensure that all 10,000 records that are loaded to target doesn't contain any garbage values. How do we test it. We can't check every record as number of records are huge.
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 . ...
View page [1] 2 3 4 5 6 Next >>
Go Top
