Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 14869

what is the architecture of any Data warehousing project?

IBM,

5 19270

what is the flow?

1 7446

How to load time dimension?

Ford,

1 14820

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

7 24402

How do you create single lookup transformation using multiple tables?

TCS,

6 42457

Why touse stored procedure in ETL Application?

2 10738

How to improve the performance of Aggregate transformation?

Dmss,

3 12989

What is critical mapping?

2 10430

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

Accenture,

1 19020

How to view and Generate Metadata Reports?

1 7062

what is difference between COM & DCOM?

Satyam,

1 10468

what is the gap analysis?

1 8562

How to recover sessions in concurrent batches?

3 14537

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

TCS,

3 24149


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is session task and command task?

765


What is the difference between Active and Passive transformation?

758


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

1621


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1655


What are mapplets? How is it different from a Reusable Transformation?

754






Explain direct and indirect flat file loading (source file type) - informatica

985


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

800


Partition, what happens if the specified key range is shorter and longer

2137


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2097


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

684


How would you copy the content of one repository to another repository?

679


Enlist the differences between database and data warehouse.

665


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1793


Explain what are the different versions of informatica?

790


How can we use batches?

707