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 8679

What is surrogate key?

9 26728

What is difference between Mapplet and reusable transformation?

Wipro,

9 44335

What is aggregate awareness?

1 9495

Explain reference cursor?

1 9568

What are parallel querys and query hints?

1 8093

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

1 6272

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

1 5795

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

4 11076

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

1 4334

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

2 5518

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

2 8582

what is a transforamation?

5 8131

What are the designer tools for creating tranformations?

Informatica,

1 6154

Post New Informatica Questions

Un-Answered Questions { Informatica }

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

1968

How can repository reports be accessed without sql or other transformations?

1219

How will the document be delivered to me?

1085

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

1141

What is rank index in rank transformation?

1080

What does update strategy mean, and what are the different option of it?

1091

How to open an older version of an object in the workspace?

1205

What do you mean by channel change?

1047

What is an active transformation?

1110

How can we use batches?

1025

What is a sequence generator transformation?

1021

How to extract sap data using informatica?

1042

Explain the difference between mapping parameter and mapping variable?

1038

what is the size of your data warehousing?

2095

What is the status code in stored procedure transformation?

1182

For More Un-Answered { Informatica } Questions Click Here