Informatica Interview Question - Node and Domain

Informatica Interview Question - Node and Domain

1. What is a Node? 

• When you install and run the informatica services, the installation is known as Node. 
• The logical representation of informatica installation is known as Node.

     2. What is Domain?

• Domain is a grouping of one or more nodes.
• A domain forms an environment upon which the informatica serivce processes run.
• A node from the domain connects to a relational database.
• This database have the tables of domain configuration repository.
• You can add nodes to the domain, when you install the node.
• (Basic description is : There is a node, there is a domain database. The stuff runs on Node and the domain has/stores the stuff.)
• Informatica supports Oracle, IBM DB2,Sybase,MQSQLserver for domain database

      3. What are the types of nodes?

•       Basically the node is of two types, Worker node and Gateway Node.

      4.  Describe Worker , Gateway and Master Gateway Node?

•  A node can either be a worker node or a gateway node.
•  Domain can have more worker node and gateway nodes but only one Master Gateway node.
• Each Domain has a minimum of one Gateway node.

Gateway Node:

• Gateway node runs the management services.
•  A gateway node connects to the domain database and changes the metadata stored in the domain tables.
• At a time, these tasks
• A gateway node acts as the master gateway node, which runs the management services of all the domains and it is the one node in the domain which changes the domain database.

Worker Node:

•     Worker node runs the Application Services.
• Cannot connect to the Domain database.

    5. What happens when the master gateway node fails?

•      One of the other gateway node elects the master gateway node.

Update Records Without using Update Strategy

Update Records Without using Update Strategy


This is very simple procedure.

Create a mapping. There is nothing to do with powercenter designer.

While creating session, we have to change few properties in the session property.

Mapping Designer

Edit Tasks - Properties - Treat Source Rows As - Update

Edit Tasks - Mapping - Update Else Insert  - Select

Joiner Transformation

Joiner Transformation:

You can join two tables using the Joiner Transformation. If you need to join 3 table Sources, then 2 Joiner Transformation is required. So if you need to join N number of source, you need N-1 Joiner Transformation.

The Joiner Transformation joins the source based on one or more condition between the 2 sources.

The 2 input source pipeline has master and detail pipeline. By default, the second source is considered as Master.

Mapping Designer

Joiner Transformation Edit- Give the Condition based on 2 source Table

Select Master/Detail for Source

Below query is executed for the above mapping.

select e.employee_id,first_name,d.department_id,d.department_name,e.email from employees e left outer join departments d on e.department_id=d.department_id;

This is otherwise called Normal Join.

Normal Join

Matching rows from master table and detail table

Master Outer Join

Returns the rows from detail table and the matching records of both the table.

Detail Outer Join

Returns the rows from master table and the matching records of both the table.

Start the Informatica Service using Task Manager

Start the informatica server

Using the task manager you can start the informatica server.

Task Manager - Start Informatica Server