Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Sunday, 16 February 2014

Steps for installation informatica 9 for OBIA 7.9.6.3


By on 07:14:00



Steps for installing Informatica 9.0.1 server and client
1.       Create user infa and infadm using sqlplus.


2.       Go to the informatica folder
<Informatica 9.0.1/infa 9.0.1….> ( the location is that the software were you are copied the software)



3.       Go to the server folder to install the Informatica server and click install.




4.       The installation process will start
5.       Select the installation type and give next

6.       Verify the pre-requisites to start the installation

7.       Select the licence key and installation path to install the informatica





8.       After giving the license key and installation directory give next , it will calculate the disk place to installation



9.       After that it will show the installation summary and confirm and click install
10.    Installation process will start




11.   Configuring the installation

12.   After configuring , create domain





13.   Click the “create a domain” then uncheck the “enable HTTPS for informatica Administrator”

14.   Configure the database for the domain configuration repository


Change the database type according to your database installed
Change the database user id “admin” to “ infadm” and required password
Change the JDBC URLà Database address from host_name:port_no” to “hostname or ipaddress:1521”
Click test connection.

15.   Create domain and give information

Give the domain user name : Administrator
Give the domain password : Administrator
Give the confirm password: Administrator
Click next.


16.  To assign configuration

Check out “Run Informatica under a different user account” and click next

17.   Starting service and installation status will become success and click done to exit.








18.   To install informatica client go to the directory the software contain.
<informatica_home/901HF2_clientinstaller_win-32-x86/client> and click install file to run.

19.   Select install option and directory and click next.



20.   Pre- requisite process will take down – confirm and click next


21.   Select the component “Informatica powercenter client 9.0.1 hotfix2” and click next.

22.   Review the information and confirm to install informatica client and click install


23.   Installation process will start


24.   Installation status – success then click done to exit

25.   Check the informatica server and client installed or not.
Click startàInformatica 9.0.1àserver & client



26.   Set the environment variable to start services.
Mycomputerà rightclickàpropertiesàadvancedàenvironment variables
Goto system variableà newàgive
Variable nameàINFA_DOMAINS_FILE
Variable valueà”systempath” as ex.”c:\informatica\9.0.1\domains.infa



27.   Create newàserver ,client and tomcat path and system path
Variable nameàpath
Variable valueà”c:\....”
28.   Restart the system





29.   Check the services started or not
Goto runàtype “services.msc” and click ok

30.   After the service start go to Informatica Administrator page
Startàinformaticaàserverà administrator console
31.   Give username and password as “Administrator” and log in



32.   Informatica Administrator  page will open with domain we created before.

33.   Go to action and click new to create new repository
Domainàaction->new->”power center repository service”




34.   A dialogue box will open to create a new repository with step 1 of 2

Give nameàOracle_BI_DW_Base
Location as defaultà domain_7stl
License as defaultà901_License_7stl_48451
Node as defaultànode01_7stl

 
Step 2:
Datebase typeàOracle
Usernameàinfa
PasswordàAdmin123
Connection stringà ORCL
Code pageà as default
Check in “No content exists…….”
Then click finish


35.   Repository will create and enabling the service


36.   After enabling the service the “the powercenterrepository service will get available”

37.   Create the integration service
Go to action and click new to create new repository
Domainàaction->new->”power center integration service”

Step1:
Name àOracle_BI_DW_Base_Integration_Service
Locationàdomain_7stl
Licenseà901_license_7stl_48451
Nodeànode01_7stl
Step 2:
Powercenter Respository ServiceàOracle_BI_DW_Base             
UsernameàAdministrator
Passwordà Administrator
Date movement modeàunicode



Specify the code page
38.   Enabling the integration service

Service is available


39.   Change the validate data code pages from yes to no
Click the edit option in configuration properties , you will get the dialogue box with check in of “validatedatacodepages”

After check out the validate code page



40.   Change the operating mode from exclusive to normal
Click Oracle_BI_DW_BaseàRepository propertiesà repository mode



41.   Restart  the repository service.. click ok
Click ok.
42.   Enable the repository service

43.   Creating and deleting the content
Change the mode operating mode from “exclusive to normal”


44.   Go to repository properties click edit
45.   Restart the service

46.   Enabling the service.
47.   Go to Oracle_DW_BI_Base in right side click “action”
ActionàRepository contentsàdelete
48.   A dialogue box will open to confirm to delete the contents

Give usernameà”Administrator”
Give passwordà”…………”

49.   Deleting process will take down
50.   Backup or restore the contents
Change the mode to exclusive
Goto actionàrepository contentsàrestore


51.   Select the restore repository backup  file

52.   Restore as new

53.   Confirm the restore process
Restoring contents is on process

54.   Change the timeout options in Oracle_DW_BI_Base in “advanced properties”



Click edit in Oracle_BI_DW_Baseàadvanced properties(rightside) àclick edit

Change the resilence timeout values to 1000
Heart beat interval value to 1000

Enabling and recycle the service.







55.   Edit custom properties
Click edit
A dialogue box will open to edit and create new properties

Create 4 new  custom property
Name
Value
 SiebelUnicodeDB
apps@R12PLY baw@orcl
overrideMpltVarWithMapVar
Yes
DisableDB2BulkMode
Yes
ServerPort
4006

56.   After creating the custom property






57.   Restoring and creating backup files
Backup the source and lookup files from obia informatica to informatica
<informatica_home/9.0.1/server/infa_shared\srcfiles>










Copy the source files to this location


Look up files
<informatica_home\9.0.1\server\infa_shared\lkpFiles>




Copy to this location

58.   Enable and recycle the services. Then logout from Informatica Administrator Console.
59.   Copying the pmcmd file from server to client


60.   Then restart the service

61.   Go to Informatica Powercenter Workflow Manager



62.   Open the repository to configure domain






63.   Configuring domain

Check in the Oracle_BI_DW_Base





64.   The repostiory will create in the workflow manager

Right click on Oracle_BI_DW_Baseàclick connect


Give usernameà Administrator
Give passwordà Administrator




Click connect to the repository 
After connecting it will show the default mappings




65.   Check the connections and repository is connected or not in Repository workflow manager






66.   Go to workflowmanager
Connectionsàrelational
For create and  connecting database





67.   Select oracle and click new

Name: ORA_R12
Username: apps
Password: apps
Connect string : R12PLY




Click new
Name: DataWarehouse
Username:baw
Password:baw
Connectstring: orcl


0 comments:

Post a Comment

Blog Archive

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (46) Informatica Online Training (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (1) OBIEE 10G (8) OBIEE 11G (137) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)