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: 13272 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: 1588 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: 16913 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: 5151 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: 1796 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: 8193 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: 2504 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: 1059 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: 17760 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: 2195 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: 740 TechLake
SQL Performance Tuning 2 and tips
 
10:56
SQL Performance Tuning 2 and tips Oracle Performance Tuning Oracle SQL Performance Tuning Tips
Views: 3314 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: 1908 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: 1675 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: 1926 TechLake
Oracle Data Integrator 12c Installations and Configuration in Windows 8
 
26:53
Oracle Data Integrator 12c Installations and Configuration in Windows 8, ODI 12c Master repository And Work Repository creation ODI Tutorial for Beginners. Oracle Data Integrator Tutorial ODI 11g Tutorial ODI 12c Tutorial
Views: 12857 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: 452 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: 539 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: 7384 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: 1000 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: 567 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: 1664 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: 6158 TechLake
SQL Tutorial : How To Delete Duplicate Records in SQL Oracle
 
07:43
SQL Tutorial : How To Delete Duplicate Records in SQL 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: 2257 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: 21993 TechLake
Oracle Data integrator Interview Questions & Answers
 
41:25
Oracle Data integrator Interview Questions & Answers Difference between ODI 11g and 12C ODI 12c New Features.
Views: 3607 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: 885 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: 606 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: 1120 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: 515 TechLake
DWH Tutorial 14 : What is Fact less Fact table in Dimensional Modeling
 
03:20
What is Fact less Fact table in Dimensional Modeling 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: 2506 TechLake
Oracle Data Integrator Package with examples
 
22:53
Oracle Data Integrator, Package, Serial and parllel execution in package with examples ODI Tutorial for Beginners. Oracle Data Integrator Tutorial ODI 11g Tutorial ODI 12c Tutorial
Views: 14224 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: 835 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: 509 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: 792 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: 385 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: 643 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: 507 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: 870 TechLake
ODI SCD Type 2 Implementation step by step process (Slowly Changing Dimension)
 
14:01
ODI SCD Type 2 Implementation step by step process, Oracle Data Integrator Interface example for implementing Slowly changing dimension Type 2. ODI 11g Tutorial ODI 11g Tutorial for beginners ODI Tutorial ODI Tutorial for beginners
Views: 12544 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: 440 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: 400 TechLake
SQL Tutorial : Difference Between Count(1) and Count(*)  in SQL Oracle
 
06:43
SQL Tutorial : Difference Between Count(1) and Count(*) in SQL 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: 1987 TechLake
Topology Dataserver, Physical and Logical Schema creation in ODI
 
30:46
Creating ODI Topology objects like Data Servers Creation, Physical Schema Creation, Context Creation and logical schema creation and assigning contexts and physical schema. ODI Tutorial for Beginners. Oracle Data Integrator Tutorial ODI 11g Tutorial ODI 12c Tutorial
Views: 14716 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: 1181 TechLake
SQL Tutorial For Beginners SQL INDEXES  BITMAP and B-Tree
 
28:08
Oracle SQL Index types with examples. Simple Index, Composite Index, Unique Index, Non Unique Index, Bitmap Index, B-tree Index. SQL Tutorial SQL Tutorial for beginners Oracle SQL Tutorial for beginners
Views: 20268 TechLake
SQL Tutorial : Difference Between Translate &  Replace in SQL Oracle
 
06:36
SQL Tutorial : Difference Between Translate & Replace in SQL 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: 424 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: 730 TechLake
SQL Tutorial : Difference Between NVL and NVL2 functions in sql
 
08:06
SQL Tutorial : Difference Between NVL and NVL2 functions in 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: 492 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: 474 TechLake