Informatica interview questions and answers part 1

Part1[1-7]  Part2[8-14]  Part3[15-23]  Part4[24-30]  Part5[31-37]  Part6[38-44]
Part7[45-51]

1. What is an update strategy ?

Ans -  Informatica processes the data in a row-by-row manner. Every row is marked to be inserted in the target table (this is default behaviour). If the row has to be updated or inserted on basis of any logic then update Strategy transformation should be used. The logical condition can be specified in Update Strategy to specify the processed row for update or insert as desired.

2. What are the options available for update strategy in informatica?

Ans - Following are the strategy option available:

0 = DD_INSERT

1 = DD_UPDATE

2 = DD_DELETE

3 = DD_REJECT

3. What are the difference between  data warehouse ,data mart and database?

Ans - In Data warehouse there are assortments of all sorts of data. Here data is brought out only depending on the customer needs. Database includes a set of sensibly affiliated data which is normally small in size as compared to data warehouse. Datamart is a set of data which is designed to serve the desires of different domains.

4. What are the different threads in a DTM process?

Ans - Following are the 5 threads in DTM process

• Writer thread
• Reader thread
• Pre and post session threads 
• Mapping thread
• Master thread

5. What are the different types of groups in Router Transformation?

Ans There are three different types of groups in Router Transformation as below

• Input group
• Output group
• Default group

6. How are  Router and Filter transformations similar?

Ans - Both Filter and Router transformation are Active transformations.They are used to filter the data based on condition. Both Filter and Router transformation are connected.

7. What is a mapplet?
Ans-  A Mapplet is a reusable object that can be created from mapplet designer. It contains set of transformations and it allows us to reuse that transformation logic in multiple mappings.

Part1[1-7]  Part2[8-14]  Part3[15-23]  Part4[24-30]  Part5[31-37]  Part6[38-44]
Part7[45-51]