Restoring Informatica Code from existing repository database.

Assumptions

1.       An existing informatica setup with server existing on Linux Box A (internal i.p: a.b.c.d) and repository metadata existing on Relational Database Service (RDS- A)

2.       Following componenets exist on this environment

a.       Domain-Domain_abc

b.      Node-node_abc

c.       Repository Service-RS-A.

d.      Integration Service-IS-A.

3.       Linux Box A gets corrupted. The OS team provides a fresh Linux Box B with the same internal IP (a.b.c.d)

4.       This document will explain how to recover the Informatica code that was made using repository service-RS-A

Steps to be followed

1.       On Linux Box –B – Re-install informatica Server

·         Keep the repository database same

·         Make new Domain- Domain_def

·         Make new node- node_def

2.       Access the administrator console and login using admin credentials.

3.       Configure the Repository RS_def

   We get the following error

 We now try creating the Repository Service with the same name i.e. RS_abc

 Since the content already exists in the database we select the Content exist option as shown below

Repository Service RS_abc is created and is in disabled mode. 

Enable the repository using the enable button. RS_abc is up and running now.

You may now configure the domain and the repository. When you log into the repository you can see the old code.

1

Informatica Opportunities in Delhi NCR

Healthcare
1. Stryker-Gurgaon -Dev and Prod support projects
2. United Health Group-Gurgaon/Noida-Dev and Prod support projects

Capital Markets
1. Headstrong-Morgan Stanley clients-Noida-Prod support projects
2. American Express-Gurgaon-Dev and Prod support projects
3. Black Rock-Gurgaon-Prod support projects
4. Fidelity

Miscellaneous
1. CentureyLink-Noida (Telecomm)
2. Deloitte
3. Expedia
4. ZS Associates

IT Services
1. HCL
2.Accenture
3.TCS
4.Sapient
5.IBM

User-Group Creation and Management in Informatica

Please refer the below matrix while making Informatica users/groups. The Matrix also has folder level permission details.

Development –

Repository Service			Admin	Developer	Monitor	Deployer	Operator	User
	Folder
		Create
		Copy
		Manage Versions	X			X
	Runtime Objects
		Create, Edit, and Delete	X	X		X
		Manage Versions	X	X		X
		Monitor	X	X		X	X	X
		Execute	X	X		X	X	X
		Manage Execution	X	X		X	X	X
	Global Objects
		Create Connections	X			X
		Manage Deployment Groups	X			X
		Execute Deployment Groups	X			X
		Create Labels	X			X
		Create Queries	X			X
	Tools
		Access Designer	X	X	X	X	X
		Access Repository Manager	X	X	X	X	X
		Access Workflow Manager	X	X	X	X	X
		Access Workflow Monitor	X	X	X	X	X
	Design Objects
		Create, Edit, and Delete	X	X
		Manage Versions	X	X
	Sources and Targets
		Create, Edit, and Delete	X	X
		Manage Versions	X	X
	Folder Access Development		RWX	RWX	R--	RWX	R-X
	Folder Access Validation		RWX	---	R--	RWX	R-X
	Folder Access Production		RWX	---	R--	RWX	R-X

Validation and Production –

Repository Service			Admin	Developer	Monitor	Deployer	Operator	User
	Folder
		Create
		Copy
		Manage Versions	X
	Runtime Objects
		Create, Edit, and Delete
		Manage Versions
		Monitor	X	X	X	X	X	X
		Execute	X	X	X	X	X	X
		Manage Execution	X	X	X	X	X	X
	Global Objects
		Create Connections	X			X
		Manage Deployment Groups	X			X
		Execute Deployment Groups	X			X
		Create Labels	X			X
		Create Queries	X			X
	Tools
		Access Designer	X	X	X	X	X
		Access Repository Manager	X	X	X	X	X
		Access Workflow Manager	X	X	X	X	X
		Access Workflow Monitor	X	X	X	X	X
	Design Objects
		Create, Edit, and Delete
		Manage Versions
	Sources and Targets
		Create, Edit, and Delete
		Manage Versions