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

Informatica Interview Questions

Questions Answers Views Company eMail

Define informatica repository?

Wipro,

2 12075

What are the types of metadata that stores in repository?

2 11048

What is tracing level and what are the types of tracing level?

TCS,

2 38135

What are Target Options on the Servers?

1 6055

What is Code Page Compatibility?

1 8883

What are Dimensions and various types of Dimensions?

PayPal, TCS,

3 42369

Why we use lookup transformations?

1 6319

If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

TCS,

5 19127

Explain about perform recovery?

1 6799

How to recover sessions in concurrent batches?

1 12267

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 6411

How to recover the standalone session?

2 9476

What is difference between maplet and reusable transformation?

2 9972

What are the data movement modes in informatcia?

3 7612

What are the out put files that the informatica server creates during the session running?

2 7861

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain constraint based loading in informatica

1093

What are the types of caches in lookup? Explain them.

969

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3870

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

1068

Where are the source flat files kept before running the session?

1076

Explain in detail about scd type 1 through mapping.

1553

What are the different lookup cache(s)?

1118

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

1078

What is the benefit of session partitioning?

1116

What do you mean by channel change?

1043

Differentiate between a repository server and a powerhouse?

1118

Explain the aggregator transformation?

1164

Define sessions in informatica etl?

1034

How to load last n records of file into target table - informatica

1081

How to go to the older version for a mapping?

1098

For More Un-Answered { Informatica } Questions Click Here