Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 15151

what is the architecture of any Data warehousing project?

IBM,

5 19542

what is the flow?

1 7639

How to load time dimension?

Ford,

1 14941

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

7 24728

How do you create single lookup transformation using multiple tables?

TCS,

6 42863

Why touse stored procedure in ETL Application?

2 10900

How to improve the performance of Aggregate transformation?

Dmss,

3 13197

What is critical mapping?

2 10574

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

Accenture,

1 19161

How to view and Generate Metadata Reports?

1 7179

what is difference between COM & DCOM?

Satyam,

1 10576

what is the gap analysis?

1 8832

How to recover sessions in concurrent batches?

3 14703

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

TCS,

3 24339


Post New Informatica Questions

Un-Answered Questions { Informatica }

update strategy transformation in informatica

807


What do you mean by filter transformation?

729


differences between service based and product based?

1749


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1393


How to handle decimal places while importing a flatfile into informatica?

924






Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1520


Enlist few areas or real-time situations where informatica is required.

794


State the differences between sql override and lookup override?

825


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

821


Did u used latest transformations of 8.6.0? for what?

1629


What is the difference between source qualifier transformations source filter to filter transformation?

827


explain abt ur project architecture?

1900


While migrating the data from one environment to another environment how would you manage the connections?

841


Explain what transformation and how many are there in informatica?

682


Have you worked with/created Parameter file

1382