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: 14907 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: 18049 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: 3230 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: 3968 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: 17946 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: 3990 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: 19998 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: 1973 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: 4607 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: 4333 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: 1767 TechLake
SQL Performance Tuning 2 and tips
 
10:56
SQL Performance Tuning 2 and tips Oracle Performance Tuning Oracle SQL Performance Tuning Tips
Views: 7388 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: 5583 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: 1090 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: 1571 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: 1601 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: 2877 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: 1306 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: 3301 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: 1188 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: 2264 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: 1691 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: 7274 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: 1750 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: 1159 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: 1245 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: 2668 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: 1446 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: 1327 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: 1101 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: 4668 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: 3353 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: 2962 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: 23415 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: 1938 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: 1759 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: 1113 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: 1187 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: 828 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: 6783 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: 812 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: 1187 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: 998 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: 1698 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: 847 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: 1243 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: 975 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: 755 TechLake
ODI 12c Tutorial Lessions6 Models Creation with Contraints
 
18:34
ODI1 2c Tutorial Lessions6 Models Creation with Contraints ODI 12c Tutorial ODI 12c Tutorial for beginners ODI Tutorial ODI Tutorial for Beginners
Views: 2646 TechLake
Linux Tutorial For Beginners - gzip, gunzip, tar commands
 
09:38
Linux Tutorial For Beginners Commands - Compression and Uncompression using gzip, gunzip, tar commands unix shell script linux shell script linux commands unix commands linux tutorial unix tutorial
Views: 1169 TechLake