INFORMATICA ETL TOOL REALTIME ONLINE TRAINING,MOCK INTERVIEW,RESUME BUILD BY HANDS-ON PROFESSIONALS

INFORMATICA (ETL TOOL) ONLINE TRAINING and CORPORATE TRAINING BY REALTIME WORKING EXPERTS 8500122107:APEX

FOR FREE DEMO contact :

Email : raj@apex-online-it-training.com

Phone/WhatsApp : +91-(850) 012-2107  

  

ETL TOOL INFORMATICA Course Agenda 

(we can customize the course content as per your requirements)

DATAWAREHOUSING CONCEPTS:

Introduction to data warehousing

Characteristics of data warehouse

How to design a data warehouse

Top down and Bottom up approach

What is a data mart

ETL fundamentals

Data Acquisition, Data Merging, Data Cleansing, Data Scrubbing, Data Aggregation

Dimensional Modeling (Dimensions, Facts)

Star Schema

Snowflake Schema

Slowly Changing Dimensions

PowerCenter Components

PowerCenter Client Tools

PowerCenter Designer

Workflow Manager

Workflow Monitor

 Repository Manager

Excercise1:  Pass-through Mapping

Working with source analyzer

Working with target  designer

Working with mapping designer

Working with task developer

Working with workflow designer

Creating Data Source Names

Creating Relational Connections

Types of transformations (Active, Passive)

Excercise2: Expression Transformation Usage

Excercise3: Aggregator Transformation Usage

Excercise4: Filter Transformation Usage

Excercise5: Router Transformation Usage

Excercise6: Sorter Transformation Usage

Excercise7: Rank Transformation Usage

Excercise8: Joiner Transformation Usage

Excercise9: Union Transformation Usage

Excercise10: Lookup Transformation Usage (Connected, Unconnected)

Excercise11: Stored procedure Transformation Usage (Connected, Unconnected)

Excercise12: Sequence generator Transformation Usage

Excercise13: Update Strategy Transformation Usage

Excercise14: Source Qualifier Transformation Usage

Excercise15: Transactional control Transformation usage

Real time Mappings

SCD type-I

SCD type-II

Working with flat files

How to create flat file as target

How to read flat file data

File list (Working With Multiple Files)

Transformation Developer

 How to create a reusable transformation

 How to use reusable transformation in a mapping

 Advantages of reusable transformations

Mapplet Designer

How to create a mapplet (reusable business logic)

How to use a mapplet in a mapping

Advantages of mapplets

Tasks

How to work with command task

How to work with email task

How to work with session task

How to work with decision task

How to work with link task

How to work with timer task

How to work with control task

How to work with event-wait task

How to create reusable tasks

How to create non-reusable tasks

Workflows

How to create parallel workflows

How to create sequential workflows

How to schedule workflows

Worklets

How to create a worklet

How to use a worklet in a workflow

Nesting of worklets

Types of caches

Data Cache

Index Cache

Static Cache

Persistent Cache

Dynamic Cache

Working with functions

Performance Tuning

How to tune source

How to tune target

How to tune transformations

How to tune session

How to tune workflow

Informatica Realtime Scenarios

FOR More Details contact :

Email : raj@apex-online-it-training.com

Phone/WhatsApp : +91-(850) 012-2107 

INFORMATICA DATA QUALITY IDQ REALTIME ONLINE TRAINING,MOCK INTERVIEW BY CORPORATE TRAINERS

INFORMATICA DATA QUALITY (IDQ) ONLINE TRAINING BY REALTIME WORKING PROFESSIONALS 8500122107:APEX

FOR FREE DEMO contact us at:

Email : raj@apex-online-it-training.com

Phone/WhatsApp : +91-(850) 012-2107  

  

IDQ Course Agenda 

(we can customize the course content as per your requirements)

Informatica Analyst 9.1

·         Analyst GUI

·         Metadata and Data access/import

·         Column Profiling

·         Frequency/Patterns/Statistics/Drill downs

·         Rule Profiling

·         Out Of The Box rules

·         Custom rules

·         Reference Tables Management

·         Project Collaboration

·         Data Quality Score carding

Informatica Developer 9.1

·         Developer GUI

·         Developer Profiling including:

·         Mid-stream profiling

·         Join analysis profiling

·         Building Data Quality Mapplets and Rules

·         Data Standardization

·         Cleanse, transform and parse data using DQ transformations such as the Case Converter, Merge, Labeller, Standardizer, Parser

·         Address Validation

·         Perform address validation and create AV mapplets and mappings

·         Matching

·         Group data prior to matching to improve matching performance

·         Perform DQ and Identity Matching to identify duplicate records

·         Develop Matching Mapplets

·         Associate and Consolidate matched data

·         Work with the Data Quality Assistant

·         PowerCenter Integration

·         Parameterization

·         Data Quality Workshop

FOR More Details contact us at:

Email : raj@apex-online-it-training.com

Phone/WhatsApp : +91-(850) 012-2107 

HADOOP BIGDATA REAL TIME ONLINE TRAINING,MOCK INTERVIEWS BY IT PROFESSIONALS 8500122107

FOR FREE DEMO contact us at:

Email : raj@apex-online-it-training.com

Phone/WhatsApp : +91-(850) 012-2107  

