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 7819

How many repositories can we create in Informatica?

3 8676

What is surrogate key?

9 26723

What is difference between Mapplet and reusable transformation?

Wipro,

9 44332

What is aggregate awareness?

1 9495

Explain reference cursor?

1 9565

What are parallel querys and query hints?

1 8091

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

1 6269

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

1 5794

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

4 11072

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

1 4333

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

2 5516

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

2 8579

what is a transforamation?

5 8129

What are the designer tools for creating tranformations?

Informatica,

1 6154

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the command used to run a batch?

1062

What is aggregator transformation in informatica?

949

Briefly define a session task?

1131

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1081

How to create the source and target database connections in server manager?

1090

Sequence generator, when you move from develoment to production how will you reset

2037

What is meant by target load plan?

973

How does the aggregator transformation handle null values?

1149

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

1177

How to elaborate powercenter integration service?

1131

How many input parameters can exist in an unconnected lookup?

1545

What are the static cache and dynamic cache in informatica?

1192

What is the use of target designer?

1053

Where can we find the throughput option in informatica?

1063

Differentiate between Load Manager and DTM?

2153

For More Un-Answered { Informatica } Questions Click Here