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 7813

How many repositories can we create in Informatica?

3 8657

What is surrogate key?

9 26694

What is difference between Mapplet and reusable transformation?

Wipro,

9 44294

What is aggregate awareness?

1 9491

Explain reference cursor?

1 9550

What are parallel querys and query hints?

1 8088

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

1 6258

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

1 5783

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

4 11054

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

1 4321

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

2 5501

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

2 8564

what is a transforamation?

5 8113

What are the designer tools for creating tranformations?

Informatica,

1 6148

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the popular informatica products?

1008

What is the sql query overwrite in source qualifier in informatica

1083

Why update strategy and union transformations are active? Explain with examples.

1235

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1866

What is workflow? What are the components of workflow manager?

1171

What is the scenario which compels informatica server to reject files?

1065

Explain incremental aggregation in informatica

1121

Describe an informatica powercenter?

1121

What do think which one is the better joiner or look up?

1201

How can you generate reports in informatica?

1022

How to elaborate powercenter integration service?

1127

Target increases every day even though no new record was inserted

1569

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

1232

Differentiate between source qualifier and filter transformation?

1572

What is meant by LDAP users?

1199

For More Un-Answered { Informatica } Questions Click Here