Subscribe to the course to read this lesson
Subscribe
0 / 31
Miles
0 / 19
Assignments
0 / 17
Exams
📖 Course Miles: Passed Failed Pending Not Attempted Scroll to see all miles (31)
Mile 1: Journey 1- Introduction
Assign:
Exam:
Mile 2: Journey 2 - Filter Transformation
Assign:
Exam:
Mile 3: Journey 3 - Expression Transformation
Assign:
Exam:
Mile 4: Journey 4 - Joiner Transformation
Assign:
Exam:
Mile 5: Journey 5 - Aggregator Transformation
Assign:
Exam:
Mile 6: Journey 6 - Sorter Transformation
Assign:
Exam:
Mile 7: Journey 7 - Sequence Generater
Assign:
Exam:
Mile 8: Journey 8 - Rank Transformation
Assign:
Exam:
Mile 9: Journey 9 - Router Transformation
Assign:
Exam:
Mile 10: Journey 10 - Union Transformation
Assign:
Exam:
Mile 11: Journey 11 - Source Qualifier
Assign:
Exam:
Mile 12: Journey 12 - Normalizer
Assign:
Exam:
Mile 13: Journey 13 - Lookup Transformation
Assign:
Exam:
Mile 14: Journey 14 - Update Strategy Transformation
Assign:
Exam:
Mile 15: Journey 15 - Stored Procedure Transformation
Assign:
Exam:
Mile 16: Journey 16 - Flat Files
Assign:
Exam:
Mile 17: Journey 17 - SCD
Assign:
Exam:
Mile 18: Journey 18 - Parameters and Variables
Assign:
Exam:
Mile 19: Journey 19 - XML
Assign:
Exam:
Mile 20: Journey 20 - SQL Transformation
Assign:
Exam:
Mile 21: Journey 21 - Debugger
Assign:
Exam:
Mile 22: Journey 22 - Mapplet
Assign:
Exam:
Mile 23: Journey 23 - UDF (User define function)
Assign:
Exam:
Mile 24: Journey 24 - Task Commands
Assign:
Exam:
Mile 25: Journey 25 - Reusable Transformation
Assign:
Exam:
Mile 26: Journey 26 - Transaction control
Assign:
Exam:
Mile 27: Journey 27 - Version control
Assign:
Exam:
Mile 28: Journey 28 - Shortcut folder / shared folder
Assign:
Exam:
Mile 29: Journey 29 - Session Properties
Assign:
Exam:
Mile 31: Journey 31 - PMCMD Command
Assign:
Exam:
🎬 YouTube Videos
No YouTube videos available
Check back later for new YouTube content.
📹 Library Videos
📚 Content
SECTION 1 INFORMATICA INTRODUCTION
SECTION 1 INFORMATICA COMPONENTS
Subscribe to the course to read this lesson
Subscribe
SECTION 1 T_FILTER (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5)); T_EXPRESSION1 (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5), JOB_ID VARCHAR2(20), MGRID NUMBER(5) COMM NUMBER(8,2)); T_EXPRESSION2 (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5), JOB_ID VARCHAR2(20), MGRID NUMBER(5) COMM NUMBER(8,2) SALTYPE VARCHAR2(20)); T_SORTER (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5), JOB_ID VARCHAR2(20), MGRID NUMBER(5));T_EMP_RANK (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5));
Subscribe to the course to read this lesson
Subscribe
SECTION 1 T_FLAT_FILE (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5), EMAIL VARCHAR(30), MGRID NUMBER(5));T_JOINER (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5), EMAIL VARCHAR(30), MGRID NUMBER(5) DEPT_NAME VARCHAR2(30), ); T_JOINER_EDL (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5), EMAIL VARCHAR(30), MGRID NUMBER(5) DEPT_NAME VARCHAR2(30), LOC_ID NUMBER(5) CITY VARCHAR2(20) COUNTRY VARCHAR2(20)); T_AGGREGATOR1 ( DID NUMBER(5), SSAL NUMBER(10,2), MNSAL NUMBER(10,2), MXSAL NUMBER(10,2), AVSAL NUMBER(10,2), CNT NUMBER(5)); T_AGGREGATOR2 ( DID NUMBER(5), SSAL NUMBER(10,2), MNSAL NUMBER(10,2), MXSAL NUMBER(10,2), AVSAL NUMBER(10,2), CNT NUMBER(5) DNAME VARCHAR2(30), CITY VARCHAR2(30) ENAME VARCHAR2(50) SAL NUMBER(10,2));
Subscribe to the course to read this lesson
Subscribe
SECTION 1 T_NORMALIZER (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5), GCID NUMBER(5), GKID NUMBER(5)); T_SEQUENCE_GENERATOR (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5), SEQ NUMBER(5));T_ROUTER1 (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5), SEQ NUMBER(5)); T_ROUTER2 (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5), SEQ NUMBER(5)); T_ROUTER_DEFAULT (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5), SEQ NUMBER(5));
Subscribe to the course to read this lesson
Subscribe
SECTION 1 T_UNION (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5)); T_SOURCE_QUALIFIER_EXP (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5), JOB_ID VARCHAR2(20), MGRID NUMBER(5) COMM NUMBER(8,2)); T_SOURCE_QUALIFIER_JOIN (EMPID NUMBER(5), ENAME VARCHAR2(30), SAL NUMBR(10,2), DID NUMBER(5), EMAIL VARCHAR(30), MGRID NUMBER(5) DEPT_NAME VARCHAR2(30), LOC_ID NUMBER(5) CITY VARCHAR2(20) COUNTRY VARCHAR2(20));
Subscribe to the course to read this lesson
Subscribe
SECTION 1 T_SOURCE_QUALIFIER_AGG ( DID NUMBER(5), SSAL NUMBER(10,2), MNSAL NUMBER(10,2), MXSAL NUMBER(10,2), AVSAL NUMBER(10,2), CNT NUMBER(5));
Subscribe to the course to read this lesson
Subscribe
Previous
Next Mile
📝 Assignment
Available Assignments
| Assignment | Pass Mark | Duration | Actions |
|---|---|---|---|
|
Informatica Introduction
|
70% | 03:00:00 |
📊 Exam
Available Exams
| Exam | Pass Mark | Duration | Questions | Actions |
|---|---|---|---|---|
|
Informatica Introduction
|
70% | 00:30:00 | All |
💬 Comments & Discussion
Subscribe to the course to read comments for this mile.