ODI Interface example for processing Multiple Files
ODI Tutorial
ODI Tutorial for beginners
ODI 11g Tutorial
ODI 11g Tutorial for beginners
Views: 14124
TechLake
PL/SQL Tutorial : FORALL with SAVE EXCEPTION
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 2592
TechLake
Oracle SQL Performance Tuning and tips
Cost Based Optimizer (CBO)
Rule Based Optimizer (RBO)
SQL Explain Plan
Oracle Explain Plan
Views: 13743
TechLake
Creating Master and Work Repository in Oracle Data Integrator 11G
ODI Tutorial for Beginners.
Oracle Data Integrator Tutorial
ODI 11g Tutorial
ODI 12c Tutorial
Views: 17457
TechLake
ODI 12c Tutorial Lessions13 CDC Implementation using JKM Journalization knowledge module
Simple JKM CDC Implementation in ODI
ODI 12c Tutorial
ODI 12c Tutorial for beginners
ODI Tutorial
ODI Tutorial for Beginners
Views: 3200
TechLake
Oracle Data Integrator ODI Loadplans with examples, What is Load Plan in ODI and how to use load plan in odi.
ODI Tutorial for Beginners.
Oracle Data Integrator Tutorial
ODI 11g Tutorial
ODI 12c Tutorial
Views: 18943
TechLake
ODI SCD TYPE 3 (Slowly Changing Dimension) Implementation in ODI.
Step1: Create duplicate on update existing rows in IKM Oracle Incremental update and change that code like below
step2: In interface prev_Sal column deselect INSERT and UPDATE and Select UD2 option in quick edit as well as select CUR_SAL UD1.
ODI Tutorial
ODI 11G Tutorial
ODI 11g Tutorial for beginners
ODI Tutorial for beginners
Views: 5400
TechLake
PL/SQL Tutorial: What is PRAGMA AUTONOMOUS TRANSACTION in PLSQL?
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 1335
TechLake
What is Forward Declaration in PL SQL
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 853
TechLake
SQL * Loader Tutorial 3: SQL Loader Conventional and Direct Paths
Difference Between Conventional and Direct path loading in SQL * Loader
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 1655
TechLake
Slowly Changing Dimensions in Data Warehousing Concepts
SCD Type 1
SCD Type 2
SCD Type 3
Data Warehousing Tutorial
Data Warehousing Tutorial for beginners
DWH Tutorial
DWH Tutorial for beginners
Dimensional Modeling
Dimensional Modeling concepts
DWH Concepts
Data Warehousing Concepts
Views: 1856
TechLake
Oracle Hints Tutorial for improving performance with examples
Oracle Hints
Oracle Tutorial for beginners
SQL Tutorial for beginners
SQL Hints
SQL Performance tuning
Views: 3366
TechLake
SQL Performance Tuning 2 and tips
Oracle Performance Tuning
Oracle SQL Performance Tuning Tips
Views: 5580
TechLake
ODI 12c Tutorials Session9 on Loading Data from XML File To SQL Table using ODI Mapping
ODI 12c Tutorial
ODI 12c Tutorial for beginners
ODI Tutorial
ODI Tutorial for Beginners
Views: 3739
TechLake
PL/SQL Tutorial: What is Mutating Table Error in Triggers
What is Mutating Table Error? OR
What is Mutating Trigger Error?
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 3300
TechLake
What is Cardinality and High Cardinality and Low Cardinality in Oracle
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 1047
TechLake
ODI 12c Tutorial Lesson 8 for Loading Data from Flat File (csv) to Table using ODI Mapping
ODI 12c Tutorial
ODI 12c Tutorial for beginners
ODI Tutorial
ODI Tutorial for Beginners
Views: 2926
TechLake
Difference between PL SQL Collections
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 1307
TechLake
SQL 12c Tutorial 23 : SQL Creating PARTITION on Existing Table SQL 12c new feature
SQL 12c New Features
SQL 12c Tutorial for beginners
Oracle SQL Tutorial for beginners
Creating Partition on existing table
Views: 1198
TechLake
SQL 12c Tutorial 21 : SQL 12c Features APPROX_COUNT_DISTINCT
for COUNT & DISTINCT Combination
SQL 12c Tutorial for beginners
Oracle SQL 12c Tutorial for beginners
APPROX_COUNT_DISTINCT for COUNT and DISTINCT
Views: 873
TechLake
PLSQL Tutorial For Beginners 4 : PLSQL Procedures %Type, %ROWTYPE & NOCOPY
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 999
TechLake
ODI 12c Tutorials Lession10 ODI 12c Procedure with Options example
Creating ODI 12c Procedure and Creation Options in Procedure
and using Those Options in ODI Procedure
ODI 12c Tutorial
ODI 12c Tutorial for beginners
ODI Tutorial
ODI Tutorial for Beginners
Views: 2554
TechLake
What is FOR UPDATE and WHERE CURRENT OF Clauses in PLSQL
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 872
TechLake
Oracle Data Integrator Performance Tuning & Tips
ODI 11G Tutorial
ODI 11g Tutorial for beginners
ODI 11g Performance Tuning Tips
ODI Performance Tuning
Views: 2499
TechLake
Types Facts in Data Warehousing
Data Warehousing Tutorial
Data Warehousing Tutorial for beginners
DWH Tutorial
DWH Tutorial for beginners
Dimensional Modeling
Dimensional Modeling concepts
DWH Concepts
Data Warehousing Concepts
Views: 865
TechLake
What is Late Arriving Dimension or Inferred Dimension
Data Warehousing Tutorial
Data Warehousing Tutorial for beginners
DWH Tutorial
DWH Tutorial for beginners
Dimensional Modeling
Dimensional Modeling concepts
DWH Concepts
Data Warehousing Concepts
Views: 819
TechLake
Linux Beginners Tutorials - PS and KILL commands with examples
unix shell script
linux shell script
linux commands
unix commands
linux tutorial
unix tutorial
Views: 1440
TechLake
SQL Tutorial : Difference Between Case & Decode in SQL
Difference Between Case and Decode in oracle
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 1322
TechLake
OBIEE 12c Installations Part 1 on Windows 10
OBIEE 12c Tutorial
OBIEE 12c Tutorial for beginners
OBIEE 12c Step by Step Installations on windows
Views: 1855
TechLake
Oracle Data Integrator know ledge modules explanation
like LKM, IKM, CKM, RKM , JKM and SKM
ODI Tutorial for Beginners.
Oracle Data Integrator Tutorial
ODI 11g Tutorial
ODI 12c Tutorial
Views: 22545
TechLake
SQL 12c Tutorial 20 : SQL 12c Creating Multiple Indexes on column
SQL 12c New Features
SQL 12c Tutorial for beginners
Oracle 12c Tutorial for beginners
Creating Multiple indexes on column
Views: 837
TechLake
SQL Tutorial : Oracle PLSQL Difference Between Procedures and Functions in Oracle
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 1410
TechLake
What is Global temporary Tables in Oracle
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 635
TechLake
SQL 12c General Functions NVL , NVL2, NULLIF and COALESCE
SQL 12c Tutorial for beginners
Oracle SQL 12c Tutorial
NVL
NVL2
NULLIF
COALESCE
Views: 866
TechLake
Oracle PLSQL Tutorials: PLSQL Functions with OUT Parameter & DML Operations inside Function
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 894
TechLake
Oracle Data Integrator Scenario examples, How to generate new scenario and regenerate existing scenario with examples
ODI Tutorial for Beginners.
Oracle Data Integrator Tutorial
ODI 11g Tutorial
ODI 12c Tutorial
Views: 6490
TechLake
SQL 12c Tutorial 22 : SQL 12c Feature TRUNCATE TABLE With CASCADE option
SQL 12c New Features
SQL 12c Tutorial for beginners
Oracle SQL 12c Tutorial for beginners
Views: 743
TechLake
SQL * Loader Tutorial 5: SQL Loader SKIP & FILLER options
SQL * Loader SKIP & FILLER options
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 709
TechLake
SQL 12c Tutorial 16 : SQL Correlated Sub Queries
SQL 12c Tutorial for beginners
Oracle SQL 12c Tutorial for beginners
Oracle Correlated Sub Queries
Oracle Sub Queries
Views: 839
TechLake
SQL 12c Tutorial 19 : SQL IDENTITY Column for generating Sequence Values by default
SQL 12c Tutorial for beginners
Oracle SQL 12c Tutorial for beginners
SQL 12c New Features
Identity columns
Views: 935
TechLake
Difference between substring and instring
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 1028
TechLake
SQL 12c Tutorial 18 : SQL Invisible Column options in SQL 12c New Features
SQL 12c Tutorial for beginners
Oracle SQL 12c Tutorial for beginners
Oracle SQL 12c New Features
Views: 625
TechLake
exchange Partition , Move partition in oracle
Possible operations with partitions
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Add
Drop
Rename
Split
Move ( Moving from Tablespace to tablespace)
Exchange (Table to Table(non Partitioned table)) not partitioned only exchanging data (p)
Views: 1329
TechLake
SQL 12c Tutorial 17 : SQL Inline View Sub-Queries examples
SQL 12c Tutorial for beginners
Oracle SQL 12c Tutorial for beginners
SQL In Line Views
SQL Sub Queries
Views: 1278
TechLake
What is Partition in Oracle and Type of Partitions
Range Partition
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 2219
TechLake
Oracle Data Integrator 12c 12.1.3 Enterprise Installations, Oracle Fusion Middleware Infrastructure installations
ODI Tutorial for Beginners.
Oracle Data Integrator Tutorial
ODI 11g Tutorial
ODI 12c Tutorial
ODI 12c Tutorial for beginners
ODI Installation and configuration
Views: 7641
TechLake
What is a Hash Partition in Oracle
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 948
TechLake
PL/SQL Tutorial : Using RETURNING INTO Clause in FORALL
RETURNING INTO Clause with FORALL & BULK COLLECT
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 483
TechLake
sub partitioning in oracle or composite partitioning in Oracle
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 620
TechLake
ODI 12c Tutorial Lession4 on Topology Overview
How to create Physical Data Server, Physical Schema and Logical Schema and Context in Topology.
ODI 12c Tutorial
ODI 12c Tutorial for beginners
ODI Tutorial
ODI Tutorial for Beginners
Views: 2028
TechLake