Development Online Course by Udemy, On Sale Here
Find out how to create and manage Data warehouse and ETL life cycle with ODI
An excellent training about Database Design & Development
Learn Data Warehouse and ODI 11g – Step by Step Guide
Would you like to be a data warehouse expert with IndependentConcept Data Warehouse Training? In order to professionalize you at this topic, we gathered up all of the trainings and performed the application of thetheorical informations to provide a better education. After obtaining these informations, youll learn the Data Warehouse systems and its properties. In this training, all of the abilities that a Data Warehouse & Business intelligence specialist must have will be explained. In the end of the course, well present a live sample of data warehouse. By using ODI (Oracle Data Integration) in the trainings content, you wont need to do extra payment for the training of ETL tools. Youll be able to have a wide range of informations over the topics listed bellow: Data Warehouse Data, Entegration, KnowledgeData Warehouse DefinitionETL/ELT ArchitectureIncremental LoadBatch LoadReal Time LoadChange Data CaptureReal TimeContinuoslyBatchSlowly Changing DimensionData ModellingConceptual Data ModelLogical Data ModelPhysical Data ModelFact TableDimension TableOperational Database Properties and structure(OLTP)Data Warehouse Schema ArchitectureStagingn Area Properties and structure(STG)Operational Data Store Properties and structure(ODS)Datawarehouse Properties and structure(DWH)Datamart Properties and structure(DM)Data ProfilingData QualityData CleaningMetadata ManagementEnd to End Data Warehouse Project Demo ODI (Oracle Data Integrator) Introduction to Oracle Data Integrator 11gIntroduction to oracle Data integratorODI Studio ComponentsODI RepositoriesCreating Master RepositoryCreating work RepositoryOverview of Topology NavigatorCreating Physical ArchitectureCreating a Data ServerTesting a Data Server ConnectionCreating a Physical SchemaCreating Logical ArchitectureOverview of Logical Architecture and Context ViewsLinking the Logical and Physical ArchitectureUnderstanding Metadata in ODIUnderstanding Reverse EngineeringCreating ModelsOrganizing ModelsCreating Data storesOverview of ODI ProjectsCreating a New ProjectIntroduction to Knowledge ModulesTypes of Knowledge modulesCreating a Basic InterfaceDesigning an InterfaceIntegration knowledge module (IKM) overviewUsing Knowledge Modules (KM) with ODI InterfaceExecuting the interfaceOperator OverviewViewing the session log in operatorExploring the code in operatorCreating simple mappingsSetting knowledge module option Truncate to TrueJoin TransformationsSet Operators TransformationsImplementing SCD Type-1 TransformationsImplementing SCD Type-2 TransformationCreating Packages in ODIWhy you should have this course?Because; Im not just talking about the concept, but with its installations, Im moving on with examples over ODI suitable for data warehouse structure and heavily used in the sector. Despite the course language is English, Im providing English subtitles support in order not to miss important points. With various documents and end-of-chapter quizes, I aim to reinforce the topics. As being more than 10 years in the sector and being an instructor in companies that have big DWH structures, I provide this course. You are choosing an instructor that can provide support for any type of questions about the training or about DWH structures that does not fall within the training.
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.