Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How are extraction and data transformation rules managed?

April 26, 2017Data extraction managed rules Transformation

0

Posted

How are extraction and data transformation rules managed?

1 Answer

0

Posted

An OWB Project is a high-level repository structure that stores and organizes the formal descriptions that define a data warehouse. These definitions include descriptions of data sources, target warehouse objects, mappings of source data to various targets, transformation operations, and configuration parameters. OWB generates and stores numerous scripts in a Project. As a warehouse project evolves, developers use OWB to configure and validate warehouse definitions and then use OWB to generate scripts to create and load the data warehouse. OWB also deploys scripts to a file system so the operations staff can run the daily operation using Oracle Enterprise Manager and Oracle Workflow.