Blog Archive

Theme images by Storman. Powered by Blogger.

Wednesday, August 17, 2016

Latest Informatica Admin Interview Questions And Answers.


Latest Informatica Admin Interview Questions And Answers. Commonly Asked Informatica Admin Interview Questions With Answers. Informatica Admin Interview Questions For Freshers And Experienced.

1. What is a Repository and difference between repository database and repository service

Answer: Repository is metadata which means it has data about the data(objects). It stores the data regarding the Informatica objects .For eg: We have a folder say “Folder1” and 3 mappings has been created within it, so all the information regarding all objects in mapping and the folder will be stored in repository database in forms of tables.
Repsoitory database is a database which contains all the metadata whereas the repository service is nothing but a service which runs on repository database and provides its services.
OPB_Mapping: This table contains all the mapping names.

2. What is a code page

Answer: Code page contains encoding to specify characters in a set of one or more languages.
Eg: If you have Malaysian or Chinese character in your source data then you have to choose the appropriate code page for these characters else you’ll see square boxes once the data is loaded and processed as Informatica will not be able to understand those characters.

3. What is resilience time?

Answer: Resilience time is the time defined in Informatica to wait before it lose the connection
on a network failure.
Eg: If your resilience time is 180 sec and the network goes down so Informatica will wait for 180 sec and if network is established in between, the connection will be established. If the network is not up within 180 sec so the unsaved data will be lost and the client will be disconnected from the domain or repository

4. What is a node in Informatica?

Answer: A node in Informatica is logical representation of a machine.

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

Answer: The data movement mode depends on whether Informatica server will process single byte or multi-byte character data set.
There are two data movement modes in Informatica
I. Unicode: It allows two bytes for each character and uses the additional byte for each non ASCII character(Such as Malaysian characters)
II. ASCII: It holds the data in a single byte.

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

Answer: There are generally three types of methodology used for data migration in Informatica
I. Copy Paste: Copy the folder or object in one repository and click on the destination repository and paste it(This can be done with pmrep command aslo)
II. Import and Export: Exporting the object definition in xml file and then importing it to the destination folder or repository
III. Deployment group: While migrating objects in bulk the deployment group concept comes into picture. Create a deployment group, add then folders and object to it and then migrate the deployment group.

7. What is an Integration service in Informatica?

Answer: Integrations service is a application service in Informatica which run the workflows and session. It tells the Informatica server how to flow the data from source to target.
Analogy: Integration service is like a carrier truck which carries the goods (data) from one place to other.

8. Pmrep and pmcmd command

Answer: pmrep and pmcmd commands are the command line interface to perform Informatica related task. These command s are used most in form of scripts. Pmrep is used for all repository related tasks. Pmcmd is used for Informatica monitor and server related tasks
Eg: pmrep connect –r Repository_name –d Domain_name –n Username –x password
The above command connects to repository. Once connected you can create a folder in repository by below command
Pmrep createfolder –f Foldername –o OwnerName
Some of the pmcmd commands:
I. Startworkflow
II. Stopworkflow
III. Waitworkflow
IV. Recoverworkflow
V. Scheduleworkflow
VI. Startask
VII. Stoptask

9. How to start a workflow using pmcmd command

Answer: Pmcmd startworkflow [ folder]
[ taskInstancePath []]
[ paramfile]
[ localparamfile]
[ OSProfile] [-wait|-nowait]
[ runInsName] workflow

10. Creating a folder using pmrep command

Answer: Pmrep createfolder –f Foldername –o OwnerName

11. What is deployment group

Answer: A deployment group is a global object that consists of versioned objects from one or more folders. You use a deployment group to copy the versioned objects to another folder or repository. You can use a deployment group when you want to copy some, but not all, of the objects in a folder. You can also use a deployment group to copy objects from multiple folders

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

