Skip to main content

Informatica Admin Interview Questions



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?

Comments

Post a Comment

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 100 Informatica Interview Questions

I have attended Informatica interview last week in wipro and couple of other companies, Question below I faced in those companies. 1. What are the main issues while working with flat files as source and as targets ? 2. Explain about Informatica server process that how it works relates to mapping variables? 3. write a query to retrieve the latest records from the table sorted by version(scd) 4. How do you handle two sessions in Informatica 5. which one is better performance wise joiner or look up 6. How to partition the Session? 7. How many types of sessions are there in informatica.please explain them. 8. Explain the pipeline partition with real time example? 9. Explain about cumulative Sum or moving sum? 10. CONVERT MULTIPLE ROWS TO SINGLE ROW (MULTIPLE COLUMNS) IN INFORMATICA 11. DEPLOYMENT GROUPS IN INFORMATICA 12. LOAD LAST N RECORDS OF FILE INTO TARGET TABLE - INFORMATICA 13. LOAD ALTERNATIVE RECORDS / ROWS INTO...

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 commissi...