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

Informatica Interview Questions

Questions Answers Views Company eMail

What are the circumstances that infromatica server results an unreciverable session?

1 5186

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 7813

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 12825

What are the Advantages of de normalized data?

3 8917

What is operational data source (ODS)?

7 27431

What is meta data and system catalog?

2 8300

What is factless fact schema?

1 9404

What is confirmed dimension?

3 9828

What is the capacity of power cube?

1 4406

What is the Difference between PowerPlay transformer and power play reports?

1 6184

What is IQD file?

1 7886

What is Cognos script editor?

Cognizant,

4224

What is difference macros and prompts?

2 6444

What is power play plug in?

2 6008

Which kind of index is preferred in DWH?

2 10529

Post New Informatica Questions

Un-Answered Questions { Informatica }

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1666

What is the Rank index port in Rank transformation?

1051

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1261

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1486

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2451

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1077

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2158

permutations of mapplet

2509

What is the difference between a repository server and a powerhouse?

1503

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9815

Explain the etl program with few examples.

1046

what is unit testing?tell me proceedure

2219

What is a sequence generator transformation?

1010

What is joiner transformation in informatica?

1043

Explain the types of lookup transformation?

1041

For More Un-Answered { Informatica } Questions Click Here