Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\doc\welcome\de\etl.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xmlns:xi="http://www.w3.org/2001/XInclude"> <head> <title>Design ETL Processes</title> <style type="text/css"> BODY { font-family:Tahoma; font-size:11pt; background-color:#FFFFFF; color:#006699; } TABLE { border:none; border-width:0px; padding:0px; vertical-align:top; font-family:Tahoma; font-size:11pt; } TR { vertical-align:top; } #each_block { color: #006666; position:relative; width: 247px; text-align: left; padding: 3px; } .menuItemEna{ font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; color:#000000; background-color: #F0F0F0; } .menuItemOver{ font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; color:#FFFFFF; background-color: #316AC4; } #header_text { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; font-style: normal; font-weight: bold; color: #003399; } #icon_area { width:20px; margin-top:2px; } #top_menu_home_style { margin-right: 20px; margin-left: 10px; color:#000000; } #top_menu_current_style { font-weight: bold; color: #000000; } #bottom_menu_bar { width: 100%; background-color:#666666; min-width: 800px; font-family:tokoma; color:#FFFFFF; height: 40px; font-size:11pt; vertical-align:middle; margin-bottom: 10px; } #each_item{ padding:4px; position:relative; top:30%; } #instructional { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; font-weight: normal; color: #666666; } #title_text{ color:#000000; font-size:11px; font-family: Verdana, Arial, Helvetica, sans-serif; position:absolute; top:5px; left: 64px; width:324px; top:7px; } #title_area { position:absolute; top:0px; left:0px; } #coming_soon { color:#3366FF; font-size:11px; font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; } #footer{ height: 55px; position: fixed; bottom: 0; left: 0; width: 100%; background-color:#FFFFFF; font-size: 13px; font-family:Verdana, Arial, Helvetica, sans-serif; } #footer_content{ background-color:#9da3ad; height: 33px; vertical-align: middle; } #links{ margin-top: 10px; width: 700px; } #copyRight_block { background-color:#FFFFFF; margin-top:5px; height:20px; font-family: Tahoma, Kalimati, FreeSans, Verdana, Arial, sans-serif; } A.bottomBannerItem{ font-size: 12px; color: #ffffff; text-decoration:none; font-family: Tahoma, Kalimati, FreeSans, Verdana, Arial, sans-serif; } A.bottomBannerItem:hover { font-size: 12px; color: #003399; text-decoration:none; font-family: Tahoma, Kalimati, FreeSans, Verdana, Arial, sans-serif; } A.bottomBannerItem:focus { font-size: 12px; color: #003399; text-decoration:none; font-family: Tahoma, Kalimati, FreeSans, Verdana, Arial, sans-serif; } A.copyRight:link{ color: #333333; font-size:9px; text-decoration:none; margin-left: 7px; font-family: Tahoma, Kalimati, FreeSans, Verdana, Arial, sans-serif; } A.copyRight:hover{ color: #003399; font-size:9px; text-decoration:none; font-family: Tahoma, Kalimati, FreeSans, Verdana, Arial, sans-serif; } A.copyRight:focus{ color: #003399; font-size:9px; text-decoration:none; font-family: Tahoma, Kalimati, FreeSans, Verdana, Arial, sans-serif; } #each_item { color:#FFFFFF; } #seperator { color:#ffffff; font-family:arial; font-size:10px; } </style> <script language="JavaScript" type="text/javascript" src="../subPage_script.js"></script> </head> <body onLoad="iniDrop('Get Started with OWB', 'get_started.html','Model Sources and Targets', 'stm.html', 'Profile, Fix and Monitor Data Quality', 'dq.html', 'Administer and Manage OWB', 'admin.html', '../'); MM_preloadImages('../welcomeImages/navigation_r1_c1_f2.png','../welcomeImages/navigation_r1_c1_f3.png','../welcomeImages/navigation_r1_c5_f2.png','../welcomeImages/navigation_r1_c5_f3.png','../welcomeImages/navigation_r1_c8_f2.png','../welcomeImages/navigation_r1_c8_f3.png','../welcomeImages/navigation_r1_c10_f2.png','../welcomeImages/navigation_r1_c10_f3.png','../welcomeImages/navigation_r1_c12_f2.png','../welcomeImages/navigation_r1_c12_f3.png','../welcomeImages/navigation_r2_c1_f2.png','../welcomeImages/navigation_r2_c1_f3.png')"> <div id="title_area"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr valign="middle"> <td><a href="welcome.html" target="_blank"><img id="homeImg" name="welcome_r2_c2" src="../welcomeImages/welcome_r2_c2.png" width="39" height="25" border="0" alt=""/></a></td> <td><img id="dropButton" name="welcome_r2_c3" src="../welcomeImages/welcome_r2_c3.png" width="24" height="25" border="0" alt=""/></td> <td width="100%" height="25"><span id="title_text" style="top:7px; font-size: 11px"><strong>Design ETL Processes</strong></span></td> </tr> </table> </div> <br/> <table> <tr> <td> <div id="icon_area"> <img src="../welcomeImages/kd_coach.png"/> </div> </td> <td width="247" onmouseover="this.style.backgroundColor='#d8ecfd';" onmouseout="this.style.backgroundColor='white';"> <a href="custom:jdevShowTopic:mappings.htm" style="text-decoration:none;"> <div id="each_block"> <span id="header_text">Create Basic Relational Mappings</span><br/> <span id="instructional">Extract, transform and load data among relational sources and targets, including databases, flat files, and ERP applications.</span><br/> </div> </a> </td> <td width="16"> </td> <td> <td> <div id="icon_area"> <img src="../welcomeImages/kd_coach.png"/> </div> </td> <td width="247" onmouseover="this.style.backgroundColor='#d8ecfd';" onmouseout="this.style.backgroundColor='white';"> <a href="custom:jdevShowTopic:design_processflows.htm" style="text-decoration:none;"> <div id="each_block"> <span id="header_text">Create Process Flows </span><br/> <span id="instructional">Design multi-step data integration processes using a wide variety of activities and complex flow of control.</span><br/> </div> </a> </td> </td> </tr> <tr> <td> <div id="icon_area"> <img src="../welcomeImages/kd_coach.png"/> </div> </td> <td width="247" onmouseover="this.style.backgroundColor='#d8ecfd';" onmouseout="this.style.backgroundColor='white';"> <a href="custom:jdevShowTopic:dim_mappings.htm" style="text-decoration:none;"> <div id="each_block"> <span id="header_text">Load Dimensions and Cubes </span><br/> <span id="instructional">Use OWB's advanced dimensional object support for ETL with dimensions and cubes, including SCD Types 1, 2 and 3.</span><br/> </div> </a> </td> <td width="16"> </td> <td> <td> <div id="icon_area"> <img src="../welcomeImages/kd_coach.png"/> </div> </td> <td width="247" onmouseover="this.style.backgroundColor='#d8ecfd';" onmouseout="this.style.backgroundColor='white';"> <a href="custom:jdevShowTopic:deploy.htm" style="text-decoration:none;"> <div id="each_block"> <span id="header_text">Deploy OWB Jobs</span><br/> <span id="instructional">Push your objects and ETL logic out to your sources and targets.</span><br/> </div> </a> </td> </td> </tr> <tr> <td> <div id="icon_area"> <img src="../welcomeImages/kd_coach.png"/> </div> </td> <td width="247" onmouseover="this.style.backgroundColor='#d8ecfd';" onmouseout="this.style.backgroundColor='white';"> <a href="custom:jdevShowTopic:wbetl07002.htm-CHDHIIJE" style="text-decoration:none;"> <div id="each_block"> <span id="header_text">Use SQL*Loader Mappings for Flat Files</span><br/> <span id="instructional">Get maximum load performance on large data volumes.</span><br/> </div> </a> </td> <td width="16"> </td> <td> <td> <div id="icon_area"> <img src="../welcomeImages/kd_coach.png"/> </div> </td> <td width="247" onmouseover="this.style.backgroundColor='#d8ecfd';" onmouseout="this.style.backgroundColor='white';"> <a href="custom:jdevShowTopic:wbetl12001.htm-BEIDEDIG" style="text-decoration:none;"> <div id="each_block"> <span id="header_text">Execute OWB Jobs</span><br/> <span id="instructional">Run your ETL, data quality or other OWB jobs from the OWB Control Center Manager.</span><br/> </div> </a> </td> </td> </tr> <tr> <td> <div id="icon_area"> <img src="../welcomeImages/kd_coach.png"/> </div> </td> <td width="247" onmouseover="this.style.backgroundColor='#d8ecfd';" onmouseout="this.style.backgroundColor='white';"> <a href="custom:jdevShowTopic:wbetl07003.htm-BEIDGFEC" style="text-decoration:none;"> <div id="each_block"> <span id="header_text">Extract Data from SAP R/3</span><br/> <span id="instructional">Use high performance extraction techniques based on ABAP code and fully supported by SAP.</span><br/> </div> </a> </td> <td width="16"> </td> <td> <td> <div id="icon_area"> <img src="../welcomeImages/kd_coach.png"/> </div> </td> <td width="247" onmouseover="this.style.backgroundColor='#d8ecfd';" onmouseout="this.style.backgroundColor='white';"> <a href="custom:jdevShowTopic:f1_execute_topic.htm-sthref1313" style="text-decoration:none;"> <div id="each_block"> <span id="header_text">View OWB Job Results</span><br/> <span id="instructional">Find out what happened to your deployments and executions, including scheduled executions.</span><br/> </div> </a> </td> </td> </tr> <tr> <td> <div id="icon_area"> <img src="../welcomeImages/kd_coach.png"/> </div> </td> <td width="247" onmouseover="this.style.backgroundColor='#d8ecfd';" onmouseout="this.style.backgroundColor='white';"> <a href="custom:jdevShowTopic:wbetl07005.htm-BABIFJIA" style="text-decoration:none;"> <div id="each_block"> <span id="header_text">Create Code Template Mappings</span><br/> <span id="instructional">Use ODI knowledge modules in OWB mappings for JDBC, non-Oracle databases, bulk data movement and more.</span> </div> </a> </td> <td width="16"> </td> <td> <td> <div id="icon_area"> <img src="../welcomeImages/kd_coach.png"/> </div> </td> <td width="247" onmouseover="this.style.backgroundColor='#d8ecfd';" onmouseout="this.style.backgroundColor='white';"> <a href="custom:jdevShowTopic:scheduling_etl.htm" style="text-decoration:none;"> <div id="each_block"> <span id="header_text">Schedule OWB Jobs </span><br/> <span id="instructional">Use the OWB integrated scheduler to run ETL activities at different times.</span> </div> </a> </td> </td> </tr> <tr> <td><img src="../welcomeImages/kd_coach.png"/></td> <td onmouseover="this.style.backgroundColor='#d8ecfd';" onmouseout="this.style.backgroundColor='white';"><a href="custom:jdevShowTopic:wbetl07008.htm-CHDCIJFI" style="text-decoration:none;"> <div id="each_block"> <span id="header_text">Create CDC Mappings</span><br/> <span id="instructional">Design OWB code template mappings for change data capture and manage change capture processes from Design Center.</span></div> </a></td> <td></td> <td> <td><img src="../welcomeImages/kd_coach.png"/></td> <td onmouseover="this.style.backgroundColor='#d8ecfd';" onmouseout="this.style.backgroundColor='white';"> <a href="custom:jdevShowTopic:design_webservices.htm" style="text-decoration:none;"> <div id="each_block"> <span id="header_text">Publish OWB Jobs as Web Services </span><br/> <span id="instructional">Expose OWB mappings and process flows as web services, for orchestration from Oracle BPEL or similar tools.</span><br/> </div> </a> </td> <td> </tr> <tr> <td> <div id="icon_area"> <img src="../welcomeImages/kd_coach.png"/> </div> </td> <td width="247" onmouseover="this.style.backgroundColor='#d8ecfd';" onmouseout="this.style.backgroundColor='white';"> <a href="custom:jdevShowTopic:src_tgt_opers048.htm-CHDBHCEI" style="text-decoration:none;"> <div id="each_block"> <span id="header_text">Use Queues for Real-Time ETL </span><br/> <span id="instructional">Use queues as sources or targets for batch or trickle-feed data integration.</span><br/> </div> </a> </td> <td width="16"> </td> <td> <td> <div id="icon_area"> <img src="../welcomeImages/kd_coach.png"/> </div> </td> <td width="247" onmouseover="this.style.backgroundColor='#d8ecfd';" onmouseout="this.style.backgroundColor='white';"> <a href="custom:jdevShowTopic:wbetl16005.htm-BABEFDEB" style="text-decoration:none;"> <div id="each_block"> <span id="header_text">Consume Web Services</span><br/> <span id="instructional">Call external SOAP-based web services in process flows.</span><br/> </div> </a> </td> </td> </tr> <tr> <td><img src="../welcomeImages/kd_coach.png"/></td> <td onmouseover="this.style.backgroundColor='#d8ecfd';" onmouseout="this.style.backgroundColor='white';"> <a href="custom:jdevShowTopic:etl_performance.htm" style="text-decoration:none;"> <div id="each_block"> <span id="header_text">Optimize Mapping Performance</span><br/> <span id="instructional">Take full advantage of hints and other features to run your ETL faster.</span> </div> </a> </td> </tr> </table> <div id="footer"> <div id="footer_content"> <div id="links"> <span> </span> <a class="bottomBannerItem" href="custom:jdevShowTopic:whatsnew.htm"> <span>What's New</span> </a> <span id="seperator"> | </span> <a class="bottomBannerItem" href="custom:jdevInvokeBrowserOnFile:ReleaseNotes.html"> <span>Release Notes</span> </a> <span id="seperator"> | </span> <a class="bottomBannerItem" href="custom:external:http://www.oracle.com/technology/products/warehouse"> <span>OWB on OTN</span> </a> <span id="seperator"> | </span> <a class="bottomBannerItem" href="custom:external:http://www.oracle.com/technology/products/warehouse/htdocs/OTN_viewlet.html"> <span>Viewlets</span> </a> <span id="seperator"> | </span> <a class="bottomBannerItem" href="custom:external:http://www.oracle.com/technology/documentation/warehouse.html"> <span>Documentation</span> </a> <span id="seperator"> | </span> <a class="bottomBannerItem" href="custom:external:http://www.oracle.com/technology/products/warehouse/htdocs/OTN_Training.html"> <span>Training</span> </a> <span id="seperator"> | </span> <a class="bottomBannerItem" href="custom:external:http://blogs.oracle.com/warehousebuilder"> <span>News and Tips Blog</span> </a> <span id="seperator"> | </span> <a class="bottomBannerItem" href="custom:external:http://forums.oracle.com/forums/forum.jspa?forumID=57"> <span>Forum</span> </a> </div> </div> <div id="copyRight_block"> <a href="custom:jdevShowHelpInWindow:help_legalnotices_html" class="copyRight">Copyright © 2000, 2009 Oracle. All rights reserved.</a> </div> </div> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de