Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

what is lookup ?

7 16869

what is the architecture of any Data warehousing project?

IBM,

5 21125

what is the flow?

1 8571

How to load time dimension?

Ford,

1 15864

In update strategy target table or flat file which gives more performance ? why?

7 26577

How do you create single lookup transformation using multiple tables?

TCS,

6 44887

Why touse stored procedure in ETL Application?

2 12032

How to improve the performance of Aggregate transformation?

Dmss,

3 14455

What is critical mapping?

2 11503

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

Accenture,

1 20001

How to view and Generate Metadata Reports?

1 7935

what is difference between COM & DCOM?

Satyam,

1 11289

what is the gap analysis?

1 9598

How to recover sessions in concurrent batches?

3 15901

what are the different types of transformation available in informatica and what are the mostly used ?

TCS,

3 25471

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are session parameters ? How do you set them?

1901

What is a passive transformation?

1154

How to Create a folder using pmrep command?

1224

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1317

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1949

What is domain and gateway node?

1208

What is the function of union transformation?

1207

What is the difference between STOP and ABORT options in Workflow Monitor?

1317

How to improve the performance of a session using sorter transformation?

1191

How to do the error handling of if ur source is flatfiles?

2024

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9902

What the difference is between a database, a data warehouse and a data mart?

1203

How do you load only null records into target? Explain through mapping flow.

2077

What is data caches/ index caches?

1174

Briefly define reusable transformation?

1186

For More Un-Answered { Informatica } Questions Click Here