Oracle Data Integrator Essentials – Packt Publishing

Oracle Data Integrator EssentialsDevelop, deploy, and maintain your own data integration projects with a clear view of Oracle Data Integrator essentials and best practicesDevelop, deploy, and maintain your own data integration projects with a clear view of Oracle Data Integrator essentials and best practicesAbout This VideoDevelop the necessary skills for effectively carrying out data integration and transformations in ODI interfacesUnderstand the use of ODI development objects with methods and concepts illustrated from real projectsMaster the key concepts of ODI’s physical and logical architecture and the use of Knowledge Modules and data modelsIn DetailOracle Data Integrator (ODI) is Oracle’s strategic tool covering all your data integration requirements. ODI lets you write custom code easily, extract data from source files, transform data in a staging area, and load this data to your target database. So, if you are a database administrator with an aim to effectively use ODI as a powerful tool for data integration solutions, it’s time you started making the most of it.This video course will show you how to use ODI for your data transformation and integration projects. It will also provide you with valuable input on which methods to use for various ODI objects according to the situation, with examples based on real-life requirements.Covering all the key ODI concepts, this video course shows you how to make the best use of ODI’s declarative approach to define your strategy with Knowledge Modules.First, you are made familiar with the basics of ETL processes and then learn how to use of ODI development objects with the help of practical examples. You then move on to get an understanding of ODI’s transformation vehicles and its interface, followed by how ODI packages can be used to develop more workflow-based data integration tasks. Next we show you how reusable objects can be customized by using variables to suit your needs. The following sections broaden your understanding of topologies, scenarios, load plans, and data integration solutions.By the end of the course, you will have enough knowledge of ODI, development, deployment, and maintenance techniques to give you the confidence to develop your own data integration projects.Get Oracle Data Integrator Essentials – Packt Publishing , Only Price $37Course CurriculumThe ODI Core ConceptsKey ODI Concepts (2:53)Differentiating between ETL and (1:42)Exploring the Graphical UI (4:38)ODI Basics (8:00)Defining Your Strategy (2:53)The ODI Staging Area (4:09)tDeveloping in ODI – the Core ObjectsOrganizing Your Project (3:07)Creating an Interface (10:29)Using Joins, Data Sets, Filters, and Sequences (4:50)Using Temporary Interfaces and Lookups (3:22)Your Data Transformation Strategy – Knowledge ModulesAdapting Knowledge Modules to Your Needs (5:34)Executing Data Transformation in an ODI Interface (3:07)Executing a Mapping on Your Source (2:25)Workflows in ODICreating a Workflow in ODI (7:18)Reusable Workflows: Procedures (3:53)tUser Functions as Useful Functions (3:32)Customize Development Objects in ODI (4:25)Data Quality and Delta DetectionOracle Data Quality Products (5:15)Using Data Integrity Controls and Integrating Data Quality in ODI (2:28)Running EDQ (2:54)Delta Detection via CDC (4:31)Version Management and DeploymentVersion Management (3:34)Scenarios: Smallest Deployment Units (4:02)Solutions (2:36)Export and Import (2:54)Operating and MaintenanceLoadplans (5:11)ODI Repository Tables (3:11)tSecurity (4:29)Additional Supporting FunctionsHow to Automate ODI Object Creation (4:29)Impact and Data Lineaging (3:03)ODI Studio Enhancements (3:39)Get Oracle Data Integrator Essentials – Packt Publishing , Only Price $37Tag: Oracle Data Integrator Essentials – Packt Publishing  Review. Oracle Data Integrator Essentials – Packt Publishing  download. Oracle Data Integrator Essentials – Packt Publishing  discount. database product. oracle sql. oracle query. oracle vs sql server. oracle architecture