Home
Videos uploaded by user “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: 19840 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: 15176 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: 3489 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: 4184 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: 1930 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: 20345 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: 4373 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: 18129 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: 2125 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: 4743 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: 4961 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: 1731 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: 3308 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: 1166 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: 1275 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: 1632 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: 5647 TechLake
SQL Performance Tuning 2 and tips
 
10:56
SQL Performance Tuning 2 and tips Oracle Performance Tuning Oracle SQL Performance Tuning Tips
Views: 8071 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: 1229 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: 3817 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: 5150 TechLake
ODI 12c Tutorials 2  Repository Creation using RCU Utility
 
14:41
ODI 12c Tutorials 2 Repository Creation using RCU Utility Creating Master and Work Repository in ODI 12c using RCU Utility. ODI 12c Tutorial ODI 12c Tutorial for beginners ODI Tutorial ODI Tutorial for Beginners
Views: 7869 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: 1275 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: 1578 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: 1179 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: 2637 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: 3590 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: 1411 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: 1499 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: 1850 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: 1381 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: 23744 TechLake
SQL * Loader Tutorial : SQL * Loader Interview Questions  & Answers
 
05:11
SQL * Loader Tutorial : SQL * Loader Interview Questions & Answers Oracle SQL Loader Oracle SQL * Loader interview Questions 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: 2093 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: 920 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: 1282 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: 1898 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: 1930 TechLake
SQL 12c Tutorial 24 : SQL Temporal Validity PERIOD FOR Clause 12c Features
 
06:04
SQL 12c Tutorial 24 : SQL Temporal Validity PERIOD FOR Clause 12c Features SQL 12c Tutorial for beginners Oracle SQL 12c Tutorial for beginners Oracle 12c New Features for developers
Views: 798 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: 847 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: 6862 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: 1307 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: 3117 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: 960 TechLake
PL/SQL Tutorial : PLSQL Collections and Types
 
10:15
PLSQL Collections and Types Varray Nested Table Index By Table 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: 2028 TechLake
ODI 12c Tutorial 20 SORT Transformation
 
04:15
ODI 12c Tutorial 20 SORT Transformation ODI 12c Transformations ODI 12c Tutorial ODI 12c Tutorial for beginners ODI 12c Mapping Components
Views: 1067 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: 1755 TechLake
ODI 12c Tutorial 18 Mapping Components  Join Transformations
 
09:59
ODI 12c Tutorial 18 Mapping Components Join Transformations ODI 12c Tutorial ODI 12c Tutorial for beginners ODI 12c Transformations Oracle Data Integrator Tutorial for beginners Oracle Data Integrator Transformations JOIN Transformation
Views: 1662 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: 1929 TechLake
PL/SQL Tutorial: BULK COLLECT and  BULK BIND in PLSQL
 
07:25
PL/SQL Tutorial: BULK COLLECT and BULK BIND 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: 1849 TechLake
DWH Tutorial 15 : Types Of Fact Tables in Data Warehousing
 
06:40
Types Of Fact Tables 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: 2228 TechLake