Current Level 18: INFORMATICA POWERCENTER
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

🎬 YouTube Videos

No YouTube videos available

Check back later for new YouTube content.

📹 Library Videos

Basic Informatica
L85 Tuesday
L85_sat
L85_project_recording

📚 Content

SECTION 1 INFORMATICA INTRODUCTION Subscribe to view this section
Subscribe to the course to read this lesson
Subscribe
SECTION 1 INFORMATICA COMPONENTS Subscribe to view this section
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 view this section
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 view this section
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 view this section
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 view this section
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 view this section
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 view and post comments
Subscribe

Subscribe to the course to read comments for this mile.