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

REP_51002 error – Database driver error-Informatica Error

This error generally occurs when we are configuring a new repository service. We need to set these environment variables.

1. PATH=$PATH:$ORACLE_HOME/bin

2. ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/client_1

3. ORACLE_BASE=/home/oracle/app/oracle

4. LD_LIBRARY_PATH=/home/oracle/app/oracle/product/11.2.0/client_1/lib

5. TNS_ADMIN=$ORACLE_HOME/network/admin

After setting the following environment variables in the .bash_profiles of /root or /linuxuser reboot the linux server. Manually start tomcat from $INFA_HOME/tomcat/server/bin > sh infaservice.sh startup

REP_61082 - Code page incompatibility-Informatica Error

This error generally occurs when there is code page mismatch between the repository service and the integration service. Go to Informatica Integration Service > Processes >General Properties >Edit

To set the code page to the same as that of the repository service.Please refer snapshot below.The arrow shows the edit button that needs to be clicked.

Headstrong- Company Review

Pros - Had once been the destination of elite brains from top engineering and management colleges from India.Some of which have decided to stay back.Good development projects in healthcare and capital markets domain.A culture for learning of domain.Notice period 2 months.

Cons- The company has been exponentially degrading after Genpact acquisition. Most of the old staff have resigned . The company is loosing its brand name and vision to that of Genpact which has a very conservative approach.Will not suggest people to join the company.