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

Sunday, 2 November 2014

Informatica Admin Interview Questions

By on 08:22:00

This is regarding informatica administrator interview questions,If you applying for informatica administrator position in any some company focus on informatica installation steps in windows and unix platform, then prepare the question which is mentioned below.

The following questions has been asked frequently in Wipro,Accenture, HCL, TCS, CTS, Hexaware, Seventhsense technologies, IBM. Make sure you preparing well for informatica administrator position

1 How to compare two versions of an object

2 How do you take back up of repository?

3 What do you mean by DTM and Load manager and what is difference between load 
manager and load balancer?

4 If your server is running on Unix and one of the sessions are keep on running without loading any data how would you kill it.

5 What does nodemeta.xml file contain?

6 What is service manager and how does it works?

7 Can we create multiple integration service on single repository?

8 Is it possible to define a single node as a Gateway node as well as worker node?

9 What is a node in Informatica?

10 Pmrep and pmcmd command

11 Is it possible to create multiple domains on a single Informatica server?

12 What is exclusive and normal mode for repository services?

13 Can we create a Integration service without a Repository service and vice versa.

14 What is a difference between complete, stop and abort

15 How would you join a node to the already existing domain?

16 What is a Repository and difference between repository database and repository service

17 What is the difference between STOP and ABORT options in Workflow Monitor?

18 What is domain and gateway node:

19 What is native users

20 How do you migrate data from one environment to another.

21 How do you start and stop services in unix without using admin console

22 What happens when a session fails and you click on recover?

23 What do mean by local and global repository?

24 What does “tail –f” command do and what is its use as an Informatica admin.

25 What all are steps in up gradation of Informatica server?

26 What is a shortcut and copy in Informatica and how two are different with each other.

27 What is deployment group

28 While migrating the data from one environment to another environment how would you manage the connections?

29 How to start a workflow using pmcmd command

30 What do you understand by SOA of Informatica?

31 Is it possible to revert a global repository to local one and why?

32 What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

33 What all challenges you faced in Informatica in your last project as an admin and how did you resolve them?

34 Is it possible to use a client with different version than that of its Informatica server?

35 How do you manage the Parameter files while migrating your data from one environment to another environment?

36 What is a code page

37 What is meant by LDAP users

38 Have you ever worked with licensing objects and if a license expires what would be your approach. Do we have to create another repository and upload the content or the older repository will work.

39 What could be the possible resons of locks by user.

40 How to open an older version of an object in the workspace

41 What is a grid in Informatica?

42 I am not able to connect to the domain with the client although all services and databases are up and there is no network issue.

43 What is primary and backup node?

44 What is data movement mode in Informatica and difference between them?

45 How would you copy the content of one repository to another repository(The new repository is not having anything in it)

46 What is resilience time?

47 How to go to the older version for a mapping.

48 What is DR strategy for Informatica project?

49 What is an Integration service in Informatica?

50 What is difference between a gateway node and worker node?

51 Creating a folder using pmrep command

52 Can we create two repositories on same database instance in oracle?

53 Can we create a node as a gateway node and the same node can be assigned to a grid?

54 What are roles and groups and benefits of using them?


  1. It could be helpful if you provide answers

  2. Awesome blog..
    Thanks for sharing.


Blog Archive


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 (1) OBIA (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)