Description

Type

Training
Level

Intermediate
Location

Chennai (India)

Duration

Flexible
Start date

Different dates available

ETL Stands for Extract Transform and Load. ETL tools will integrate various kind of data format into the desired data. ETL tools will support different type of vendors with different software. In addition, ETL tools will do the transformation of data within systems involving complex business rules. Various ETL tools are available in market like Informatica, Microsoft SSIS, Clover, Oracle Warehouse Builder, etc.,

Facilities

Chennai (India)

See map

600042

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

All
Students
Centre

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

Data warehousing
Warehousing
Testing
Report
Strategy
Conversion
Explicit
ROUND
TRUNC
Arithmetic
Performing
Operations
DML

Course programme

ETL Testing - Concepts

Test plan & Testing strategy in data warehousing
Report testing and Data warehousing testing
Testing plan
Test cases possibilities in Data warehousing
HP ALM and HP QC – Defect raising and re-testing

Basic DATABASE Concept and SQL

Basic history of database concept: DBMS, RDBMS, ORDBMS
SQL Language overview : DQL, DML, DDL, DCL, TCL

Data Manipulation Language DML and Transaction Control Language TCL

DML : INSERT, UPDATE, DELETE, MERGE
TCL : COMMIT, ROLLBACK, SAVEPOINT

Data Definition Language - DDL

DDL : CREATE, ALTER, RENAME, DROP, TRUNCATE
DEFAULT OPTION.

Restricting and Sorting Data

WHERE Clause – Character Strings and Dates, number
General Comparison Conditions = > >= < <= <>
Other Comparison BETWEEN , IN , LIKE , NULL
Logical Conditions AND OR NOT
ORDER BY Clause, Sorting by Column Alias , Column Position, Multiple Columns

Constraints

NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK
Column Level Constraint, Table Level Constraint – Naming constraints and usage
Adding a Constraint, Dropping a Constraint,
Disabling Constraints, Enabling Constraints
Validating Constraints

Single-Row Functions

Character Functions: UPPER, LOWER, INITCAP, LENGTH, SUBSTR, INSTR, LPAD, RPAD, CONCAT, LTRIM, RTRIM, TRIM, REPLACE, TRANSLATE, REVERSE
Number Functions: ROUND, TRUNC, MOD, POWER, CEIL , FLOOR, ABS
Dates Functions: SYSDATE, MONTHS_BETWEEN, NEXT_DAY, LAST_DAY, ADD_MONTHS, ROUND, TRUNC, Arithmetic on Date
Conversion Functions: Implicit Data-Type Conversion & Explicit Data-Type Conversion, TO_CHAR ,TO_NUMBER ,TO_DATE
General Functions: NVL , NVL2 , NULLIF, COALESCE
CASE Expression, DECODE
Nested function with real-time usage

JOINS

EQUI JOIN / SIMPLE JOIN / NORMAL JOIN
ANSI JOIN, LEFT OUTER, RIGHT OUTER, FULL OUTER
INNER JOIN, JOIN … USING clause, JOIN … ON clause,
CROSS JOIN, NON-EQUI JOIN, SELF JOIN
ORACLE STANDARD OUTER JOINS.
Multi table Joins, Complex Joins – How to simplified complex joins.

Multi-row Functions

Group Functions Rules, SUM, MIN, MAX, COUNT, AVG
Creating Groups of Data: GROUP BY Clause
Filtering Group Results: The HAVING Clause

Sub-queries

Single-Row Subqueries- Rules, Operators : = > >= < <= <>
Null Values in a Subquery
Multi-Row Subqueries- Rules, Operators : IN, ANY , ALL

Views

Simple Views and Complex Views – Create, Drop
Rules for Performing DML Operations on a View
Inline Views
Materialized View – Create, Refresh, Drop – Usage

Other Database Objects

Sequence- NEXTVAL and CURRVAL

Index

Index – When to Create an Index, When Not to Create an Index.

Synonyms

Synonyms

SET Operators

UNION
UNION ALL
INTERSECT
MINUS

Advanced Date-time Functions

TIME ZONES
SYSDATE, SYSTIMESTAMP
CURRENT_DATE , CURRENT_TIMESTAMP
SESSIONTIMEZONE
TO_YMINTERVAL
TO_TIMESTAMP , numtodsinterval, cast, compose, decompose

Analytic Functions

WM_CONCAT, LAG, LEAD, RANK, DENSE_RANK
Query_by partition_clause with sum, min, max, avg, count
order_by_clause with sum, min, max, avg, count

Data warehouse Concepts

Business Intelligence
Data Warehousing Concepts (What/Why/How)
Data Modeling (Schemas, FACTS and DIMENSIONS)
Data Mart
Metadata
OLAP VS OLTP
Dimension
Fact
Types of Dimension tables
Types of Fact tables
Star Schema
Snowflake Schema
Slowly Changing Dimensions
Top down and Bottom up approach

E T L Informatica Power Center 9.X.X

Why do we need ETL tool and Why Informatica?

Introduction to Informatica

Introduction
Getting started
Informatica Suite Components
Informatica Architecture
Informatica Server

Informatica Power Center Client Components

Repository Manager
Designer
Workflow Manager
Workflow Monitor

Informatica Building Blocks

Source & Targets
Transformations
Mappings
Mapplets
Sessions
Workflows

Sources

Working with Relational Source
Working with Flat file Source
Working with heterogeneous sources

Targets

Working with Relational Targets
Working with Flat file Targets
Direct and Indirect file loading

Different Transformations

Active and Passive Transformations
Connected and un-connected transformations
Source Qualifier Transformation
Filter Transformation
Expression Transformation
Sorter Transformation
Aggregator Transformation
Router Transformation
Rank Transformation
Sequence Generator Transformation
Joiner Transformation
Lookup Transformation
Connected Lookup
Un Connected Lookup
Update Strategy Transformation
Union Transformation
Normalizer Transformation
Transaction Control Transformation

See related categories

Contact us

ETL Testing Training in Chennai

Questions & Answers

Reviews

Subjects

Course programme

Add similar courses
and compare them to help you choose.

ETL Testing Training in Chennai

Questions & Answers

Reviews

Subjects

Course programme

Add similar coursesand compare them to help you choose.

Add similar courses
and compare them to help you choose.