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 12066

What are the types of metadata that stores in repository?

2 11038

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

TCS,

2 38115

What are Target Options on the Servers?

1 6053

What is Code Page Compatibility?

1 8871

What are Dimensions and various types of Dimensions?

PayPal, TCS,

3 42355

Why we use lookup transformations?

1 6309

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

TCS,

5 19103

Explain about perform recovery?

1 6781

How to recover sessions in concurrent batches?

1 12242

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

2 6398

How to recover the standalone session?

2 9465

What is difference between maplet and reusable transformation?

2 9963

What are the data movement modes in informatcia?

3 7597

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

2 7853

Post New Informatica Questions

Un-Answered Questions { Informatica }

EXL informatica Questions

1383

What are ETL Tools?

1110

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

1067

What are the types of data warehouses?

1514

Can anyone tell me the new features in Informatica 9 Version?

2118

How to partition the Session?

1105

Explain scd type 3 through mapping.

989

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1662

What is complex mapping?

1113

What are junk dimensions?

1061

What is informatica?

1144

Explain the tuning lookup transformation - informatica

988

How does a rank transform differ from aggregator transform functions max and min?

1200

How to update source definition?

1082

What is data movement mode in Informatica and difference between them?

1129

For More Un-Answered { Informatica } Questions Click Here