HADOOP ONLINE TRAINING BY REALTIME CORPORATE PROFESSIONALS

Hadoop Course Content (we can customize the course content as per your requirement)

HADOOP Using Cloudera

Development & Admin Course

Introduction to BigData, Hadoop:-

·         Big Data Introduction

·         Hadoop Introduction

·         What is Hadoop? Why Hadoop?

·         Hadoop History?

·         Different types of Components in Hadoop?

·         HDFS, MapReduce, PIG, Hive, SQOOP, HBASE, OOZIE, Flume, Zookeeper and so on…

·         What is the scope of Hadoop?

Deep Drive in HDFS (for Storing the Data):-

·         Introduction of HDFS

·         HDFS Design

·         HDFS role in Hadoop

·         Features of HDFS

·         Daemons of Hadoop and its functionality

·         Name Node

·         Secondary Name Node

·         Job Tracker

·         Data Node

·         Task Tracker

·         Anatomy of File Wright

·         Anatomy of File Read

·         Network Topology

·         Nodes

·         Racks

·         Data Center

·         Parallel Copying using DistCp

·         Basic Configuration for HDFS

·         Data Organization

·         Blocks and

·         Replication

·         Rack Awareness

·         Heartbeat Signal

·         How to Store the Data into HDFS

·         How to Read the Data from HDFS

·         Accessing HDFS (Introduction of Basic UNIX commands)

·         CLI commands

MapReduce using Java (Processing the Data):-

·         Introduction of MapReduce.

·         MapReduce Architecture

·         Data flow in MapReduce

·         Splits

·         Mapper

·         Portioning

·         Sort and shuffle

·         Combiner

·         Reducer

·         Understand Difference Between Block and InputSplit

·         Role of RecordReader

·         Basic Configuration of MapReduce

·         MapReduce life cycle

·         Driver Code

·         Mapper

·         and Reducer

·         How MapReduce Works

·         Writing and Executing the Basic MapReduce Program using Java

·         Submission & Initialization of MapReduce Job.

·         File Input/output Formats in MapReduce Jobs

·         Text Input Format

·         Key Value Input Format

·         Sequence File Input Format

·         NLine Input Format

·         Joins

·         Map-side Joins

·         Reducer-side Joins

·         Word Count Example

·         Partition MapReduce Program

·         Side Data Distribution

·         Distributed Cache (with Program)

·         Counters (with Program)

·         Types of Counters

·         Task Counters

·         Job Counters

·         User Defined Counters

·         Propagation of Counters

·         Job Scheduling

PIG:-

·         Introduction to Apache PIG

·         Introduction to PIG Data Flow Engine

·         MapReduce vs PIG in detail

·         When should PIG used?

·         Data Types in PIG

·         Basic PIG programming

·         Modes of Execution in PIG

·         Local Mode and

·         MapReduce Mode

·         Execution Mechanisms

·         Grunt Shell

·         Script

·         Embedded

·         Operators/Transformations in PIG

·         PIG UDF’s with Program

·         Word Count Example in PIG

·         The difference between the MapReduce and PIG

SQOOP:-

·         Introduction to SQOOP

·         Use of SQOOP

·         Connect to mySql database

·         SQOOP commands

·         Import

·         Export

·         Eval

·         Codegen and etc…

·         Joins in SQOOP

·         Export to MySQL

HIVE:-

·         Introduction to HIVE

·         HIVE Meta Store

·         HIVE Architecture

·         Tables in HIVE

·         Managed Tables

·         External Tables

·         Hive Data Types

·         Primitive Types

·         Complex Types

·         Partition

·         Joins in HIVE

·         HIVE UDF’s and UADF’s with Programs

·         Word Count Example

HBASE:-

·         Introduction to HBASE

·         Basic Configurations of HBASE

·         Fundamentals of HBase

·         What is NoSQL?

·         HBase DataModel

·         Table and Row

·         Column Family and Column Qualifier

·         Cell and its Versioning

·         Categories of NoSQL Data Bases

·         Key-Value Database

·         Document Database

·         Column Family Database

·         SQL vs NOSQL

·         How HBASE is differ from RDBMS

·         HDFS vs HBase

·         Client side buffering or bulk uploads

·         HBase Designing Tables

·         HBase Operations

·         Get

·         Scan

·         Put

·         Delete

MongoDB:--

·         What is MongoDB?

·         Where to Use?

·         Configuration On Windows

·         Inserting the data into MongoDB?

·         Reading the MongoDB data.

Cluster Setup:--

·         Downloading and installing the Ubuntu12.x

·         Installing Java

·         Installing Hadoop

·         Creating Cluster

·         Increasing Decreasing the Cluster size

·         Monitoring the Cluster Health

·         Starting and Stopping the Nodes

OOZIE

·         Introduction to OOZIE

·         Use of OOZIE

·         Where to use?

Hadoop Ecosystem Overview

Oozie

HBase

Pig

Sqoop

Casandra

Chukwa

Mahout

Zoo Keeper

Flume

·         Case Studies Discussions

·         Certification Guidance

·         Real Time Certification and

·         interview Questions and Answers

·         Resume Preparation

·         Providing all Materials nd Links

·         Real time Project Explanation and Practice

FOR More Details contact us at:

Email : raj@apex-online-it-training.com

Phone/WhatsApp : +91-(850) 012-2107