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
 
 
Previous    
 

Create Repository (Version 7.1.1)

  • ALl programs > Informatica Power Center 7.1.1
  • Informatica Power Center -client > Repository Admin Console
  • Under console root , Right click on Informatica Repository Sever and click on new server registration.
  • Prompt comes with a port number.
  • Host name :: your computer name , Port number :: Server Port number(Repository)
  • Now your system connected with the Repository server.
  • Click on the Server (represented with your host name) and clcik on connect.
  • It asks you to enter the password .Make sure the port number and password must be same as the Repository server.
  • Now Right click on the repository folder and click on New Repository .
  • Enter the Repository name and select Global Repository (optional) .
  • Now click on LICENSE tab -- enter the keys in the following order Product License Key, Opton Key and Connectivity License Key.
  • Click on OK
  • It takes some time to create repository.
  • Now your repository keeps running.
 
Create Temporary Server ( Workflow Manager)

  • Clck on workflow manager (Informatica Client)
  • Start the Infromtica Services
  • Open the reepository
  • On the menu bar , click on server and choose "Add server"
  • Now enter the new server name and the host name must be "Computer name"
  • click on OK
  • On menu bar click on "Connections" and choose the relational option.
  • Now we have to create teo relationals one for Source and the other for Target Database.(Be careful wen you enter login information)
  • Successfully server created.
 
Configure Informatica Server

  • Go to All Programs
  • Informatica Power Center 7.1.1 >Informatica Power center -Server > Informatica Server Setup
  • It prompts with a box ..click on Continue button.
  • Now you find a bigger prompt with set of tabs with different options.
  • In the first tab "Server" tab
  • Server Name :: Temporary server name
    TCP/IP Host Name :: Computer Name
  • Click on "Repository" tab
    Repository Name:: Name of the repository created at console place
    Repository User :: Username of Repository
    Repository Password :: Password of Repository
    Repository Server host Name :: Computer Name
  • Now move to "License" tab
    Enter Option key , click on update
    Enter Connectivity , click on update
  • Click on ok

If you want us to add any more information in this article .Please tell us Click Here
 
Previous    
 
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