We use cookies to maintain login sessions, analytics and to improve your experience on our website. By continuing to use our site, you accept our use of cookies, Terms of Use

INFORMATICA

INFORMATICA
Free

INFORMATICA

Overview

 

What You'll Learn

  • SQL, PL/SQL BASICS
  • DATA WAREHOUSE

Course Content

  • 1. SQL 
  • 2. PL /SQL Basics
  • 3. Toad and SQL Developer Tools
  • 4. Data Warehouse
  • 5. Informatica Power Center 9.6
  • 6. Unit Testing
  • 7. Deployment activities
  • 8. Unix Basics and Shell scripting
  • 9. Real-time Projects

SQL INTRODUCTION 

  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Retrieval Language (DRL)
  • Transaction Control Language (TCL)
  • Data Control Language (DCL)

DATA TYPES

Conditional Selections and Operations
  • Where
  • Order by

OPERATORS

  • Arithmetic operators
  • Comparison operators
  • Logical operators

FUNCTIONS

SINGLE ROW FUNCTIONS
a. Numeric functions
b. String functions
c. Date functions
d. Miscellaneous functions
e. Conversion functions
GROUP FUNCTIONS
a. Sum
b. Avg
c. Max
d. Min
e. Count

CONTROLS

  • Buttons
  • Text Fields
  • abels
  • Sliders
  • Progress
  • Switch
  • Web View
  • Image View
  • Segmented Control
  • Date picker
  • Picker
  • Alerts & Action Sheets
  • Page Controller

BASIC NS CLASSES

  • NSString, NSObject
  • NSArray, NSMutable Array
  • NSDictionary, NSMutable Dictionary
  • Other etc important classes

TABLES USING UITABLEVIEW AND UITABLEVIEWCONTROLLER

  • UITableView
  • UITableViewDelegate and UITableViewDataSource
  • UITableViewDelegate
  • UITableViewDataSource
  • Adopting the UITableViewDelegate and
  • UITableViewDataSource
  • UITableViewController.

PL/SQL INTRODUCTION TO PL/SQL

  • Variables
  • Constants
  • Records
  • Conditional Statements
  • Procedures
  • Functions
  • Parameters-Procedure, Function
  • Exception Handling

DATA WAREHOUSE INTRODUCTION

  • Business Intelligence
  • Data Warehouse
  • What is a DataMart
  • What is the difference between a data warehouse and a Data Mart
  • OLTP
  • ODS (Operational Data Sources)
  • What is Staging area and why we need it in DWH

SCHEMAS

  • Star schema
  • Snowflake schema

Dimension and Fact

TYPES OF DIMENSIONS
  • Slowly Changing Dimension( SCD)
   a. SCD-Type1– Current Data
   b. SCD-Type2 – Historical Data
   c. SCD-Type3 – Partial History
  • Confirm Dimension
  • Junk Dimension
  • De Generated Dimension
TYPES OF FACTS
  • Additive
  • Semi-Additive
  • Non-Additive
  • Factless Fact Table
Granularity
Data cleansing
Surrogate key
Difference between a primary key and a surrogate key
Top Down approach
Bottom Top approach

ETL – INFOMATICA POWER CENTER 9.6 INFOMATICA OVERVIEW

  • Power Center
  • Power Mart
  • Designer
  • Workflow Manager 
  • Repository Manager
  • Integration Services
  • Repository Services
  • Integration Service Process (ISP) 
  • Data Transformation Manager (DTM) Process
  • Session
  • Workflow
  • Source Definition
  • Target Definition

INFOMATICA INSTALLATION & INFOMATICA TRANSFORMATIONS

  • Source Qualifier 
  • Filter
  • Expression
  • Router
  • Session Level UPDATE else INSERT
  • Mapping Level UPDATE else INSERT
  • Update Strategy Transformation
  • Mapping level
  • Session level
  • Joiner Transformation

DIFFERENCES BETWEEN DYNAMIC LOOKUP AND STATIC LOOKUP

Difference between mapping level and session level variables

  • Session level variables
  • Mapping level variables
  • Sequence Generator
  • Normalizer Transformation

INCREMENTAL LOGIC OR DELTA OR CDC

  • Using parameter file
  • Using oracle Control tables
      Transaction Control Transformation
      Lookup
a. Connected  
b. Unconnected 

LOOKUP CACHES

  • Persistent cache 
  • Re-cache from lookup source 
  • Static cache
  • Dynamic cache 
  • Shared cache 
  • Aggregator

ANALYTICAL FUNCTIONS

  • First row Function
  • Last row Function
  • Flat Files
  • Delimiter
  • Fixed Width
  • List Files

SCD TYPE-I UPDATE ELSE INSERT & SCD TYPE-II 

  • Effective-Date Approach
  • Flag Approach
  • Version Approach

SCD TYPE-III

  • Constraint Base Load in Session Level
  • Parameter Files
  • Rank Transformation
  • Stored ProcedureTransformation
  • Sorter Transformation
  • Input Transformation
  • Output Transformation
  • Union Transformation
  • SQL Transformation
  • Java Transformation Overview
  • XML Generator
  • XML Parser
  • Mapplet Input Transformation
  • Mapplet output Transformation
  • Some other IMP transformations
  • Performance tuning in Infomatica
  • Infomatica Session Log shows busy percentage
  • Target Update Override
  • Overriding the WHERE Clause 
  • Difference between 7.x and 8.x and 9.X
  • Power Center 9.X Architecture.

Miscellaneous

Shortcuts
  • Recovery
  • Session Log
  • Debugger
  • Worklets
  • Active & Passive
  • Standard & Reusable
  • Scheduling
  • Email Task
  • Decision Task
  • Concurrent Workflows
  • Complex Mapping
  • Error Handling
  • Mapplets
  • Code Pages
  • Meta Data
  • Versioning
Third Party Tools
  • Putty
  • Edit Plus
  • FTP (File Transfer Protocol) – File Zilla

UNIX INTRODUCTION TO THE UNIX OPERATING SYSTEM

  • What is UNIX?
  • Files and processes
  • The Directory Structure
  • Starting an UNIX terminal
  • Listing files and directories
  • Making Directories
  • Changing to a different Directory
  • Copying Files
  • Moving Files
  • Removing Files and directories
  • Displaying the contents of a file on the screen
  • Searching the contents of a file
  • Pipes
  • Other Useful UNIX commands
BASICS OF THE VI EDITOR
  • Shell script to upload files in Infomatica server
  • Shell script to transfer files from Infomatica server to remote server
  • Shell script to load Data
  • Shell script to create indicator file
  • Shell script to create indicator file
  • Some other useful scripts.

UNIT TESTING

  • Real time standard unit test cases will be explained.

DEPLOYEMENT

  • Introduction about Deployment
  • Deployment activities on different DB environments.

REALTIME DATABASE ENVIRONMENTS

INTRODUCTION ABOUT DATABASE ENVIRONMENTS
  • TEST 
  • DEV
  • QA
  • UAT
  • PROD
PROJECTS DEVELOPMENT
  • Migration Projects
  • New Development or Start up project
SUPPORT
  • Production Support /Enhancement Project
  • 24/ 7 Project

                                       

About us

Bluebell Research Australia Pty. Ltd. is an Australian Startup engaged in training and placing candidates across Australia.

Contact Us

Email: training@bluebellresearch.com.au

Ph: +61 457298829/416769207

Address: 79 George Street, Parramatta, NSW, Australia

Policy and Terms