Best training in vizag - Informatica - Grafx IT Solution

 Grafx IT Solution

Informatica


Informatica is powerful ETL tool from Information Corporation, a leading provider of enterprise data integration software and ETL softwares. In informatica, all the Metadata information about source systems,target systems and transformations are stored in the Informatica repository. Informatica’s Power Center Client and Repository Server access this repository to store and retrieve metadata..

Data Warehouse and ETL Concepts


Characteristics of the Data ware House

OLTP Vs OLAP

Dimensions Tables Vs Fact Table


Data Marts


Data Extraction

Data Transformation

Data Loading


Data Staging Area

Database Designs(Star Schema, Snowflake Schema etc)

Database Concepts


DDL,DML,DCL AND TCL

Set Operators

Sub Queries

Group By and Having Clause

Joins

Power Centre Components

Informatica Architecture

Designer

Repository Manager

Workflow Manager & Workflow Monitor

Informatica Concepts and Overview

Source Qualifie

Target Designer

Transformations

Mappings &Mapplets

Sessions

Workflows & Work lets

Sources

Working with Relational Sources

Working with Flat Files (Direct/Indirect)

Targets

Working with Relational Targets

Working with Flat file Targets

Transformations

Active and Passive Transformations

Connected and Unconnected Transformations


Type-1

Type-2

Type-3

Comments

Post a Comment

Popular posts from this blog

Best training in vizag - Sales Force - Grafx IT Solution

Image
  Grafx IT Solution Sales Force Sales Force  Stylized as  salesƒorce  is a American cloud computing company headquartered in San Francisco, California. Though its revenue comes from a customer relationship management ( CRM ) product, Salesforce also tries capitalizing on commercial applications of social networking through acquisition. Introduction to Salesforce Sales Cloud Quote Templates Field Types Salesforce  Object Creating Buttons, Links, and Actions Validation Rules Lightning Components Role Hierarchy Security Controls & Profiles Reports Dashboards Apex Class Visual Force
Read more

Best training in vizag - R-Programming - Grafx IT Solution

Image
Grafx IT Solutions R-Programming R-Programming : R program  is a programming language and programming condition for measurable examination, designs portrayal and announcing. R permits combination with the techniques written in the C, C++, .N et, Python or  FORTRAN  dialects for effectiveness. R  – OVERVIEW R – ENVIRONMENT SETUP R –  BASIC SYNTAX R – DATA TYPES R –  VARIABLES R –  OPERATORS R –  DECISION MAKING R –  LOOPS R – FUNCTION R – STRINGS R –  VECTORS R – LISTS R – MATRICES R – ARRAYS R – FACTORS R – DATA FRAMES R – PACKAGES R – DATA RESHAPING R – CSV FILES R – EXCEL FILE R – BINARY FILES R – XML FILES R – JSON FILE R – WEB DATA R – DATABASES R – PIE CHARTS R – BAR CHARTS R – BOXPLOTS R – HISTOGRAMS R – LINE GRAPHS R – SCATTERPLOTS R – MEAN, MEDIAN & MODE R – LINEAR REGRESSION R – MULTIPLE REGRESSION R – LOGISTIC REGRESSION R – NORMAL DISTRIBUTION R – BINOMIAL DISTRIBUTION R – POISSON REGRESSION R – TIME SERIES ANALYSIS R – NO...
Read more