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

Informatica Interview Questions

Questions Answers Views Company eMail

What is the Hierarchy of DWH?

1 7729

How many repositories can we create in Informatica?

3 8510

What is surrogate key?

9 26298

What is difference between Mapplet and reusable transformation?

Wipro,

9 43960

What is aggregate awareness?

1 9417

Explain reference cursor?

1 9409

What are parallel querys and query hints?

1 8003

While importing the relational source defintion from database,what are the meta data of source U import?

1 6172

Howmany ways yoU can update a relational source defintion and what are they?

1 5688

Where should yoU place the flat file to import the flat file defintion to the designer?

4 10870

To provide support for Mainframes source data,which files r used as a COBOL files

1 4228

Which transformation should u need while using the cobol sources as source defintions?

2 5372

How can yoU create or import flat file definition in to the warehouse designer?

2 8446

what is a transforamation?

5 7890

What are the designer tools for creating tranformations?

Informatica,

1 6055

Post New Informatica Questions

Un-Answered Questions { Informatica }

Is stop and abort are same in informatica?

950

Write the prerequisite tasks to achieve the session partition?

1075

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5563

How can we use batches?

968

What is the different lookup cache(s)?

1037

What are the tuning techniques you applied during your last project

1970

How to elaborate powercenter integration service?

1075

What is rank transformation?

932

What is the meaning of up gradation of repository?

1900

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1645

What's the layout of parameter file (what does a parameter file contain?)?

2338

Explian the Process of deployment groups in informatica

993

How do you load unique records into one target table and duplicate records into a different target table?

1167

What are the types of presistent cache in look up tr.

2009

What are the new features of informatica 9.x at the developer level?

988

For More Un-Answered { Informatica } Questions Click Here