Home | Contact Us | Sitemap
DWHlabs provides Data Warehouse education services.This web portal is very useful to the Database professionals,
Data Warehouse professionals, UNIX professionals etc.,
  About Us Advertise Support us Tell your Fren Testimonial Contact Us  
 
 
Please help us continue development of this website and it's services!
 
 

 


 
DWHlabs- ETL TOOL - INFORMATICA
Sponsered Links
 
 


INSTALALTION
 
 
  Next
 
Install

  • Keep the INFORMATICA CD into the CD Rom
  • Click on CD-Drive
  • Click on the icon setup
  • Now it is showing prompt box with option
  • Now click on " Power Center for windows" button.
  • while in the process it asks you to configure Repository Server and Informatica Server .That you can do it now or later on.We will tell how to cofigure it in the next few lines.
  • Successfully installed.

Configure Repository Server


  • Go to Program files
  • Informatica power center 7.1.1 > Repository Server > Repository Setup.
  • You see the prompt screen of Repository server with differnt options.
  • Set the "Server Port Number" any value between 5002 to 65535.
  • Set the "administrative password" of your own choice.It is case sensitive.
  • Now we successfully configured Repository Server.

Add Data Source

  • Click on Control panel
  • Click on Administrator tool >Data source (ODBC)
  • Now click on add button.It shows set of drivers of differnt data sources.Select the right data source.For eg., If your database is Oracle then select respected oracle driver.
  • Cick on OK
  • It ask for description of the Data Source.You can name it as you want for eg., ora_data_src.
  • Click on OK
  • Here you added the data source successfully.

Start Services

  • Clcik on Control Panel
  • Now click on Administrator Tool> Services
  • You see the prompt display on the screen.
  • Right click on "Informatica Repository Server" and click on start.
  • Right click on "Informatica" and click on start.
  • successfully started the services.

Create two users


  • Login to your database .
  • Create two users one for Repository and other for Target Database.
  • This are necessary to secure the data in the repositories.
  • For eg., Repository (Username :: Rep_one , Password :: r) and Target (username::trg_wh , Password :: t).
  • After creating the users.Test it by connecting to the database.

 

 
  Next
 
DWH 3Colors
CERTIFICATION GUIDE
DATA DICTIONARY
ALL ARTICLES
   
DWH CONCEPTS

DWH Architecture
Types of Schema
Normalization

VS LINKS

OLAP Vs OLTP
Dimension Table Vs Fact Table
Datamart Vs Data Warehouse
Data Mining Vs Web Mining


SHARE KNOWLEDGE

Now viewers can share their information with DWHlabs , please
Click Here.
Please send your feedback
Click Here .
Tell you friend about DWHlabs
Click Here .


Data Warehouse Lab

- ETL TOOL
INFORMATICA
OTHER TOOLS

- REPORTING TOOL

BUSINESS OBJECTS
OTHER TOOLS

Database Lab

- ORACLE
SQL
PL/SQL

- DB2
OTHER TOOLS

Unix Lab

Project Lab

DWH Schools

Books Store



 
  About Us Advertise Support us Tell your Fren Testimonial Contact Us  
© 2008 DWHlabs
Privacy Policy | Terms & Conditions