Home
Videos uploaded by user “TechLake”
ODI Tutorial : How To Load Multiple Files in ODI
 
10:08
ODI Interface example for processing Multiple Files ODI Tutorial ODI Tutorial for beginners ODI 11g Tutorial ODI 11g Tutorial for beginners
Views: 14151 TechLake
PL/SQL Tutorial : FORALL with SAVE EXCEPTION
 
09:02
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: 2624 TechLake
Oracle SQL Performance Tuning  1
 
06:49
Oracle SQL Performance Tuning and tips Cost Based Optimizer (CBO) Rule Based Optimizer (RBO) SQL Explain Plan Oracle Explain Plan
Views: 13853 TechLake
ODI 12c Tutorial Lessions13 CDC Simple Implementation using JKM Journalization knowledge module
 
24:38
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: 3231 TechLake
Creating Master and Work Repository in Oracle Data Integrator 11G
 
28:09
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: 17482 TechLake
Oracle Data Integrator ODI Loadplans with examples
 
18:17
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: 18968 TechLake
ODI SCD TYPE 3 (Slowly Changing Dimension) Implementation in ODI
 
12:46
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: 5405 TechLake
PL/SQL Tutorial: What is PRAGMA AUTONOMOUS TRANSACTION in PLSQL?
 
04:45
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: 1354 TechLake
PL/SQL Tutorial: What is Forward Declaration in PL SQL
 
04:01
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: 861 TechLake
SQL * Loader Tutorial 3: SQL Loader  Conventional and Direct Paths
 
04:43
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: 1668 TechLake
Slowly Changing Dimensions and Types in Data Warehousing
 
08:26
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: 1876 TechLake
Oracle Hints Tutorial for improving performance with examples
 
11:16
Oracle Hints Tutorial for improving performance with examples Oracle Hints Oracle Tutorial for beginners SQL Tutorial for beginners SQL Hints SQL Performance tuning
Views: 3401 TechLake
SQL Performance Tuning 2 and tips
 
10:56
SQL Performance Tuning 2 and tips Oracle Performance Tuning Oracle SQL Performance Tuning Tips
Views: 5625 TechLake
ODI 12c Tutorials Session9 on Loading Data from XML File To SQL Table using ODI Mapping
 
14:11
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: 3769 TechLake
ODI 12c Tutorial Lesson 8 for Loading Data from Flat File (csv) to Table using ODI Mapping
 
14:27
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: 2959 TechLake
PL/SQL Tutorial: What is Mutating Table Error  What is Mutating Trigger Error
 
06:32
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: 3332 TechLake
What is Cardinality and High Cardinality and Low Cardinality in Oracle
 
05:47
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: 1062 TechLake
PL/SQL Tutorial  4 :  PLSQL Procedures %Type, %ROWTYPE & NOCOPY
 
09:23
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: 1002 TechLake
SQL 12c  Tutorial 21 : SQL 12c Features APPROX_COUNT_DISTINCT
 
03:36
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: 878 TechLake
PLSQL Tutorial: Difference between PL SQL Collections Varray nested table index by table
 
04:07
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: 1321 TechLake
SQL 12c Tutorial 23 : SQL Creating PARTITION on  Existing Table SQL 12c new feature
 
06:20
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: 1219 TechLake
ODI 12c Tutorials Lession10 ODI 12c Procedure with Options example
 
23:36
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: 2581 TechLake
ODI  Performance Tuning & Tips
 
15:35
Oracle Data Integrator Performance Tuning & Tips ODI 11G Tutorial ODI 11g Tutorial for beginners ODI 11g Performance Tuning Tips ODI Performance Tuning
Views: 2522 TechLake
What is FOR UPDATE and WHERE CURRENT OF Clauses in PLSQL
 
04:54
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: 879 TechLake
DWH Tutorial 1 : Types Facts in Data Warehousing
 
