Free Online Training for Informatica !!

[ittraining]

Free Informatica Online Training & Placement for Fresh MS Graduates !!

Duration: 4 weeks
Start Date: 21st March

  This is a good opportunity for MS Students who are graduating in May 2011.

Interested Candidates can call me at 201 680 8323(cell)

We also provide Free Food and Accomodation at Jersey City,NJ for students who are willing to come to our guest house.

Thanks,
Mahesh
Value Solutions Inc
812 Columbia Avenue
Jersey City,NJ 07047
201-680-8323(Cell)
[email protected]
[url=http://www.valuesols.com]www.valuesols.com[/url]


Course Contents:

DATA WAREHOUSING
INTRODUCTION TO DATA WAREHOUSING
DATABASE DESIGN AND DATA MODELING

• What is Data warehouse
• Components of Data warehouse
• Decision support systems
•
• OLTP Systems
• OLTP vs DATA WAREHOUSE
• ODS(operational data store)
• Difference between ODS and DATA WAREHOUSE
• Data Mart
• Difference between Data warehouse and Data Mart
• Difference between Data warehouse and ODS,OLTP
• Data warehousing for OLTP systems
• Data cleansing
• Independent Data warehouse
• Dependent Data warehouse
• Meta data and Data Mining
• OLAP,ROLAP,MOLA • ER Model for transactional processing
• Introduction to Data Modeling
• Entities and Attributes
• What is the use of data modeling in Data warehousing
• Schema
• Star Schema
• Snowflake Schema
• Snowflake Schema(hybrid schema or galaxy schema)
• Fact table
• Dimension tables
• Multi dimension tables
• Grain warehousing tools consideration
• Granularity for the data warehousing

INFORMATICA 8.1 or 8.6
• Introduction of Informatica (power mart and power centre)
• Difference between power mart and power centre
• ETL Architecture
• Data source
• Data targets
• Repository
• Meta data
• Server components
• Client components
INFORMATICA REPOSITORY SERVER
• Administrator password
• Port number
INFORMATICA SERVER ADMINISTRATOR CONSOLE(RSAC)
• Creating Informatica Repository Server(IRS)
• Connecting the server
• Creating repository
• Repository considerations
INFORMATICA REPOSITORY MANAGER
• Creating the workspace(folder)
• Creating the users
• Changing the user passwords
• Creating users groups
• Giving privileges to the users, user groups and folder
INFORMATICA DESIGNER
• Connecting to the designer
• Components of the designer
• Creating DSN(data source name)
• Source, Database
• Accessing the source, definitions to the designer
• Warehouse Designer
• Creating the target tables using warehouse designer
• Generating target table to database
• Mapping designer
• Mapping between the source and target tables
• Transformations between source and target tables
TYPES OF TRANSFORMATIONS
• Source qualifier
• Aggregator
• Filter
• Expression
• Stored procedure
• Lookup
• Sorter
• Joiner
• Router
• Xml source qualifier
• Update strategy
• Normalizer
• Ranking
• Sequencer generator
• Transaction control
• Union
• Custom
Slowly changing dimensions (scd) Mapplets
Cubes and dimensions (creating star schema)
Reusable transformations Debugger
Working with mapping using debugger
Data Profiling
Variable and Parameters
New features in power centre 8.1
WORKFLOW MANAGER
Components of workflow manager
Types of tasks
• Session
• E-mail
• Command
Creating workflow
Scheduling the workflow
Creating connections
Assigning connection values to the sessions
Creating server (informatica server)
Assigning server to workflow
Workflow monitor
Session logs
Workflow logs

Database : Oracle or SQL Server