Skip to main content

Informatica Admin Interview Questions

By


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?
Labels:

Comments

Post a Comment

Popular posts from this blog

Contact Me

By
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
3 comments
Read more

Top 130 SQL Interview Questions And Answers

By
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
32 comments
Read more

Informatica sample project

By
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
Post a Comment
Read more