04:09
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: 870 TechLake
DWH Tutorial 13 : What is Late Arriving Dimension or Inferred Dimension
 
02:12
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: 823 TechLake
OBIEE 12c : OBIEE 12c Installations Part 1 on Windows 10
 
09:43
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: 1875 TechLake
Linux Beginners Tutorials - PS and KILL commands with examples
 
10:14
Linux Beginners Tutorials - PS and KILL commands with examples unix shell script linux shell script linux commands unix commands linux tutorial unix tutorial
Views: 1461 TechLake
SQL Tutorial : Difference Between Case & Decode in SQL Oracle
 
09:03
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: 1335 TechLake
SQL 12c Tutorial 13  : SQL General Functions NVL , NVL2, NULLIF and COALESCE
 
09:48
SQL 12c General Functions NVL , NVL2, NULLIF and COALESCE SQL 12c Tutorial for beginners Oracle SQL 12c Tutorial NVL NVL2 NULLIF COALESCE
Views: 874 TechLake
Oracle Data Integrator Knowledge Modules LKM,CKM and IKM
 
50:44
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: 22556 TechLake
SQL * Loader Tutorial 5: SQL Loader SKIP & FILLER options
 
06:06
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: 725 TechLake
SQL Tutorial for beginners : What is Global temporary Tables in Oracle
 
06:41
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: 643 TechLake
SQL Tutorial : Difference Between PLSQL Procedures and  Functions
 
09:43
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: 1424 TechLake
SQL 12c Tutorial 20 : SQL 12c Creating Multiple Indexes on column
 
05:33
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: 842 TechLake
Difference between substring and instring
 
06:04
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: 1044 TechLake
PL/SQL Tutorial : PLSQL Functions with OUT Parameter & DML Operations inside Function
 
11:40
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: 905 TechLake
Oracle Data Integrator Scenarios with examples
 
14:39
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: 6496 TechLake
SQL 12c Tutorial 22 : SQL 12c Feature TRUNCATE TABLE With CASCADE option
 
06:21
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: 750 TechLake
SQL 12c Tutorial 16 : SQL Correlated Sub Queries
 
08:52
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: 855 TechLake
SQL 12c  Tutorial 19 : SQL  IDENTITY Column for generating Sequence Values by default
 
08:21
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: 945 TechLake
SQL 12c  Tutorial 18 : SQL  Invisible Column options in SQL 12c New Features
 
03:21
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: 632 TechLake
What is a Partition in Oracle and Type of Partitions , Range Partition
 
10:52
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: 2260 TechLake
SQL 12c Tutorial 17 :  SQL Inline View Sub-Queries examples
 
07:06
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: 1292 TechLake
exchange Partition , Move partition in oracle
 
08:42
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: 1351 TechLake
What is a Hash Partition in Oracle
 
09:07
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: 960 TechLake
Oracle Data Integrator 12c 12.1.3 Enterprise Installations
 
25:06
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: 7652 TechLake
ODI 12c Tutorial Lessons 11 on ODI Procedure with Transaction Isolation and multiple Transactions
 
09:37
ODI 12c Tutorial Lessons 11 on ODI Procedure with Transaction Isolation and multiple Transactions Creating Multiple transactions and Committing end of the tasks using Transactions0, transactioins1..... ODI 12c Tutorial ODI 12c Tutorial for beginners ODI Tutorial ODI Tutorial for Beginners
Views: 865 TechLake
sub partitioning in oracle  or composite partitioning in Oracle RANGE-LIST, RANGE-HASH
 
07:24
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: 626 TechLake
ODI 12c Tutorial 17 Mapping Components FILTER and EXPRESSION  Transformations
 
13:07
ODI 12c Tutorial 17 Mapping Components FILTER and EXPRESSION Transformations ODI 12c Tutorial ODI 12c Transformations ODI 12c Tutorial for beginners Oracle Data Integrator Tutorial
Views: 1200 TechLake