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 7897

How many repositories can we create in Informatica?

3 8810

What is surrogate key?

9 27045

What is difference between Mapplet and reusable transformation?

Wipro,

9 44635

What is aggregate awareness?

1 9568

Explain reference cursor?

1 9692

What are parallel querys and query hints?

1 8156

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

1 6375

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

1 5889

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

4 11234

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

1 4415

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

2 5608

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

2 8699

what is a transforamation?

5 8346

What are the designer tools for creating tranformations?

Informatica,

1 6236

Post New Informatica Questions

Un-Answered Questions { Informatica }

What all are steps in up gradation of Informatica server?

1096

Explain constraint based loading in informatica

1157

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9308

What are the tuning techniques you applied during your last project

2078

During the running session, output files are created by informatica server. Enlist few of them.

1025

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1134

What are the popular informatica products?

1059

Explain the different dimensions.

1010

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1312

What is update strategy transform?

1166

Design a mapping to load a target table with the following values from the above source?

1395

Make a note of the quantity vaults made in informatica?

1046

What is the sequence generator transformation in informatica?

1267

Which version configuration tool used in ur project?

3324

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1143

For More Un-Answered { Informatica } Questions Click Here