Staging Area | search
Click here to view Staging Area news from 60+ newspapers.
Bookmark or Share- Informatica NetworkInformatica by default uses cookies to enhance your user experience, improve the quality of our website, and deliver advertising and other content tailored to your interests.
- How to create the staging area in your databaseBasically we didn't perform business logic in target area. Apart there are lot of issues like data cleansing issues in source system. In that case we need to maintain staging area. If your data is cleaned and you alrady perform transformations, cleansing issues through ETL specific tool or you have storage issues. Then you may not need staging ...
- Diff b/e ODS and Staging Area? - InformaticaStaging area: A Staging area is a database application consists of temperary data store and staging area application. It receives a portion of data, applies necessary calculations and returns cleaned and finished data for placement into a data store or DWH. The sata can store for limited number of days. Combined Usage of these two :
- Informatica NetworkHi Anna, there is one (in my opinion strong) reason in favour of # 2 or # 3: A staging DB (assuming it's "physically" different from the DB where the original source data are stored) will allow you to impose less burden on the original source DB; just reading the data from there and simply staging them to a staging DB will definitely create the least possible traffic on the source DB server.
- what is cdc and staging area - network.informatica.comWhere as staging area is a temporary location/database where the data is stored temporarily before doing ETL to Warehouse. So staging area sits between source and target. We can do CDC on source and and thus extract only changed records and load them in to staging area
More