Answer: There is no direct approach to revert back a mapping to previous version however it can be achieved by the procedure defined below.
Right click on the mapping->version-View history
All the versions will be listed out. Select the version you want to revert back to and export or save its definition in local drive. Rename the last version with new name and then import the file.

13. What is DR strategy for Informatica project?

Answer:A backup node can be defined for all nodes and services, so incase if the primary node goes down the backup node can take over the control.
Note: You should have the license to create a backup node


14. How to open an older version of an object in the workspace

Answer:To open an older version of an object in the workspace:
I. In the workspace or Navigator, select the object and click Versioning > View History.
II. Select the version you want to view in the workspace and click Tools > Open in Workspace.
Note: An older version of an object is read-only, and the version number appears as a prefix before the object name. You can simultaneously view multiple versions of a non-composite object in the workspace

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

Answer: joining a node to an existing domain can be archived while installing Informatica.
Eg: Server is on machine1 and the new node is on machine2. Then go to machine2-Open Installer->join node to domain while configuring domain and provide the existing domain details.

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

Answer: Yes it is possible to create multiple nodes on same Informatica server

17. How to compare two versions of an object

I. In the workspace or Navigator, select an object and click Versioning > View History.
II. Select the versions you want to compare and then click Compare > Selected Versions.
Select a version and click Compare > Previous Version to compare a version of the object with the previous version.
The Diff Tool appears.

18. What is primary and backup node?

Answer: Primary node is a node where a current node or applications are running and backup node is defined to run the domain or applications services while primary node goes down

19. What is a grid in Informatica?

Answer: Grid in Informatica is used for load balancing. A grid is nothing but a combination of nodes which distributes the request among them.
Eg: node1, node2, node3, node4 are assigned in a grid. 10 workflows started simultaneously. Now instead of giving burden to a single node to run the 10 workflows the request for running workflows will be distributed to all nodes.

Also Read: Idiot’s Guide to Big Data

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

Answer: It is not possible to create an Integration service without a repository service however a repository can be created without an integration service.

21. Can we create multiple integration service on single repository?

Answer: Yes it is possible to create multiple integration service on single repository. This is used when you have to choose different code page for different integration service in same repository
Eg: Repository : ASIA_PACIFIC_Repo is used to load the data for countries specific to ASIA PACIFIC to target warehouse. Different Integration service created for non English countries to support different code page (Malaysia, China, Japan, Thailand)

22. What is native users.

Answers: Native users are the users created with admin console.

23. What is meant by LDAP users

Answer: LDAP users are the user which are configured with LDAP server (also may be MS Active directory ) and LDAP is integrated with power center to allow users to provide single sign on

24. What are roles and groups and benefits of using them?

25. What is domain and gateway node:

Answer: Domain is a single point of entry or the administrative unit in Informatica. All the request from different clients (like Designer) first reaches to domain and then routed to associated services. A gateway node is the node on which a domain is defined.

26. What is difference between a gateway node and worker node?

Answer: A gateway node is a node on which domain is defined and it act as a router or administrator to all services. All other nodes in a domain are worker nodes where application services like Informatica services, repository services will be running.

27. What do you understand by SOA of Informatica?

Answer: SOA or service oriented architecture allows the Informatica to have services on distributed system. You can define a domain on a node say node1 and repository service on node2, repository service on node3. All nodes can be anywhere within a network. Once a request is made from client it goes to the domain or the gateway node and then it directs the request to the appropriate nodes or services.

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

Answer: Yes it is possible to define a node to act as both gateway node as well as worker node.
Eg: The domain is created on node1 and integration services and repository services are also running on the same machine or node. In this case a node will behave both as a domain and a worker node.

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

Answer: Yes it is possible assign a gateway node to a grid.

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

Answer: It is not possible to create two repositories on same instance of database in oracle as it will be creating the metadata tables for repository. However it is possible to create two repositories in oracle on same server if the database instance is different.

0 on: "Latest Informatica Admin Interview Questions And Answers."