INFORMATICA INTERVIEW QUESTION

1. Deployment groups in Informatica

Deployment group is a global object which consists of objects from one or more folders. Deployment group is used to copy objects from one or more folders to another folder or repository. You can create, edit, or delete deployment groups. You can copy a deployment group and the objects in the deployment group to a target repository.

• Deployment Group Tasks:

You can do the following tasks when working with deployment groups: Create deployment group: you can create a global object for deploying objects from one or more folders.

• Edit deployment group:

 You can modify a deployment group. You can change the static deployment group to dynamic deployment group and vice versa.  

• Configure privileges and permissions:

               Configure permissions on a deployment group and the privilege to copy a deployment group.

• View the objects in a static or dynamic deployment group:

               You can preview the objects that the Repository Service will deploy.

• Add or remove objects in a static deployment group:

You can specify what objects belong to a static deployment group. You can add or remove the objects from the deployment group.

• Associate a query with a dynamic deployment group:

Assign a query to a deployment to dynamically update the objects that the group contains.

• View the history of a deployment group:

View the history of a deployment group, including the source and target repositories, deployment date, and user who ran the deployment.

• Post-deployment validation:

Validate the objects in the target repository after you copy a deployment group to verify that the objects and dependent objects are valid.

• Roll back a deployment group:

You can roll back a deployment group to purge deployed versions of objects from the target repository.

2. Load alternative records / rows into multiple targets – Informatica

For passing alternative rows in to two targets the flow of the mapping is

SQ-> sequence generator -> Router -> TGT1, TGT2

Router filter condition is ‘(mod (sn0, 2) =0)’ give u the even number rows pass it to one target (TGT1) and the default port of the router gives u odd number rows pass it to TGT2.

3. How to create user defined function (udf) in Informatica

User – defined functions are extensions to PowerCenter transformation language. It allows you to create complex expressions using the built-in functions and operators and reuse them in PowerCenter mappings. User-defined functions are two types.

Public: Callable from any user-defined function, transformation expression, link condition expression, or task expression.

Private: Callable from another user-defined function. Create a private function when you want the function to be part of a more complex function. The simple function may not be usable independently of the complex function.

• Creating User Defined Functions

You can create a user defined function from Informatica PowerCenter Designer tool. You can invoke the user-defined function dialog box from main menu Tools > User-Defined Functions > New.  If you want a user defined function to convert the phone number into (XXX) XXX-XXXX format.

We can define the function here to convert PHONE_NUMBER into required string formatted in (XXX) XXX-XXXX. The expression editor shows the logic used within the user defined function. User defined functions can be used in any expressions just like any other functions. You can choose the available user defined functions from the functions explorer.