Skip to main content

Steps for installation informatica 9 for OBIA 7.9.6.3



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


Comments

Popular posts from this blog

Contact Me

Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com

Top 130 SQL Interview Questions And Answers

1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10

Informatica sample project

Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope