Informatica Admin Interview Questions And Answers
1. What Is A Node In Informatica?
Answer: A node in Informatica is a logical representation of a machine.
2. How To Go To The Older Version For A Mapping?
Answer: There is no direct approach to revert back a mapping to the 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 a new name and then import the file.
3. Can We Create Multiple Integration Service On Single Repository?
Answer: Yes it is possible to create multiple integration service on a single repository. This is used when you have to choose different code page for different integration service in the 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)
4. What Is A Difference Between Complete, Stop, And Abort?
Complete: Allows the sessions and workflows to run to completion before disabling the service process.
Stop: Stops all sessions and workflows and then disables the service process.
Abort: Attempts to stop all sessions and workflows before aborting them and disabling the service process
5. 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 also)
II. Import and Export: Exporting the object definition in the 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 the picture. Create a deployment group, add then folders and object to it and then migrate the deployment group.
6. 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 machine 2. Then go to machine 2-Open Installer-> join node to the domain while configuring domain and provide the existing domain details.
7. What Is Primary And Backup Node?
Answer: The primary node is a node where a current node or applications are running and the backup node is defined to run the domain or applications services while the primary node goes down
8. What do you understand by SOA of Informatica?
Answer: SOA or service-oriented architecture allows the Informatica to have services on a 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 the client it goes to the domain or the gateway node and then it directs the request to the appropriate nodes or services. (SVR Training Online)
9. Can we create two repositories on the same database instance in oracle?
Answer: It is not possible to create two repositories on the same instance of the database in oracle as it will be creating the metadata tables for the repository. However, it is possible to create two repositories in oracle on the same server if the database instance is different.
10. How Do You Take Back-Up Of Repository?
Answer: Login to the admin console. Select the repository-> Action->Backup Content
The backup content will be stored in an XML file and the location of the backup directory is defined in the domain configuration.
Also, you can create a script and schedule it to back up the content on a certain date and time.
In script first, connect to the repository using pmrep command and then back up the content with the below command.
11. What is the difference between a gateway node and worker node?
Answer: A gateway node is a node on which domain is defined and it acts 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.
12. Is it possible to define a single node as a Gateway node as well as a worker node?
Answer: Yes it is possible to define a node to act as both gateway node as well as a 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.
13. While Migrating The Data From One Environment To Another Environment How Would You Manage The Connections?
Answer: While migrating the folder or workflows make sure the connection name in both environments is the same.
In the workspace or Navigator, select an object and click Versioning > View History.
Select the versions you want to compare and then click Compare > Selected Versions.
14. What Do You Mean By Dtm And Load Manager And What Is Difference Between Load Manager And Load Balancer?
Load Balancer: The Integration Service uses the Load Balancer to dispatch tasks. The Load Balancer dispatches tasks to achieve optimal performance. It may dispatch tasks to a single node or across the nodes in a grid.
Data Transformation Manager (DTM) process: The Integration Service starts a DTM process to run each Session and Command task within a workflow. The DTM process performs session validations, creates threads to initialize the session, read, write, and transform data, and handles pre- and post-session operations.
15. How to open an older version of an object in the workspace?
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.
16. 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.
17. What is resilience time?
Answer: Resilience time is the time defined in Informatica to wait before it loses the connection
Eg: If your resilience time is 180 sec and the network goes down so Informatica will wait for 180 sec and if the 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.
18. 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.
19. What is DR strategy for Informatica project?
Answer: A backup node can be defined for all nodes and services, so in case 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
20. What Is A Repository And Difference Between Repository Database And Repository Service?
Answer: The 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 have 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.
Repository database is a database which contains all the metadata whereas the repository service is nothing but a service which runs on the repository database and provides its services.
OPB_Mapping: This table contains all the mapping names.
21. What Do Mean By Local And Global Repository?
Answer: The local repository is a repository whose objects are accessible within that repository only.
A global repository is a repository which can share its objects among the domain in a different repository.
A mapping created in the global repository can be accessed to all repositories in the domain.
22. Pmrep and pmcmd command?
Answer: pmrep and pmcmd commands are the command-line interfaces to perform Informatica related task. These command s are used mostly in the form of scripts. Pmrep has 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 the repository. Once connected you can create a folder in the repository by below command
Pmrep create a folder –f Foldername –o OwnerName company
Some of the pmcmd commands:
I. Start workflow
II. Stop workflow
V. Schedule workflow
VII. Stop task
23. What Could Be The Possible Reasons Of Locks By User?
Answer: Network problems occur.
A PowerCenter Client, Integration Service, Repository Service, or database machine shuts down improperly.
24. 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.
25. 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.
26. What are the 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 the domain and then routed to associated services. A gateway node is a node on which a domain is defined.
27. What Is Meant By LDAP Users?
Answer: LDAP users are the user which are configured with LDAP server (also maybe MS Active directory ) and LDAP is integrated with power center to allow users to provide single sign-on.
28. What Do You Mean By Parameter File? Why Do We Use It And What All Things We Can Define In A Parameter Files?
Answer: Parameter file is a file assigned to a session which has configuration details in it. The parameter file is used for reusability. Below things are defined in it.
Connections, mapping parameter, mapping variable.
29. What is an Integration service in Informatica?
Answer: Integrations service is an 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 another.
30. What Is Data Movement Mode In Informatica And Difference Between Them?
Answer: The data movement mode depends on whether Informatica server will process a 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.
31. What Is A Shortcut And Copy In Informatica And How Two Are Different With Each Other?
Answer: A shortcut is an object which is defined inside a shared folder and used in different folders. Whereas a copy is the replica of any object.
You cannot change the definition of a shortcut but can be changed in case of a copy.
The shortcut is useful in cases where the source or target definition is the same across multiple applications.
You just need to drag the source from the shared folder and change the connections while creating a workflow in a folder.
32. Is It Possible To Create Multiple Domains On A Single Informatica Server?
Answer: Yes it is possible to create multiple nodes on the same Informatica server.
33. What Happens When A Session Fails And You Click On Recover?
Answer: Every session has a property of commit interval. Commit interval is a point after which a session creates a log and commits the transaction at source, target or both levels. For each commit interval, it generates an id corresponding for each row and when a session is recovered it reads the last id inserted to target and then proceeds the loading from next row.
Eg: Source is having 1000 rows and commit interval is set to 50 so it will commit for every 50 rows. Now session fails at row no 630. Now the target rows will be committed till 600th row as commit interval is 50. Once we recover a session the loading will start from 601st row.
34. Can we create a node as a gateway node and the same node can be assigned to a grid?
Answer: Yes it is possible to assign a gateway node to a grid.
35. What Is Exclusive And Normal Mode For Repository Services?
Answer: Exclusive mode is a mode defined while you make any changes to repository service. It’s like a lock while you play with repository configuration so its associated services like integration services will not be able to use its services.
36. How Would You Copy The Content Of One Repository To Another Repository(the New Repository Is Not Having Anything In It)?
Answer: backup the repository using pmrep and restore the content on the new repository.
37. What Is The Difference Between Stop And Abort Options In Workflow Monitor?
Answer: Stop waits for all running objects to complete and then terminate the process however abort stops the entire object running immediately.
Eg: A workflow is in running state and it’s having 5 sessions in it and only 2 sessions are running.
STOP: It will wait for the running sessions to complete their process and then terminate the workflow. Remaining 3 sessions will not run.
ABORT: It will kill the running session immediately and thus the workflow.
38. What Are Native Users?
Answer: Native users are the users created with the admin console.
39. What All Challenges You Faced In Informatica In Your Last Project As An Admin And How Did You Resolve Them?
Answer: The Oracle client was not installed properly on the Informatica server and also the tns entry in oracle client was not properly. During Informatica server installation the domain was not able to ping to the database due to the client issue.
The Informatica admin console was not opening due to open files in OS
Used ulimit –n command to check open files and then increased the no to 4096.
40. What All Are Steps In Upgradation Of Informatica Server?
Answer: To upgrade Informatica power center from one version to other version follows the below steps.
Upgrade Informatica server
Login to admin console help-> About Informatica administrator and see the upgraded version
Select on repository Action->Content->Upgrade
Select on repository action-Content-> upgrade users and groups.